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 |
|
Han
Starting Member
2 Posts |
 Posted - 2005-08-05 : 03:53:12
|
| Is it possible to rewrite the SA password of SQL server 2000 with service pack 3 when i can not connect op de database.I have installed an application with an internal SQL standaard edition database. In the installation the application generated a password and i can not connect with my SQL server to the database.Can somebody tell me if it is possible to make a new user to admin. the database?ThanksHan |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-08-05 : 04:51:40
|
| If SQL has a login for BUILTIN\Administrators you ought to be able to do a Windows Authentication login, then you can change the SA password in the normal way.If not ... does the application allow any form of SQL to be sent to the DB? If you you might be able to use that to issue some SProc calls to create login, and then add Server Role to loginKristen |
 |
|
|
Han
Starting Member
2 Posts |
Posted - 2005-08-05 : 07:40:12
|
| Thank, I solved the problem.First i attached the master.mdf to another database.After that i allowed modifications to the catalog.And then it is very simple overwrite the xdate1 xdate2 and password in the sysxlogins table of the mounted master.mdf.Use the data of a sysxlogins sa users with a known password.the last stap is to detache the master and restart the orginanal database. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-08-05 : 08:26:15
|
| Interesting approach!Kristen |
|
|
|
|
|
|
Changing the SA password