Database Mail - Client not authenticated Issue

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Database Mail - Client not authenticated...

11 posts, Page 1 of 2

1 2 »»

Database Mail - Client not authenticated Issue

Rate Topic

Display Mode

Topic Options

Author

Message

Solitary Reaper

Posted Thursday, January 10, 2013 4:19 AM

SSC Rookie

Group: General Forum Members
Last Login: Monday, May 13, 2013 10:46 PM
Points: 38, Visits: 242

Hi,

I have followed all the steps for configuring Database Mail as mentioned in the below link :
http://blog.sqlauthority.com/2008/08/23/sql-server-2008-configure-database-mail-send-email-from-sql-database/
While I am able to send mails through Outlook, I am unable to send through Database Mail or Send Mail Task in SSIS.

Please help.

Post #1405335

anthony.green

Posted Thursday, January 10, 2013 4:27 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

You will need to ensure that you have unblocked the database mail exe from any anti virus progress which block mass mail worms, and if using Microsoft Exchange as your SMTP relay, that the host you are sending mail from has connect and send permissions on the relay server, otherwise your mail server will reject your request.

Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1405338

Solitary Reaper

Posted Thursday, January 10, 2013 4:39 AM

SSC Rookie

Group: General Forum Members
Last Login: Monday, May 13, 2013 10:46 PM
Points: 38, Visits: 242

I have added DatabaseMail90.exe as an exception in my Antivirus Program.
I am also able to send mail through outlook.

Am i missing anything else?

Post #1405341

anthony.green

Posted Thursday, January 10, 2013 4:41 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

Outlook is for SQL Mail, not database mail, the two are completly different.

DBMail uses SMTP, you need to ensure that the SMTP server you have specified on the profile and account, allows you to connect to it and send mail via it, also ensure that the firewall rules allow you to communicate over the SMTP port number you have specified.

Post #1405342

Jason-299789

Posted Thursday, January 10, 2013 4:43 AM

SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 3:38 AM
Points: 803, Visits: 2,123

In terms of SSIS you may also have to apply the DataBaseMailUserRole permissions on MSDB to the SQL server Agent login or the account used in any proxy.

_________________________________________________________________________
SSC Guide to Posting and Best Practices

Post #1405344

Solitary Reaper

Posted Thursday, January 10, 2013 4:53 AM

SSC Rookie

Group: General Forum Members
Last Login: Monday, May 13, 2013 10:46 PM
Points: 38, Visits: 242

I have added an exception in Firewall.

Is there any way to check whether the SMTP server allow me to send mail via it?

Post #1405347

Jason-299789

Posted Thursday, January 10, 2013 5:05 AM

SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 3:38 AM
Points: 803, Visits: 2,123

You should be able to send a test email from under the Database mail option in SSMS, though I believe it uses the Users credentials rather than the server service credentials.

On SQL Agent set up a simple 1 step T-SQL job that does a select 1 and set the job to send email on success, then test as a manual run and also as a scheduled job to ensure it is using the sql agent service.

_________________________________________________________________________
SSC Guide to Posting and Best Practices

Post #1405349

atapia_

Posted Thursday, January 10, 2013 5:21 AM

Old Hand

Group: General Forum Members
Last Login: Thursday, January 10, 2013 5:15 AM
Points: 339, Visits: 71

Hi,

Different problems may be presenting themselves, to help you try to do the following steps:
1. Clean Database Mail Log
2. Execute a Database Mail - Send Test E-mail.
3. Copy and paste here the text in Database Mail Log.

If you have any questions you can ask.

Ing. Aneurys Tapia González
DBA + BI Architect
Dominican Republic
atapia@outlook.com | admin@atapia.net
http://sqlservermasbi.wordpress.com
http://atapia.net

Post #1405358

anthony.green

Posted Thursday, January 10, 2013 5:45 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

Solitary Reaper (1/10/2013)

I have added an exception in Firewall.

Is there any way to check whether the SMTP server allow me to send mail via it?

Ask your mail admin to perform diagnostic checks between the SQL server and the SMTP server.

You could also use TELNET over the SMTP port to see if the SMTP server accepts your connection.

Post #1405363

Lowell

Posted Thursday, January 10, 2013 6:33 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 5:04 AM
Points: 11,614, Visits: 27,671

if you are getting "client not authenticated" , that means you already have connectivity to the mail server, because it's returning errors.

i think "client not authenticated" could mean one of two things:

you have connectivity to the SMTP of the mail server, but either you set up anonymous authentication when username and password is required,
or
that the setting for windows authentication was used, but the service running SQL server is not an authorized mail user, i think.

does that sound right?

otherwise i'd expect no such user or invalid password if you passed SMTP AUTH credentials.

can you double check that the info used below is actually a valid mailbox on your SMTP server?

Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son

Post #1405386

« Prev Topic | Next Topic »

11 posts, Page 1 of 2

1 2 »»

Permissions