Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Password Recovery

Author  Topic 

Mondeo
Constraint Violating Yak Guru

287 Posts

Posted - 2008-10-03 : 05:12:59
Hi,

Is there any way to recover the sa password if you have access to the mdf/ldf files?

Thanks

YellowBug
Aged Yak Warrior

616 Posts

Posted - 2008-10-03 : 08:14:03
I don't fully understand. Can you provide more information.

Do you have a SQL Server running and cannot connect as sysadmin? If so, this link may help:
http://blogs.msdn.com/raulga/archive/2007/07/12/disaster-recovery-what-to-do-when-the-sa-account-password-is-lost-in-sql-server-2005.aspx

Go to Top of Page

Mondeo
Constraint Violating Yak Guru

287 Posts

Posted - 2008-10-03 : 09:22:02
We've got an application running which someone built for us, however that company has since gone out of business. The application uses a local instance of SQL Express. It works fine however we need to get some information out of it which is not provided in the standard reports, normally we would ask the company to produce a custom report, but obviously this is not an option now.

I've tried to connect to it using integrated authentication but that didn't work, we have access to the actual mdf files as these are on the local machine, I was hoping there was a way of extracting the password and then building the custom reports ourselves.

Thanks
Go to Top of Page
   

- Advertisement -