Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
abc
Starting Member
48 Posts |
 Posted - 2002-01-04 : 21:06:04
|
| hi guruI have a problem need to help. Yesterday, I used SQL Enterprise to change pass for sa by "Edit SQL Server Registration Properties", there war no problem for change. But today, when I reconnect to SQL sever, I can't login with sa login. The prblem is failerue login for sa. So I try to change the pass for sa by "Edit SQL Server Registration Properties", but it appear the same error. Help me plsThanks for your attention |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2002-01-05 : 05:50:45
|
| how are you connecting to SQL Server ? Do you have a DSN with SQL Server authentication in it that also uses the sa login ? I would hope not but... |
 |
|
|
Rafiq
Starting Member
25 Posts |
Posted - 2002-01-05 : 06:19:43
|
quote:
I have a problem need to help. Yesterday, I used SQL Enterprise to change pass for sa by "Edit SQL Server Registration Properties", there war no problem for change. But today, when I reconnect to SQL sever, I can't login with sa login. The prblem is failerue login for sa. So I try to change the pass for sa by "Edit SQL Server Registration Properties", but it appear the same error. Help me pls
Hi,Try to do like this.I think it will solve your problem.Login to the SQL Server computer as the Administrator of that computer. Open Query Analyzer and connect to SQL Server using Windows NT authentication. Run sp_password as show below to reset the sa password:sp_password @new = 'i_never_forget_again', @loginame = 'sa'Regards,Rafiq------------------------------------If you think, you can do anything... |
|
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-01-05 : 10:00:08
|
| Wait a minute... The "Edit SQL Server Registration properties" in EM does not allow you to change passwords -- it simply allows you to specify the credentials that Enterprise Manager will pass to SQL Server next time it tries to connect. In other words, I strongly suspect that your old sa password was never changed. To get you up and running again, you can either do as Rafiq suggests or just go back to your "Edit SQL Server Registration" dialog and type in your old password in the Password box. Click "OK". Then right-click on your server and choose "Connect". That should get you up and running. In the future, when you want to change passwords (for sa or any other login) -- use Rafiq's solution, or if you want to do things through EM go to Server\Security\LoginsEdited by - izaltsman on 01/05/2002 10:00:27 |
|
|
|
abc
Starting Member
48 Posts |
Posted - 2002-01-07 : 04:19:02
|
| Unfortunately, I setup SQL server on window 98 OS, so I can't login as window NT administrator, so I can't change the password as Rafiq's solution. What have I do ???Thanks for your attention |
|
|
|
abc
Starting Member
48 Posts |
Posted - 2002-01-07 : 04:38:50
|
| oh, at last I can login sa with old password. Thanks izaltsman, your explain help me understand exactly the meaning of "Edit SQL Server Registration properties", relying on that I know what have I do. Thanks all of you.Thanks for your attention |
|
|
|
|
|
|
|
|
Miss Password for sa