SQL Server 7.0 Unlock

Is there any way to open or get scripts for a database that is password protected by another user?
LVL 4
sublimationAsked:
Who is Participating?
 
arbertConnect With a Mentor Commented:
You should still be able to login as a domain admin and get into the database.
0
 
arbertCommented:
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.
0
 
sublimationAuthor Commented:
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.
0
 
Scott PletcherSenior DBACommented:
>> 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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.