• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 351
  • Last Modified:

FORGOT Superuser password

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
0
BahagiaSinaga
Asked:
BahagiaSinaga
  • 8
  • 4
2 Solutions
 
richardburwoodCommented:
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.
0
 
BahagiaSinagaAuthor Commented:
what meaning for mixed mode authentication??
0
 
richardburwoodCommented:
When you install SQL server you have the option of confiuring the server to use internal authentication (i.e. you provide a username & password) or mixed mode authentication (i.e. you can provide a username & password or the system will use your windows login details to authenticate you).

Logon to the SQL Server machine as an Administrator
Open SQL Server Enterprise Manager

If mixed mode authentication is configured you will have full access to SQL Server Enterprise Manager without entering a username and password.
0
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 
BahagiaSinagaAuthor 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.
0
 
BahagiaSinagaAuthor 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
0
 
BahagiaSinagaAuthor 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
0
 
richardburwoodCommented:
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.
0
 
BahagiaSinagaAuthor Commented:
already in enterprise manager, but how to change or check the username and password.
Thanks
0
 
BahagiaSinagaAuthor Commented:
OK here is the answer :

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.
0
 
richardburwoodCommented:
That is exactly what I told you to do in comment #3
0
 
BahagiaSinagaAuthor 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.
0
 
BahagiaSinagaAuthor 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).
0
 
modus_operandiCommented:
Restarting auto-close process on BahagiaSinaga's behalf.
 
modus_operandi
EE Admin
0

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

  • 8
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now