I configure backup DB on a network drive. Backup is performed through the agent, the agent uses not the domain account, but its NT Service \ SQLSERVERAGENT.

In the sql server configuration manager I want to change the login to the account with admin rights, but the default is NT Service \ SQLSERVERAGENT with a password, but I don’t have a clue what the password is. And when installing, I do not remember asking.

Why is this account password protected? And if I change the login to the admin account, will the access error (5) stop when the backup, which occurs, I think, due to the lack of permissions of NT Service \ SQLSERVERAGENT on the network drive, stops?

  • There is an assumption that there is no password, and the asterisks just stand for the mind? Switched the start of the service to the admin account, the network drive through the backup wizard sees, but at the very start an error (5) crashes in access. What rights to assign? If sysadmin, then it stops seeing network drives - GRM

1 answer 1

EMNIP, for SQL Server'a important uchetka, from under which the service of the server itself, and not the agent.

If you change the account to run SQL Server to an account that has access rights to the ball, access problems must go away, just pay attention that the account must have sufficient rights in the system running SQL Server.

For simplicity, you can give this account administrator rights, although from the point of view of information security is not quite the right decision.

  • And it is necessary to restore the database from this account too? - GRM
  • When restoring a database, access will be checked for the same account, the account under which SQL Server is running. - minamoto