troubleshooting Question

I cannot access my sql database.

Avatar of Mavriikk
Mavriikk asked on
Microsoft SQL ServerMicrosoft SQL Server 2005Microsoft SQL Server 2008
6 Comments4 Solutions368 ViewsLast Modified:
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
ASKER CERTIFIED SOLUTION
VENKAT KOKULLA
SQL Server DBA

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 4 Answers and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 4 Answers and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros