SQL 2005 SQL Agent Mail

[divinyl]

Hi all

We are trying to get away from using the SQL Agent Mail solution in SQL 2000. Having to set up a MAPI profile under the service account is a bit of a nightmare and doesn't seem to work on all our servers. I have seen a few solutions around which i'm going to try out.

However, in 2005 I have read about Database Mail but as I have not installed 2005 yet, i haven't had a chance to try it out. My question is - will we be able to avoid having to log on as the necessary service account and seting up a MAPI profile? I've reead up on this but still can't figure out if we'll be able to avoid this.

Thanks
Div

 

[mrdenny]

Correct you do not have to setup a MAPI profile to use Database Mail. Database mail using SMTP and can be completly configured via T/SQL.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[divinyl]

Thanks Denny - but can this also be used for SQL Server Agent alerting? A colleague of mine tells me you can't - you still have to follow the same process for 2005!!

Thanks
Div

 

[mrdenny]

You most definetly can use database mail for SQL Agent alerting, provided you configure the agent to use database mail instead of sql mail.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[divinyl]

Thanks!! This would really be an end to a lot of our build issues (all resolvable but a pain in the behind none-the-less!

Will install 2005 within the next couple of weeks and try this out..

Div