SQL mail

[dpops]

Hi Gurus,

I was trying to set up SQL mail on a sql enterprise/Win 2K box. I logged in as myself which is the user the SQL server starts on. I configured a email profile with the copr exchange server with my mail box. Starts outlook fine. But when I tried to test the same profile name in the Support Services on mail property, it gives me SQL-DMO error, test failed. Any help is appreciated. I belive what I did is following the SQL on-line book. Thanks.

John

 

[tlbroadbent]

Check out the following links.

INF: How to Configure SQL Mail

http://support.microsoft.com/default.aspx?kbid=263556

HOW TO: Troubleshoot SQL Mail with Microsoft Exchange Server

http://support.microsoft.com/default.aspx?kbid=153159

INF: Common SQL Mail Problems

http://support.microsoft.com/default.aspx?kbid=315886

If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[dpops]

Thanks. Got the SQL mail test pass now.

John