I can not send Email from SQL Server !!!!

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » I can not send Email from SQL Server !!!!

I can not send Email from SQL Server !!!!

Rate Topic

Display Mode

Topic Options

Author

Message

mos-prog

Posted Tuesday, October 30, 2012 10:47 PM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, October 31, 2012 7:59 AM
Points: 10, Visits: 24

Hi every body,

I have big problem at least for me, i want to send an Email using SQL Server 2008,

this message appear: " Mail queued. "

but this error message appear is the Database Mail Log:

The SMTP server requires a secure connection or the client was not authenticated.

I make all steps right like this link:

http://www.idevelopment.info/data/SQLServer/DBA_tips/Database_Administration/DBA_20.shtml

Please do not tell me that: "You must do some thing wrong" no

I am sure that every thing and all steps is right,

I reinstalled new version of windows and SQL Server 2008 but the problem is still,

i tried with SQL Server 2005 but also the same problem:

The SMTP server requires a secure connection or the client was not authenticated.

The Firewall is turning off and i am also close my Antivirus but also no way,

I am also try with microsoft:

http://msdn.microsoft.com/en-us/library/ms190630%28v=sql.105%29.aspx

Please i need an advise from an Expert, it is big problem for me.

Post #1379147

mssqlsrv

Posted Tuesday, October 30, 2012 11:34 PM

Valued Member

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 1:32 PM
Points: 72, Visits: 244

check if you are able to telnet the SMTP server from sql server.
Also check the password you have provided for mail setup.

Post #1379150

mos-prog

Posted Tuesday, October 30, 2012 11:42 PM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, October 31, 2012 7:59 AM
Points: 10, Visits: 24

I send many Emails before by the STMP Server through Visual Studio and it send successfully,

no problem with the STMP Server or my credentials

Post #1379152

mssqlsrv

Posted Wednesday, October 31, 2012 12:02 AM

Valued Member

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 1:32 PM
Points: 72, Visits: 244

Check the below link.

http://social.technet.microsoft.com/Forums/en-AU/exchange2010/thread/b6e99b1e-790c-4694-82da-57c2ea7db52b

Post #1379153

mssqlsrv

Posted Wednesday, October 31, 2012 12:12 AM

Valued Member

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 1:32 PM
Points: 72, Visits: 244

Also check the SSL setting in mail profile.

PFA

Post Attachments

d.png (9 views, 39.37 KB)

Post #1379154

mos-prog

Posted Wednesday, October 31, 2012 12:12 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, October 31, 2012 7:59 AM
Points: 10, Visits: 24

Thank man, but how to reach this setting >> HT server configuration ??

Post #1379155

« Prev Topic | Next Topic »

Permissions