Application logs error (start)
SQL Database 'XXXX' on SQL Server instance 'np:\\.\pipe\MSSQL$Microsoft##SSEE\sql\query' not found. Additional error information from SQL Server is included below.
Cannot open database "XXXX" requested by the login. The login failed.
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
(end log data)
After taking over an SBS 2008 server I have the above 3760 error occuring about every 5 minutes in the application logs.
XXXX = database name
History, or the closest thing to it, of what I can figure out has occurred.
1) Company XXXX (same name as database) is a vendor for my client
2) No one at my client or the vendor remembers ever creating a database or installing anything on the SBS 2008 server.
3) Client does remember just deleting the database becuase it's logging files had grown so big and no one knowing what it was for.
4) About every five minutes I get the error.
Everything that I've found so far points me to going into the properties for NT AUTHORITY\NETWORK SERVICE and making sure it is a DBO for the database... well the database is gone.
I have looked through IIS admin for any possible application/website that may be referencing this database. either I'm looking in the wrong place or it doesn't exits.
Ditto for looking in Sharepoint administrator.
I am looking for suggestions on how to clean this error out and resolve the problem.