I have been trying to set up sql server mail. We do not have exchange running on the same server, so we are trying to use VMS mail. All things look good, I sent up a valid mapi profile, tested it and was able to receive mail from sql server. However, when I try to set up an operator and test out the email address I get the 22022 error. Any ideas??

-- Anonymous, February 09, 2000

Answers

Christine,

There are separate configurations for SQLServer's mail profile and SQLServerAgent's mail profile. You can use the same profile for both, but you need to define them both.

The mail profile for SQLServerAgent is responsible for sending e-mail notifications to operators while the mail profile for SQLServer is responsible for xp_sendmail. You can configure the SQLServerAgent's profile via the Agent's properties dialog box.

Try to log on your Windows NT box as the SQL Server Agent NT user account. Then create the mapi profile for it. Logoff , and try again. It should work.

Eric

-- Anonymous, February 13, 2000