Hello,

I am trying to configure SQL Mail on a Windows 2000, sp4 server with SQL
2000 Standard, sp4.  I have installed Outlook 2003 and setup the profile on
the system with the same account as the one used to start the sqlserver and
sqlagent services.

When I go to test the profile for SQL Mail, I receive the following error:

Error 18025: xp_test_mapi_profile: failed with mail error 0x80070057

Any ideas?

It's fun to answer your own posts, but here goes.

I have figured this one out for myself, but in case someone else runs into
the same problem, here goes:

1. Make sure you have the latest service pack (4) installed for SQL
2. Create a domain account that will be used to run the MSSQLSERVER and
SQLAGENT services on the sql server.
3. Create an email account for the new user account in step 2. (again, if
using outlook, an exchange account will do nicely)
4. Install a MAPI email client, preferably Outlook 2000 or better on the SQL
Server.
5. Log on to the SQL Server as the service account.
6. Setup Outlook or your mail client to use the profile you logged in with. 
Verify that it works correctly and that the Mail applet in Control Panel
defaults to this profile.
7. In services, configure the MSSQLSERVER service and the SQLAGENT service
to use the account you are logged in with.
8. Stop the MSSQLSERVER service, which stops the SQLAGENT service as well. 
Then start both services.
9. In Enterprise Manager, go to the SQL Mail properties box and select the
profile labeled "Outlook" or whatever profile name is given to your account
if using another email client.
10. Click Test to verify.

The step I was missing was logging onto the server as the actual account
used for the services and the email profile.

Hope this helps someone else.
Show quoteHide quote

Recovery Model Question.
bcp - Run time file name generation
How to generate drop and recreate index script in SQL Management S
HELP!!! --- From Job tasks to ASP
How to Measure TPM Tool?