Saturday, August 01, 2009

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

Labels: , , , , ,

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home