We help IT Professionals succeed at work.

FORGOT Superuser password

BahagiaSinaga
on
Medium Priority
400 Views
Last Modified: 2013-11-05
Dear all experts team,
I have been installed SQL Server 2000 before, but sadness i forgot the superuser password since i need to access the server to install the new application.
Please if you have any suggestion.
Thanks.

BR//
BAHAGIA
Comment
Watch Question

Was the computer setup for Mixed authentication? Try loging onto the server directly using an Administrator account. If the SQL server was setup for mixed mode authentication you should then have access.

Author

Commented:
what meaning for mixed mode authentication??
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Sorry, I used mixed mode.

but when i try installed The Application, it show me about the parameter question that I should answer.
and one of the parameter is full fill the sa superuser name and password.

Please how to check of my password before. so i can full fill the parameter question.
Thanks.

Author

Commented:
Other thing I found some suggestion from internet...

as the instruction bellow :

osql -U sa -P "" -Q "sp_password NULL,<newpassword>,sa"

MySQL
First stop mysql from running ( service mysqld stop ) Then run mysql safe . . .
mysqld_safe --skip-grant-tables
then
mysql --user=root mysql
then use the following command:
update user set Password=PASSWORD('new-password') where user='root'; flush privileges; exit;
and finally restart mysql again



Please if anyone who ever try this solution.. isn't it save for the DB Server???
Since my DB Server still using as the active server with live application.
Thanks

Author

Commented:
Other thing I found some suggestion from internet...

as the instruction bellow :

osql -U sa -P "" -Q "sp_password NULL,<newpassword>,sa"

MySQL
First stop mysql from running ( service mysqld stop ) Then run mysql safe . . .
mysqld_safe --skip-grant-tables
then
mysql --user=root mysql
then use the following command:
update user set Password=PASSWORD('new-password') where user='root'; flush privileges; exit;
and finally restart mysql again



Please if anyone who ever try this solution.. isn't it save for the DB Server???
Since my DB Server still using as the active server with live application.
Thanks
ok, if you are currently installing SQL server you need to specify the sa details. If you have already installed the SQL server you need to go into SQL Server Enterprise Manager as described above and you can then change the sa password.

Author

Commented:
already in enterprise manager, but how to change or check the username and password.
Thanks
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
That is exactly what I told you to do in comment #3

Author

Commented:
Sorry richardburwood,
Your statement only be understood with people which is not in stress and under pressure situation .
actually I just try to inform and clarify the detail step.

Many thanks for your help.

Author

Commented:
OK here is the answer : an also based on Expert guidance towards this solution in Step#5

IF using mixed mode authentication.
Open the SQL Server Enterprise Manager
then choose the Console Root
Choose Microsoft SQL Servers
Choose SQL Server Group
Chose (Local)(Windows NT)
Chose Security
Chose Logins
then choose the sa user (double klik)
Then it will pop up the window of SQL Server Login Properties - sa
Just write the new password.

PROBLEM SOLVED


Thank you for you suggestion richardburwood (Step #3 and #5).
CERTIFIED EXPERT

Commented:
Restarting auto-close process on BahagiaSinaga's behalf.
 
modus_operandi
EE Admin
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.