I am bunch of error messages getting in my sql serror log:
Login failed to user " " Reason: Failed to open the explicitly open the specified Database 'DB' [Client: <Local Machine>]
I tried to troubleshoot as it's a Error: 18456 and State:38.
I found that one of my database is is not exists and other user error is due to database is offline.
Database is not exists or offline so it's not showing under user mapping but somewhere its keep trying to connect that not exists or offline DB.
How can i find that this user from where trying login as it says Local Machine?
I want to stop this error message so need to know how i can as this user is tied with other database but login failed to which Db is not exists or offline DB.
Keep in mind that i can't drop user as these users are mapped to another Databases too.