Services for SQL Server 2000

• K. Brian Kelley

  SSC Guru

  Points: 114703

  More actions

  December 30, 2001 at 12:00 am

  #78229

  Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/bkelley/services.asp

  K. Brian Kelley
  @kbriankelley

• sstrate

  Grasshopper

  Points: 23

  More actions

  May 12, 2006 at 7:35 am

  #637539

  A couple of notations.  You state:

• SQL Mail requires a MAPI profile.  As a result, if SQL Mail is to be used, a domain account is necessary.
• SQLAgent Mail also requires a MAPI profile.  It too requires a domain account in order to be used.

This is incorrect.  We are running our SQL Servers with local IDs on the server and are using SQL Mail successfully to notify us via page of any alert conditions. You just have to setup the mail profile on the server under the ID you are using to run BOTH SQLServer and SQLServerAgent.