Share via

What happens if I change the NT Service \ MSSQL $ SQLEXPRESS account of a SQL Server service?

AngieLeytonC 1 Reputation point
2021-03-18T01:22:01.497+00:00

Hi, I need to configure a task to make a backup of my database in a network location, this I have only achieved by changing the user of the SQL Server service for another user account with permissions in my network location, for this reason I want to know what happens if I change the NT Service \ MSSQL $ user of this service?

Thanks,

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,104 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,582 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Cheong00 3,471 Reputation points
    2021-03-18T01:47:48.503+00:00

    I think if you make sure the new account have full access to the Data and Log path, then it should be okay.

    You may also need to grant Launch and Activation permission to "Microsoft SQL Server Integration Services <version>" in "Component Services" of Control Panel. Check event viewer and see if you need to do that after change.

    Of course, if you switch account of service using that "SQL Server Configuration Manager" tool that's installed with SQL server, then it should have made the relevant changes for you.

  2. CathyJi-MSFT 21,111 Reputation points Microsoft Vendor
    2021-03-18T09:10:42.403+00:00

    Hi @AngieLeytonC ,

    For SQL server service account, we can use below accounts;

    • Domain user account
    • Local User Accounts
    • Local Service Account
    • Network Service Account
    • Local System Account

    Suggest you read MS document Description of Service Accounts to better understand the service accounts.

    > do you know if there is any Microsoft document that describes the permissions that this account must have?

    SQL Server service accounts must have access to resources. Such as some files, registry key , etc.

    Refer to MS document Configure Windows Service Accounts and Permissions to get detail information.

    If the response is helpful, please click "Accept Answer" and upvote it, thank you.

    0 comments