question

AngieCast-4552 avatar image
0 Votes"
AngieCast-4552 asked Cathyji-msft commented

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

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-generalsql-server-transact-sql
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @AngieCast-4552,

We have not received a response from you. Did the replies could help you? If the response helped, do "Accept Answer". If it is not, please let us know. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

1 Vote 1 ·
cheong00 avatar image
0 Votes"
cheong00 answered ErlandSommarskog commented

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.

· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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

0 Votes 0 ·

No, but as long as you use SQL Server Configuration Manager tool to change it then it should be okay. AFAIK this is also the only supported way to change service account for SQL server.


0 Votes 0 ·

And to clarify, SQL Server Configuration Manager will take care of the permissions, so you are good to go.

0 Votes 0 ·
Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered

Hi @AngieCast-4552,

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.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.