Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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)

share|improve this question
add comment

2 Answers

You could try the Dedicated Admin Connection (sqlcmd -E -S [ServerName] -A) logged directly into the machine from a cmd window in a system account. Reset the sa password to something else and then log in normally as sa.

share|improve this answer
add comment
up vote 0 down vote accepted

Woo finally got there in the end. Tried a dedicated admin connection but It still did not understand where the database was (even though it gave me the database name in the drop down menu),

after a bit of fiddling managed to pipe directly to the database and squashed the bloated beast right down,

directory path was something like this: \.\pipe\mssql$microsoft##ssee\sql\query

from here I was able to log in with the standard admin password for that server.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.