Post reply

Best practice for SSDE account?

  • June 30, 2010 at 10:56 am

    #141149

    Hi all,

    What is the best practice for the SQL Server Database Engine account to use during SQL server installation?

    Currently we use a domain account, would a local account be better suited for this?

  • June 30, 2010 at 11:38 am

    #1187248

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

    BoL has great info...on that page check out 'Viewing Windows permissions for SQL Server Services'.

    There's a MS white paper also, google 'microsoft best practices sql server', you'll find a link on the fourth one down.

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

    Yeah, well...The Dude abides.

  • June 30, 2010 at 3:51 pm

    #1187366

    Thanks Dan.

  • June 30, 2010 at 3:55 pm

    #1187368

    I've typically used a domain account, no rights (except Everyone or what the service specifically needs on the network). I don't think there's a fundamental reason to do this over a local account, except that there might be some reason you access resources from SQL Server on the network. Easier to set this up now than change it later.

Viewing 4 posts - 1 through 3 (of 3 total)

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