Tip

Tips for troubleshooting SQL Server mail

Barrie Sosinsky, Contributor

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.


    Requires Free Membership to View

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.


This was first published in March 2005

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

Disclaimer: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.