eclipsenet
asked on
SQL Server Error: 4060 for deleted database Error: 18456 Login failed for user
SQL Server 2005 Management/SQL Server Logs are writing errors every minute for a database that has been deleted. Messages are:
[298] SQLServer Error: 4060, Cannot open database "DatabaseName" requested by the login. The login failed. [SQLSTATE 42000].
[298] SQLServer Error: 18456, Login failed for user 'domain\username'.. [SQLSTATE 28000].
How do I inform SQL that the subject databases are gone and there's no need to clutter the logs?
[298] SQLServer Error: 4060, Cannot open database "DatabaseName" requested by the login. The login failed. [SQLSTATE 42000].
[298] SQLServer Error: 18456, Login failed for user 'domain\username'.. [SQLSTATE 28000].
How do I inform SQL that the subject databases are gone and there's no need to clutter the logs?
I would suggest locating the application that is constantly trying to connect and make it stop. That is going to be your best solution.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
BIngo. Thanks. We had a test MOSS2007 deployment that was decommisioned, and we didn't realize that the MOSS SSP instantiated a "...DeleteExpiredSessions" job on SQL.
ASKER
BIngo. Thanks. We had a test MOSS2007 deployment that was decommisioned, and we didn't realize that the MOSS SSP instantiated a "...DeleteExpiredSessions" job on SQL.
Deleting the appropriate job under SQL Server Agent/Jobs did the trick.
Craig
Deleting the appropriate job under SQL Server Agent/Jobs did the trick.
Craig