| Author |
Messages |
|
Pete (guest)
 |
| 06/18/2008 7:53 AM |
 Quote
 Reply
 Alert
|
Hands up who been really stupid.... okay it's me.
I've managed to lock myself out of my dev db (SQL 2005 Developer Edition). I somehow dropped my login (trusted AD) while scripting a DB and can't remember the sa password I set (should have used blank ;-().
Is there any way of getting back in without resorting to a full re-install?
TIA
Pete |
|
|
|
|
Chip Andrews
Posts:113
|
| 06/22/2008 12:16 PM |
Quote
Reply
Alert
|
Pete,
There is a great article on this issue here:
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
The jist is that you need to start SQL Server in maintenance mode and add the privs back so you can log in as an admin.
Chip
|
|
|
|
|
|
|
|
|
|
Quick Reply |
 |
|
|
|