FORGOT Superuser password

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.

what meaning for mixed mode authentication??

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.

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

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.

already in enterprise manager, but how to change or check the username and password.
Thanks

That is exactly what I told you to do in comment #3

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.

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).

Restarting auto-close process on BahagiaSinaga's behalf.
 
modus_operandi
EE Admin