i am having this error message in sql error log kindly advise where to start looking for the solution
That message is in the SQL Server error log? That is somewhat unexpected, because this is the message you would see at the client. The message in the SQL ERRORLOG when someone tries to login on the server, providing a non-existing database in the connection string is like this:
Login failed for user 'SOMMERWALD\sommar'. Reason: Failed to open the explicitly specified database 'kkkk'. [CLIENT: <local machine>]
Possibly this could be an error from attempt to access a linked server set up with MSDASQL (rather than the normal SQLNCLI11). But a login error on a linked server would normally not result in a message in the SQL Server error log. For that to happen, it would have to be some system process of some sort. For instance, an activation procedure for Service Broker.
Or are you actually looking in the Windows Event Log?
Hi
@k shaz
,
Please refresh databases list check if ABC database still exist in your SQL instance. Please check the information around the error message to find some useful information. Or you can share us a screenshot about your issue.
Best regards,
Cathy
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our
documentation
to enable e-mail notifications if you want to receive the related email notification for this thread.
