In the majority of cases when you encounter a problem with SQL Server Mail or with the SQL Server Mail Agent you...
will find that your security settings for accounts are at fault. Problems with SQL Server Mail can be encountered even when your enterprise mail service is operating correctly.
The first issue to look at is whether the mail client in question is using the same account as your SQL Server Service. To do so, open the Services tool from the Administrative Tools folder in Windows 2000 or the Services control panel in Windows NT. The two accounts should be the same.
Next check if SQL Server uses the same account under which you have configured your mailbox. Finally, check to see that your mail messaging service is properly configured. To check your mail service, open the Mail control panel and examine its properties.
You should be logged onto SQL Server Mail under the same domain account you used to run the SQL Server Service. You may need to modify the properties of the account in the Services control panel if that is not the case. You need to enter the domain password in order to access the mail services.
Barrie Sosinsky is president of consulting company Sosinsky and Associates (Medfield MA). He has written extensively on a variety of computer topics. His company specializes in custom software (database and Web related), training and technical documentation.