SQL Mail

• Garutyunyan

  SSCrazy

  Points: 2629

  More actions

  August 28, 2002 at 10:03 pm

  #58027

  Hi folks,

  I created a user account and added it to the Administrator group. I started the MSSQLSERVICE and SQLSERVERAGENT with that account. I want to set up that account to enable email. If anyone can tell me what the next step is, it will be greatly appreciated. Setting up SQL mail is one of my weeker points in SQL Server, so please, bare with me...

  Thank you

• K. Brian Kelley

  SSC Guru

  Points: 114642

  More actions

  August 28, 2002 at 11:17 pm

  #435594

  Outlook will need to be on the system.

  Log on as the user account you've used for a particular service. Create a new profile which connects to your mail server. Test sending e-mail from Outlook. If that's okay, then you're ready to set up SQLMail in SQL Server. Go to properties for SQL Server Agent to pick a profile or properties under Support Services | SQL Mail.

  Here are some relevant Microsoft KB articles which should provide some pointers and additional assistance:

  • INF: How to Configure SQL Mail (http://support.microsoft.com/default.aspx?scid=kb;en-us;q263556)
  • INF: Frequently Asked Questions - SQL Server - SQL Mail (http://support.microsoft.com/default.aspx?scid=kb;en-us;q311231)
  • INF: Common SQL Mail Problems (http://support.microsoft.com/default.aspx?scid=kb;en-us;Q315886)

  K. Brian Kelley

  http://www.truthsolutions.com/

  Author: Start to Finish Guide to SQL Server Performance Monitoring

  http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

  K. Brian Kelley
  @kbriankelley