UNSOLVED

Aegh

updated

7 years ago

A

Aegh

1 Rookie

84 Posts

0

1386

November 4th, 2019 16:00

SQL Backup configuration

Hi Guys,

Everytime when we have a new SQL backup server configuration, we always need to ask DBA to manually add "NT AUTHORITY\SYSTEM" to the sysadmin role in MSSQL Server.

nsrsqlsv: The server principal "NT AUTHORITY\SYSTEM" is not able to access the database "Instance" under the current security context.

Is there any way we can automate this?