April 2, 2012 at 11:20 am
I configured Database Mail on a new server and it goes in the queue but it does not send the message.
I have tried all of the troubleshooting steps but no luck.
So then I tried sending CDONTS EMail on a Server from SQL Server 2008 R2 x64 on a Server running Windows Server 2008 R2 x64 and I get command successfully completed but I do not receive an email.
I do not believe that either problem is with SQL Server and I suspect it may be Windows related.
I'm trying to isolate the problem so I ran the following VBScript:
Set objMail = CreateObject("CDONTS.Newmail")
objMail.From = "username@mydomain.com"
objMail.To = "username@mydomain.com"
objMail.Subject = "Test"
objMail.Body = "Testing"
objMail.Send
Set objMail = Nothing
I get the following error:
ActiveX Component can't create Object CDONTS.NewMail Code: 800A01AD VBScript
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
April 2, 2012 at 11:42 am
CDONTs was a com object, and that error says it's not registered yet;
you may need to copy the dll to the server, and then register it.
http://www.jppinto.com/2009/03/install-cdonts-mail-component-and-smtp-on-windows-server-2008/
I know from your outer posts you had trouble getting regular db mail to work, but i would troubleshoot that before I'd use CDONTS.
Lowell
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy