Database Mail setup

Question

Database Mail setup

Animal Magic

SSChampion

Points: 13964
More actions
January 7, 2008 at 3:39 am

#120072

Hi All,
I am currently upgrading one of our sql boxes to sql 2005 and i have setup database mail which works fine, however one problem i am finding is that when i send a mail using the db_send_mail i have to specify the full email address, ie johnm@mycompany.co.uk whereas with sql 2000 and xp_sendmail i could just send to johnm.
Have i missed something in the config or is this just the way it is in 2005?
Regards
John

Viewing 9 posts - 1 through 8 (of 8 total)

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

VastSQL SSC-Dedicated Points: 36121 More actions · Answer 1

Database Mail and SQL Mail both are different and DB mail requires SMPT Server.Higher versions of SQL Server dont have SQL Mail by default.

Check these links

http://technet.microsoft.com/en-us/library/ms175887.aspx

http://technet.microsoft.com/en-us/library/ms177418.aspx

Animal Magic SSChampion Points: 13964 More actions · Answer 2

Thanks for the response, however i understand that the two mail types use different protocols, i just dont understand why sql mail will resolve names without the domain and db mail wont.

VastSQL SSC-Dedicated Points: 36121 More actions · Answer 3

Hope u have outlook express on ur machine and mail configured on that..

Animal Magic SSChampion Points: 13964 More actions · Answer 4

What would having outlook express on my machine do for me?

VastSQL SSC-Dedicated Points: 36121 More actions · Answer 5

VastSQL

SSC-Dedicated

Points: 36121

January 7, 2008 at 8:41 am

#765374

Dont u have mail configures on ur system???

Animal Magic SSChampion Points: 13964 More actions · Answer 6

Yes we have an exchange server and the profile i am using is on that server. Database mail is configured to use a profile called syssql and the test etc works fine, sp_send_dbmail works fine, the agent notifications to operators works fine. I dont have an issue with the profile.

My question was why i have to write the whole email address ie johnm@mycompany.co.uk and i cant just write johnm, as i always used to on the other servers

MIJ SSCommitted Points: 1915 More actions · Answer 7

In SQL 2005, SQL Mail (which I believe is equivalent to the way SQL 2K sends email) uses an Exchange profile, which is what allows it to talk to Exchange and resolve short names and correctly address email. Database Mail, on the other hand, just uses an SMTP server, which doesn't know anything about your Exchange server, so you have to provide a complete email address.

Animal Magic SSChampion Points: 13964 More actions · Answer 8

MIJ (1/7/2008)
In SQL 2005, SQL Mail (which I believe is equivalent to the way SQL 2K sends email) uses an Exchange profile, which is what allows it to talk to Exchange and resolve short names and correctly address email. Database Mail, on the other hand, just uses an SMTP server, which doesn't know anything about your Exchange server, so you have to provide a complete email address.

Excellent, cheers MIJ. Bit of a pain in the backside but at least now i know i didnt miss something.