Unable to connect to SQL Database (can the password be reset)

Posted by user45450 on Server Fault See other posts from Server Fault or by user45450
Published on 2010-06-10T10:18:47Z Indexed on 2010/06/10 10:23 UTC
Read the original article Hit count: 202

I have recently joined a company which has an SQL 2005 Server running a few databases.

The server looks like no one has touched it in a couple of years and has this week it ran out of disk space.

After a quick hard drive scan it looks like some of the databases have become a little bloated and particularly the Sharepoint_config~*~_log and WSS_Content_log.ldf have grown to about 15GB.

I have been able to log into a couple of the other databases and use the shrinkfile command to free up disk space but for some reason I am unable to log into the sharepoint and Microsoft#SSEE databases (which gives me the "cannot connect to Sharepoint, a network related or instance specific error occurred..." when I try and connect)

I can see that the database is running via the SQL surface configuration and I have made sure that the remote connection settings allow me to connect locally but I am still unable to log in either with windows authentication or locally.

Is there any way to reset or recover the database login details so I can get in?

( I have tried logging in with all the administrative passwords I can find and after tracking down the company who installed it in the first place I found out that they have no idea what the password could have been)

© Server Fault or respective owner

Related posts about sql-server-2005

Related posts about password-recovery