I done following steps for configure via SMTP mail notification 1. xpsmtp80.dll - download and placed in Bin folder this path Crogram FilesMicrosoft SQL ServerMSSQL$BKUPEXECBinn 2. exec sp_addextendedproc 'xp_smtp_sendmail', 'xpsmtp80.dll' exce the above command in master databse, 3. grant execute on xp_smtp_sendmail to public 4. declare @rc int exec @rc = master.dbo.xp_smtp_sendmail @FROM = N'servername@ril.com', @FROM_NAME = N'servername', @TO = N'useremail@ril.com', @CC = N'', @BCC = N'', @priority = N'normal', @subject = N'Hello SQL Server SMTP Mail', @message = N'Goodbye MAPI, goodbye Outlook', @type = N'text/plain', @attachments= N'', @server = N'IPaddress' select RC = @rc go The above script i got test main in my mailbox, it was working fine. I have created maintenance plan for db backup, at the end tab i had choose the Emailing report to operator, but it was fail, the error messages Error 21776: [SQL-DMO]The name 'ananda.murugesan@ril.com' was not found in the Operators collection. If the name is a qualified name, use [] to separate various parts of the name, and try again. Please tell me, what i should look? thanks
How to create smtp mail account not in POP3? we are using only smtp. I could tried but it was not hope.. the following error display Emailing report to operator 'sqlmailsend' [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 18025: [Microsoft][ODBC SQL Server Driver][SQL Server]xp_sendmail: failed with mail error 0x80004005thanks Here xp_sendmail: i could not get, but smtp using by xp_smtp_sendmail only. Pl can anyone suggestion me, what exact problem? thanks.
