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
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
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.