March 14, 2016 at 10:51 am
Hi All,
I am seeing the login failures in the logs daily and several times.
Login failed for user 'sa'. Reason: Failed to open the explicitly specifieddatabase. [CLIENT: <local machine>]
sa has sysadmin permission and in enabled status.
From event viewer also I can see the same Failure Audit. In addition to that I can see additional error under database category like SQL Database 'dbname' on SQL Server instancce 'Instancename' not found.
Cannot open database 'dbname' requested by the login. The login failed.
Login failed for user 'sa'
When I check the db under the instances there is no such db with that name.
How can I found the where they pointed that db name which doesn't exists any more because it is trying to connect from local server only. There is nothing I can see that pointed to that db
March 14, 2016 at 10:59 am
Change the default database for sa to master.
John
March 14, 2016 at 11:56 am
The default database for sa is master only.
From the eventviewer I can see the Source is "Windows Sharepoint Services 3".
March 14, 2016 at 1:55 pm
It sounds like you need to find out where the connection is coming from, check the default trace.
You'll either need to modify the connection string to point to a database that exists, or possibly just stop the app from trying to connect (if it's a retired system).
March 15, 2016 at 8:53 am
Looks the connection is coming from local host only.
The source is windows sharepoint services3.
I am trying to find the path for the sharepoint config file where it has SQL Connections.
March 15, 2016 at 1:01 pm
I found the link
which is similar to the second one. Event ID: 3760.
Haven't tried but looks it is promising
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply