Cannot connect to MICROSOFT##SSEE SQL 2005 instance using SQL Server Management Studio

Chris_PP
Chris_PP used Ask the Experts™
on
I cannot connect to it anymore using server\Microsoft##SSEE or just server name. I get a (Provider: SQL Network Interfaces errror: 26- Error locating Server/Instance Specified)  

Basically I'm trying to connect to my SharePoint Services 3.0 and then figure out how to move the SharePoint_Config_log.LDF file from C drive to another drive, it's 12GB and I have 0 space left on the C drive due to this. We are a Public school here in Florida and don't have the luxury of a DB admin or Server Admin. We really need some help!!!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Jamie McAllisterCloud Expert
Most Valuable Expert 2013
Top Expert 2014

Commented:
Hi,

OK I think you'll find the following thread useful Basically you need to truncate your log file to free up some space, and halfway down there's a command line command to do it, rather than Management Studio.

http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/MS-SharePoint/Q_23180766.html

As for Management Studio, sounds obvious perhaps, but double check what server name you're putting in to connect (a file extension or some such accidentally appended). *Could* be the disk issue that's causing that, we shall see.

Author

Commented:
Few things with that thread, doesn't recognize sqlcmd, is that something I download? Also I cannot connect to database with SQL Server Management Studio, which I think he found the solution using it.
Jamie McAllisterCloud Expert
Most Valuable Expert 2013
Top Expert 2014

Commented:
You're trying to run sqlcmd in C:\Program Files\Microsoft SQL Server\80\Tools\Binn right?
Acronis in Gartner 2019 MQ for datacenter backup

It is an honor to be featured in Gartner 2019 Magic Quadrant for Datacenter Backup and Recovery Solutions. Gartner’s MQ sets a high standard and earning a place on their grid is a great affirmation that Acronis is delivering on our mission to protect all data, apps, and systems.

Author

Commented:
Yes, I don't see that sqlcmd in there at all.
Jamie McAllisterCloud Expert
Most Valuable Expert 2013
Top Expert 2014

Commented:
You could try typing "where sqlcmd.exe"  on the cmd line.

You have me wondering if client tools have been installed here. You are doing this on the SQL Server box itself, not a desktop?

Author

Commented:
yes through RDC.

I ran that on CMD and it came back INFO: could not find files for the given pattern(S).
Jamie McAllisterCloud Expert
Most Valuable Expert 2013
Top Expert 2014

Commented:
You can copy it onto there with a few other dependencies as this brave soul did;

http://social.msdn.microsoft.com/Forums/en/transactsql/thread/784deef7-369a-4bb5-bd37-be7d015b6a4c

I am going off line for a while - it's home-time here. Will check back on this thread from home.

Author

Commented:
I was able to connect using SQL Management Studio Express using \\pipe direct path and I see the SharePoint database. Can anyone help me telling me how to move that SharePoint_Config_log.LDF and database to my large drive?
Cloud Expert
Most Valuable Expert 2013
Top Expert 2014
Commented:
Jamie McAllisterCloud Expert
Most Valuable Expert 2013
Top Expert 2014

Commented:
Success?

Author

Commented:
No, haven't found a clear way to move the database to another drive.
Jamie McAllisterCloud Expert
Most Valuable Expert 2013
Top Expert 2014

Commented:
Now that you can use Management Studio again I'd have thought the above links covered everything for moving to a new drive.

What do you feel you are missing?

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial