October 8, 2007 at 9:59 am
I followed the steps to set up a new email account in SQL 2005, as follow:
STEP 1: (enable the Database Mail )
use master
go
sp_configure 'show advanced options',1
go
reconfigure with override
go
sp_configure 'Database Mail XPs',1
--go
--sp_configure 'SQL Mail XPs',0
go
reconfigure
go
STEP 2: (create the account)
EXECUTE msdb.dbo.sysmail_add_account_sp
@account_name = 'DBA',
@description = 'Mail account for CAR Database Mail',
@email_address = 'myemail@popmanager.com',
@display_name = 'Client Account Review',
@username='myUserName',
@password='myPassword',
@mailserver_name = 'myserver.com'
STEP 3: (create a Mail profile)
EXECUTE msdb.dbo.sysmail_add_profile_sp
@profile_name = 'CAR',
@description = 'Profile used for CAR database mail'
STEP 4: (add the Database Mail account to Mail Profile)
EXECUTE msdb.dbo.sysmail_add_profileaccount_sp
@profile_name = 'CAR',
@account_name = 'DBA',
@sequence_number = 1
STEP 5: (grant the Database Mail profile access to the msdb public database role / make profile as default Database Mail profile)
EXECUTE msdb.dbo.sysmail_add_principalprofile_sp
@profile_name = 'CAR',
@principal_name = 'public',
@is_default = 1 ;
Unfortunatelly the email is not going out. The mail logs show the following erro:
"The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2007-10-08T11:24:06). Exception Message: Cannot send mails to mail server. (Command not implemented. The server response was: Command not Supported). )"
What am I doing wrong?
Thanks,
October 8, 2007 at 10:27 am
Please see my today's reply to homebrew01 at
http://www.sqlservercentral.com/Forums/Topic406836-146-1.aspx
Regards,Yelena Varsha
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply