SQL Server 7.0 Unlock

Posted on 2004-04-26
Medium Priority
Last Modified: 2008-02-01
Is there any way to open or get scripts for a database that is password protected by another user?
Question by:sublimation
  • 2
LVL 34

Expert Comment

ID: 10920014
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.

Author Comment

ID: 10920053
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.
LVL 34

Accepted Solution

arbert earned 1000 total points
ID: 10920063
You should still be able to login as a domain admin and get into the database.
LVL 70

Expert Comment

by:Scott Pletcher
ID: 10920911
>> 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.

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

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.

Join & Write a Comment

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
In this article, we will show how to detach and attach a database and then show how to repair a corrupt database and attach it, If it has some errors. We will show how to detach and attach using SSMS or using T-SQL sentences.
Viewers will learn how the fundamental information of how to create a table.
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question