SQL Server 7.0 Unlock
Is there any way to open or get scripts for a database that is password protected by another user?
SQL Server databases aren't password protected. If you use the SA account or logon to windows as an administrator, you should be able to access anything in the database.
ASKER
Hi, arbert.
Somebody has set the database so that only they can use it and that person is no longer at the company. They set themselves as the system admin.
Somebody has set the database so that only they can use it and that person is no longer at the company. They set themselves as the system admin.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>> You should still be able to login as a domain admin and get into the database. <<
Even if he/she removed the BUILTIN login?
You might want to search the web using Google or Teoma -- it's my understanding that SQL p/ws are rather weakly encoded and I think you may find some good "cracking" code.
Even if he/she removed the BUILTIN login?
You might want to search the web using Google or Teoma -- it's my understanding that SQL p/ws are rather weakly encoded and I think you may find some good "cracking" code.