SA Password change doesn't 'take' on SQL 2000!?

Question

I'm having really bizarre issue:

When I change the 'sa' account password on SQL 2000, I get no error but the password doesn't actually change!  It stays the old password.

I've tried using Enterprise Manager and the 'sp_password' methods and in each case, it acts like it succeeded - in the case of 'sp_password', it returns "Password Changed."

However when I try logging back in as 'sa' to test the change, it says the new password is invalid, and ends up taking the old password to login!

I've tried shutting down/restarting, it makes no difference..

The irony is that I'm trying to change the password so that doing an SQL 2005 Upgrade will continue..  the upgrade stops because it requires a complex 'sa' password, which our evidently isn't complex enough..

If it matters, this is "test Virtual Machine" running under Hyper-V where we cloned a live physical server to the VM to test the SQL 2000 to SQL 2005 upgrade prior to doing it on the live server.  (I've read that changing the computer SID on SQL 2005 causes issues, but the registry entries mentioned don't appear to exist in SQL 2000 so I'm not sure if having the computer SID change is a problem with SQL 2000..)

Any help appreciated!!

  --Chad Rogers

Answer 1

Not sure exactly what I did, but I eventually got the password change to 'stick'...

Never mind.  :-|

  --Chad Rogers