set up sql mail

[maswien]

I wanted setup SQL mail and followed the BOL, but I have no idea if I did is right, I got error : " error 18025, xp_test_mapi_profile ...", how to setup it correctly? Thanks

 

[Catadmin]

Have you verified that your SQL Mail is mapped to a live Exchange Mail profile?

SQL Server Agent (and I believe SQL Server) need to be mapped to a user name with a valid email profile from your Exchange Server. You might want to verify with your Messaging Team that they have something set up for you.



Catadmin - MCDBA, MCSA
Remember, "Work" is a four letter word. And you know what your mother told you about using four letter words!

 

[mrdenny]

This FAQ get you going faq962-4452.

Denny

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

http://www.mrdenny.com

(My very old site)

 

[Dukester0122]

Try this link:

http://www.databasejournal.com/features/mssql/article.php/3424791