Contents
What is System NT Authority?
The account NT AUTHORITY\System which is a Local System account.. It is a powerful account that has unrestricted access to all local system resources. It is a member of the Windows Administrators group on the local computer, and is therefore a member of the SQL Server sysadmin fixed server role.
How do I enable NT Authority system?
Right-click on NT AUTHORITY\SYSTEM and select Properties. This opens the Login Properties window. Select Server Roles and from the Server roles list on the right, select sysadmin. Click OK to confirm the roles selected for System account.
Why do I get error for NT authority?
When I try to access my database from within the application, i.e. open a SQL connection, I get the following error all the time: I tried to add NT AUTHORITY/SYSTEM to SSMS (SQL Server Management Studio) logins, but it was already a principal, showing the following error: Allow NT AUTHORITY/SYSTEM to server Role as sysadmin.
Finally I set the pool identity on LocalSystem and thought why it might be preventing “NT AUTHRITY\\SYSTEM” from opening a connection to my database. I opened up SQL Server Management Studio as “Administrator” and checked the Server Roles for NT AUTHORITY\\SYSTEM under “logins” section. The default server role for this user was public by default.
Allow NT AUTHORITY/SYSTEM to server Role as sysadmin. I tweaked the application settings a lot, changing the application pool’s identity (in Windows 8.1’s IIS) to LocalSystem, LocalService, NetworkService, and ApplicationPoolIdentity.
Why is my T-SQL Agent job failing?
I have setup a T-SQL job in the SQL Server Agent to run weekly. Within SQL Server Management Studio I am able to run the script successfully as a query but when the job runs it errors out saying: “Executed as user: DOMAIN\ser. User does not have permission to perform this action.