Post reply

What you use for service account

  • April 2, 2015 at 4:05 pm

    #295638

    I would like to know for SQL server 2008 or later, that is on windows 2008 r2 and later, what service account do you as DBA usually use for SQL services account on the server that has SQLserver service, SQL server agent service, SSIS service, SSRS service.

    Are you using a domain user account? Virtual account, Managed account or something else?

    Currently we are using a domain account, something like ourdomain\sys$SQL01, because we often have SSIS packages running on the SQL server, that may pull data from another server, so the domain service user account can be granted for access across network.

    Virtual account and managed account are some new for me, we have not used much in our environment.

    Are you using them, or like me still use a domain account?

    What is your recommendation for new SQL server installation?

    Thanks

  • April 3, 2015 at 11:39 am

    #1788636

    Domain accounts have worked just fine for me for many years.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

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

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