May 14, 2018 at 9:37 am
Hey guys,
I am getting this in my errorlog, I am unable to find the cause, does any one know what is this about, thanks in advance
Error: 18456, Severity: 14, State: 73.
Login failed for user 'domain1\user1'. Reason: Failed to open the database 'uxxxxx_prod' configured in the session recovery object while recovering the connection. [CLIENT: xx.xx.xx.xx]
May 14, 2018 at 9:43 am
Have you tried opening a different instance of SSMS?
OK, that was a wild assumption.
Are there any other error 18456s from the same time? Say, State 38?
Thomas Rushton
blog: https://thelonedba.wordpress.com
May 14, 2018 at 9:48 am
yes and it did work, however I am not able to find what caused it
May 14, 2018 at 12:33 pm
Had the database been dropped and recreated between you connecting to it and you then attempting to query it?
Thomas Rushton
blog: https://thelonedba.wordpress.com
May 14, 2018 at 1:02 pm
well this was a copy of a prod database, that i used to recover some data, the database was restored with stopat timestamp and recoverd
May 18, 2018 at 5:30 am
This was removed by the editor as SPAM
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy