Recovering access to a SQL db
Our database on the server hosting our clients suddenly stopped allowing access (for some reason it got put into windows authentication mode, we don't know how). With the sa password not around I used this great solution to set up a login via windows authentication so I could login and change the authentication mode.
http://blogs.msdn.com/raulga/archive/2007/07/12/disaster-recovery-what-to-do-when-the-sa-account-password-is-lost-in-sql-server-2005.aspx
http://blogs.msdn.com/raulga/archive/2007/07/12/disaster-recovery-what-to-do-when-the-sa-account-password-is-lost-in-sql-server-2005.aspx

0 Comments:
Post a Comment
Subscribe to Post Comments [Atom]
<< Home