June 15, 2004 at 7:55 am
My partner installed a new version of software we use. We are testing now and he installed SQL 2000 which the software uses. He set the sa password, but now that it is installed and we try connecting to the database as sa, it says the password is wrong. Is there a way to reset it???
June 15, 2004 at 8:02 am
My mistake, it was MSDE 2000 A sql install
June 15, 2004 at 8:06 am
You have to have admin rights on the database. Do you have another account with that privilege? SQL Server (which MSDE is) has the account BUILTIN/ADMINISTRATORS. That account lets anyone who is a part of the administrators on the box access SQL Server as an admin. You could try that.
-SQLBill
June 16, 2004 at 8:19 am
To go along with SQLBill, here is a isql command to change the sa password using an account that is part of the BUILTIN/ADMINISTRATORS.
From a dos window...
isql -d master -U <admin user> -P <admin user's password> -S <server> -Q "exec sp_password NULL , '<new sa password>', 'sa'"
Tom
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply