Enterprise Manager Registration

Hi
I have an SQL Server(2000) registration(SQL Authentication:sa).
I changed the sa password and deleted the registration
Now I cannot re-create the registration using:
User=sa
Password=newpasssword
An error occured: Login failed for user 'sa'...
I re-put the old password(another registration on another PC) and the problem persist(on my PC)
Note: I made a successful registration using another login name and password but not for 'sa'
Any help will be very appreciated
Thanks in advanc
Regard
G.HaddadJouj wrote:
> Hi,
> I have an SQL Server(2000) registration(SQL Authentication:sa).
> I changed the sa password and deleted the registration.
> Now I cannot re-create the registration using:
> User=sa
> Password=newpasssword
> An error occured: Login failed for user 'sa'...
> I re-put the old password(another registration on another PC) and the
> problem persist(on my PC). Note: I made a successful registration
> using another login name and password but not for 'sa'.
You must have entered/changed the sa password wrong... try changing it again
and see if it fails with "Old (current) password incorrect for user. The
password was not changed." with your newpassword
sp_password @.old = 'old_password' , @.new ='new_password', 'sa'
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.|||hi
The new(previous) password is correct 100%, from another machine I can connect
Only from my PC I cannot neither using Enterprise manager nor the Query Analyzer
I suspect that it's a matter of registry :S
Thanks agai
Regards
G.Haddad