The SQLServer account is the same account I am using for email. I installed Outlook 2000, set up corporate/workgroup account back to our exchange server. I am able to send and receive email via Outlook with the same SQLServer account configured to start SQLServer.
It has been a while since I set one of these up, but I believe the SQLAgent service must be running under the same NT logon that created the exchange profile you want to use. Like I say, it has been a while since I set one of these up, so have those grains of salt at the ready ;-).
1. As someone has already pointed out, the SQL mail profile must exist for the SQL Agent service account. This means that you must configure outlook while logged in as SQL Agent.
2. You don't mention what you're outlook is connecting to (Exchange, Lotus or POP3). I have had nothing but heartache when trying to connect to Lotus. It is doable, but like I said, it gave me nothing but heartache. Same with setting up Outlook to connect to a standard POP3 account. Nothing but a trail of tears (okay, that may be an exaggeration, but you get the picture).
Originally posted by Cassy
I am receiving this error message when I try to configure and test the mail session
Error 18030 : xp_test_mapi_profile
I check the Outlook2000 is the default mail client and it is.
I am running SQL Server 2000, Server Pack 3
SQLmap70.dll is 12/17/2002 located in the bin directory.