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.
Author |
Topic |
vaddi
Posting Yak Master
145 Posts |
Posted - 2006-11-04 : 22:35:43
|
HelloI 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 = 1Msg 14607, Level 16, State 1, Procedure sysmail_verify_profile_sp, Line 42profile name is not validI 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 doThanksDushyanth |
|
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 |
|
|
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.aspxcheck:Database Mail in SQL Server 2005By Muthusamy Anantha Kumar aka The MAKhttp://www.databasejournal.com/features/mssql/article.php/3626056 |
|
|
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, |
|
|
|
|
|
|
|