Database Mail - Client not authenticated Issue

Question

Database Mail - Client not authenticated Issue

Solitary Reaper

Right there with Babe

Points: 718
More actions
January 10, 2013 at 4:19 am

#266929

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.

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

Ant-Green SSC Guru Points: 113507 More actions · Answer 1

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.

Solitary Reaper Right there with Babe Points: 718 More actions · Answer 2

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?

Ant-Green SSC Guru Points: 113507 More actions · Answer 3

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.

Jason-299789 SSC-Insane Points: 21601 More actions · Answer 4

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

Solitary Reaper Right there with Babe Points: 718 More actions · Answer 5

I have added an exception in Firewall.

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

Jason-299789 SSC-Insane Points: 21601 More actions · Answer 6

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

atapia_ SSC-Addicted Points: 487 More actions · Answer 7

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

Ant-Green SSC Guru Points: 113507 More actions · Answer 8

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.

Lowell SSC Guru Points: 323518 More actions · Answer 9

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

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Solitary Reaper Right there with Babe Points: 718 More actions · Answer 10

Thanks all!! 🙂

Finally, I am able to send a Test Mail from "Database Mail".

But, when i configure an operator and include it in a Job, it throws me an error "Failed to notify ''operator name'' via email"

I followed the steps mentioned in the below topic

http://www.sqlservercentral.com/Forums/Topic253575-149-1.aspx

Still I get the same error.

Please help.