SQL Server 2012 Login failed for user 'NT AUTHORITY\SYSTEM'
Posted on 2013-10-10
so i installed SCOM 2012 the other day, and i was getting errors on from my SQL server that the SPN was not set.
so, i go and set the SPN..... setspn -A MSSQLsvc/servername:1433
It successfully registered the SPN.
then, no one could access the server, and SharePoint gave an error that it could not connect to the configuration database.
Removing the SPN through adsiedit, fixed the problem, but we are getting additional errors in our SQL logs,
Login failed for user 'NT AUTHORITY\SYSTEM' reason: failed to open the explicity specified database 'dbname' [client IP: which is the sqlservers ip]
the SQL trace logs, show the same type of error, but specifiy the Windows script host as the application name
this has been going on for a few days, and to my knowledge nothing has changed in AD
when i run this query
SELECT auth_scheme FROM sys.dm_exec_connections WHERE session_id = @@spid ;
the response comes back as NTLM