Avatar of Mavriikk
Mavriikk
 asked on

I cannot access my sql database.

All,

New to a company with a lot of skeletons. Seems previous administration was poor at documentation. Actually i think they purposely failed to document things because of fear of loosing their jobs. lol

Here is the situation. We have a particular website hosting a database that has table with millions of lines in it. The data lives on a sql 2000 database and no one in the company has the SA password. We have talked to nearly everyone who has ever touched the database on this particular server and have had no luck at all.

The reason for needing the SA password is because we are trying to export the data to a newer more up to date sql server. We can do this via the command line in the sql 2000 but only with the sa account credentials.  

Please help me extract my valued data. I am positive their is a way to get the SA account password because i spend most of my day trying to prevent these kinds of things from attacking my sa accounts in the firewall.

Regards,

Last resort admin
Microsoft SQL ServerMicrosoft SQL Server 2005Microsoft SQL Server 2008

Avatar of undefined
Last Comment
VENKAT KOKULLA

8/22/2022 - Mon
SOLUTION
Aeriden

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Mavriikk

ASKER
Thank you for your post.

We are not trying to reset the password for fear that it will break a cash cow money making site that is still working.

What we are trying to do is gain access to the current password so we can then export the data and move it to a more stable environment.
Mavriikk

ASKER
Also this server is not on a domain. Old old old windows 2k server hence why it is so important to upgrade it.
SOLUTION
Aeriden

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER CERTIFIED SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Your help has saved me hundreds of hours of internet surfing.
fblack61