| Author |
 Topic Search  Topic Options
|
piyanong 
Newbie
Joined: 29 October 2004
Location: Thailand
Status: Offline
Points: 2
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: I loss my sa password, Help me please.
Posted: 29 October 2004 at 10:59am |
|
Now I use MSSQL server 2000 and I loss my sa password. I was deleted the builtin/Administrator user. now i can't cannect to SQL server help me please.
|
 |
dpyers
Senior Member
Joined: 12 May 2003
Status: Offline
Points: 3937
|
Post Options
Thanks(0)
Quote Reply
Posted: 29 October 2004 at 12:38pm |
If you lost the password for your sql server account login, you'll have to contact the server administrator/web host to assign a new one to your account.
If you lost the password for the webwwiz "Administrator" ID, use Enterprise Manager or some 3rd party mssql admin tool to login to your data baseand:
- Open up the Authors table.
- If there's a record for the Administrator, blank out the User Code, Password, and Salt fields.
- If there's no Administrator record, copy the Guest record then blank out the User Code, Password, and Salt fields, Change Author_ID and Group_ID to 1, and change the User ID to Administrator.
- You should then be able to login to wwg after that without a password.
|
Lead me not into temptation... I know the short cut, follow me.
|
|
Mart
Senior Member
Joined: 30 November 2002
Status: Offline
Points: 2304
|
Post Options
Thanks(0)
Quote Reply
Posted: 29 October 2004 at 12:52pm |
|
It sounds like it is his own SQL Server because he is saying he lost his 'sa' password, as you deleted the builtin/administrator user I am not sure how you get in.
|
|
dpyers
Senior Member
Joined: 12 May 2003
Status: Offline
Points: 3937
|
Post Options
Thanks(0)
Quote Reply
Posted: 29 October 2004 at 1:04pm |
lol - If it's his own sql server, there's probably a reinstall in his future 
|
Lead me not into temptation... I know the short cut, follow me.
|
|
michael
Senior Member
Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
|
Post Options
Thanks(0)
Quote Reply
Posted: 29 October 2004 at 1:54pm |
|
The easiest way around this is to logon to the actual SQL Server NT machine itself as administrator. Then connect to SQL Server using any of the tools and specify "." as the server name and ask for a trusted connection. As long as the admins group hasn't been explicitly removed from having sa rights then you should connect ok and be able to reset the password.
If you're in mixed-mode and you know the NT userid of someone with sa rights, then get their password reset and logon/connect as them.
Otherwise you can try and find a dba's machine who already has the server registered to SQL EM with sa and use that copy of SQL EM to connect.
If all these fail then you'll have to rebuild master and re-attach all the user databases.
|
|
|
|
michael
Senior Member
Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
|
Post Options
Thanks(0)
Quote Reply
Posted: 29 October 2004 at 1:56pm |
Oh and if you really need to rebuild the master do this
|
|
|
|
piyanong
Newbie
Joined: 29 October 2004
Location: Thailand
Status: Offline
Points: 2
|
Post Options
Thanks(0)
Quote Reply
Posted: 02 November 2004 at 9:26am |
To michael.
Thanks a lot for any idea. But i try using any of the tools and specify "." as the server name and ask for a trusted connection, it fails. If you have tool that may connect it, tell me please.
My server in mixed mode but it deleted builtin/administrator user. that i try use Windows authentication fail.
If do I rebuilt Master database that mean I set the new password and loss of any database in Master too?
If any way to connect it tell me please.
|
|
michael
Senior Member
Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
|
Post Options
Thanks(0)
Quote Reply
Posted: 02 November 2004 at 9:34am |
|
well if you cannot find any way of connecting to your sql server (not sure if it's possible to actually delete builtin/administrator only disabling it) but i take your word for it.
If you rebuild the master database you will of course not have any other databases attached. Any customizations you made to your sql server will be lost. But you can simply re-attach all existing databases and you are pretty much back at square one.
|
|
|
|
