SQL Server 2012 Login failed for user 'NT AUTHORITY\SYSTEM'

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

any ideas?
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Daniel WilsonCommented:
What service is believed to be trying to connect to the server and asking for that DB?  Is it possible to run it as a named user rather than as SYSTEM?  If you run it as a named user, e.g. MyAppUser, setting permissions for it on the DB should become simpler.
NuttyBarAuthor Commented:
i am not totally sure,  the ip address that the login failures are coming from are all local

when i look at the "user mapping" for nt auth, it shows only a couple of DB;s that are mapped to the login,  

it shows:  
sharepoint admin
sharepoint config
wss content

looking at it closer, it looks like it is failing on the Masterdb,  so i added that to the user mapping

the errors seem to come every 15mn,  so i will check back in a little bit to see if they continue.
NuttyBarAuthor Commented:
this is what the errors in the trace log were

Audit Login Failed      
Microsoft ® Windows Script Host      
115      2013-10-10 11:21:11.997      
1 - Nonpooled      0            0      3945            
Login failed for user 'NT AUTHORITY\SYSTEM'. Reason: Failed to open the explicitly specified database 'DQS_MAIN'. [CLIENT: 10.*.*.*]      1      
38      18456      master      1 - Non-DAC
Your Guide to Achieving IT Business Success

The IT Service Excellence Tool Kit has best practices to keep your clients happy and business booming. Inside, you’ll find everything you need to increase client satisfaction and retention, become more competitive, and increase your overall success.

NuttyBarAuthor Commented:
Still getting the errors
NuttyBarAuthor Commented:
Date            10/10/2013 2:21:18 PM
Log            SQL Server (Current - 10/10/2013 2:06:00 PM)

Source            Logon

Error: 18456, Severity: 14, State: 38.
NuttyBarAuthor Commented:

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
NuttyBarAuthor Commented:
I did the research and figured it out
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.