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, 2010 at 10:07 PM in Default

avatar 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, 2010 at 05:00 AM

avatar image

David Wimbush
10.7k 31 34 43

(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.


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

more ▼

answered Mar 10, 2010 at 11:09 AM

avatar image

Jason Crider
453 11 12 15

(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, 2010 at 10:04 AM

avatar image

Jack Corbett
1.1k 3 4 7

(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.

Follow this question

By Email:

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



Answers and Comments

SQL Server Central

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



asked: Feb 22, 2010 at 10:07 PM

Seen: 2179 times

Last Updated: Feb 23, 2010 at 06:23 AM

Copyright 2018 Redgate Software. Privacy Policy