I loss my sa password, Help me please.
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=12355
Printed Date: 30 March 2026 at 3:54am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: I loss my sa password, Help me please.
Posted By: piyanong
Subject: I loss my sa password, Help me please.
Date 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. |
Replies:
Posted By: dpyers
Date 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:
------------- 
Lead me not into temptation... I know the short cut, follow me. |
Posted By: Mart
Date 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. |
Posted By: dpyers
Date 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. |
Posted By: michael
Date 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. ------------- http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker |
Posted By: michael
Date Posted: 29 October 2004 at 1:56pm
|
Oh and if you really need to rebuild the master do http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_install_8w8p.asp - this ------------- http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker |
Posted By: piyanong
Date 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. |
Posted By: michael
Date 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. ------------- http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker |