x

SQL Server 2005 Database Email Not Sending

I am having a problem with my SQL Server 2005 database email not sending emails to a user with a hyphen in the domain of their email address. (i.e. user@email-address.com).

According to the msdb.sysmail_mailitems table the email is being sent without error and everyone else who is on the recipients list is receiving the email just not the individual with the hyphen in the domain name of the email address.

The user explained that the email is not in their spam/junk folder.

Any thoughts?

more ▼

asked Feb 22 '10 at 10:07 PM in Default

Chris 1 1 gravatar image

Chris 1 1
1 1 1 1

(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first

I would get the recipient to check with their IT guys. Some mail servers are quite picky about which emails they deliver to the target mail account. Try sending a test email to them from SQL and get them to have their IT guys look for it in their mail server to see what happens to it. You might need to tweak the mail profile you've set up for SQL.

more ▼

answered Feb 23 '10 at 05:00 AM

David Wimbush gravatar image

David Wimbush
4.7k 28 29 31

(comments are locked)
10|1200 characters needed characters left

One thing that I think about is how the hyphen can cause problems in objects. I know that for me I would normally have to put brackets around an object with a dash in it.

Example:

Object-1 would have to be [Object-1]

more ▼

answered Mar 10 '10 at 11:09 AM

Jason Crider gravatar image

Jason Crider
453 10 10 12

(comments are locked)
10|1200 characters needed characters left

Can you successfully send an email to them through the email server you are using for DB Mail? Have you verified that the email address is entered correctly?

All the "Sent" status means is that the SMTP server accepted the email from database mail, it doesn't mean you have a valid email address or that it left the SMTP server.

more ▼

answered Mar 16 '10 at 10:04 AM

Jack Corbett gravatar image

Jack Corbett
1.1k 2 2 3

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1933
x29

asked: Feb 22 '10 at 10:07 PM

Seen: 1745 times

Last Updated: Feb 23 '10 at 06:23 AM