Login failed for user 'NT AUTHORITY\SYSTEM' I tried to add NT AUTHORITY/SYSTEM to SSMS (SQL Server Management Studio) logins, but it was already a principal, showing the following error:
One solution is to change the SQL server security settings and grant an appropriate role to the NT AUTHORITY\System user which allows a process running as the localsystem user to create the.
Find weather NT AUTHORITY\SYSTEM is present. If not, Right click on users, Click on new user In new user window, general tab change the user type to windows user. Select the User name to, NT.