TitleistDBA
IS-IT--Management
I've just been handed a sql server 2000 sp4 install without the sa password. To make matters worse the built in admin has been removed. Short of re-installing is there a way in to the system to run sp_password
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
sa password lost
- Thread starter TitleistDBA
- Start date
- Status
Not really. Unless you have SysAdmin on the SQL Server, you can't get anything.
If you do have SysAdmin rights, just go to Security -> Logins -> right-click SA and go to properties and you can reset the password there.
Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"
If you do have SysAdmin rights, just go to Security -> Logins -> right-click SA and go to properties and you can reset the password there.
Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"
- Thread starter
- #3
TitleistDBA
IS-IT--Management
Unfortionatly, I can't get in at all. I think I'm going to have to stop the services, save off the database and re-install.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question