Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Error while Configuring Database Mail - sql server

Author  Topic 

vaddi
Posting Yak Master

145 Posts

Posted - 2006-11-04 : 22:35:43
Hello

I am configuring the Database mail in sql server 2005.

While I am doing the following:



EXECUTE msdb.dbo.sysmail_add_profileaccount_sp
@profile_name = 'DBA Profile',
@account_name = 'DBA MailAccount',
@sequence_number = 1



Msg 14607, Level 16, State 1, Procedure sysmail_verify_profile_sp, Line 42
profile name is not valid

I have added the profile with the statements using :

EXECUTE msdb.dbo.sysmail_add_profile_sp
@profile_name = ' DBA Profile',
@description = 'Profile used for database mail'

what should I do

Thanks
Dushyanth

vaddi
Posting Yak Master

145 Posts

Posted - 2006-11-04 : 23:39:50
Hello

I have configured the databasemail using the wizard, when I do the test mail , I receive it , but when I use it to get job mail notifications , I donot receive any mails.

What might be going wrong.

Thanks
Go to Top of Page

EugeneZ
Starting Member

26 Posts

Posted - 2006-11-05 : 13:19:24
read:
Troubleshooting Database Mail: Profile not valid
http://msdn2.microsoft.com/en-us/library/ms175984.aspx


check:
Database Mail in SQL Server 2005
By Muthusamy Anantha Kumar aka The MAK
http://www.databasejournal.com/features/mssql/article.php/3626056
Go to Top of Page

hthan
Starting Member

1 Post

Posted - 2006-11-07 : 14:14:51
I got the same problem. Finally I found out the tricky part is after you setup DB mail and successfully tested, you must restart SQL Agent (required) using Surface Area Configuration.

hth,
Go to Top of Page
   

- Advertisement -