Regarding SQL Server Service Account

  • I have a question related to SQL Server Service Account. I am in the process of setting up a SQL Server 2008 R2 installation on a Cluster. I would like to know whether it is recommended to have separate service accounts for SQL Server and SQL Server Agent services? If this is so, could you please what is the advantages of doing so? My Cluster service account is different in any case. Thanks!

  • Separation of duties.

    Check here: http://msdn.microsoft.com/en-us/library/ms143504.aspx

    ----------------------------------------------------------------------------
    Sacramento SQL Server users group - http://sac.sqlpass.org
    Follow me on Twitter - @SQLDCH
    ----------------------------------------------------------------------------

    Yeah, well...The Dude abides.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply