| Author |
 Topic  |
|
|
vaddi
Posting Yak Master
145 Posts |
 Posted - 11/04/2006 : 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 - 11/04/2006 : 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 |
|
|
hthan
Starting Member
1 Posts |
Posted - 11/07/2006 : 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, |
|
|
| |
Topic |
|
Error while Configuring Database Mail - sql server
