Start an instance

Hey experts,

 I have a named SQL Server 2005 instance installed on a server, and I got a problem with the client program(s) on the machine that access it (i.e. I can't run Management Studio right now), so any idea on how to start this instance using some isql command (or something like it), because I am sure that the instance is still there and not corrupted. And once I've started the instance, I should be able to access it normally from another machine; any idea how to start it?
LVL 3
mte01Asked:
Who is Participating?
 
chapmandewCommented:
right click my computer and go to manage.  when that opens, open up Services...find MSSQLServer and start it.  you can select properties for the services and set it to autostart when windows starts.
0
 
Cedric_DCommented:
only Administrator of server can start/stop services on it.

If you (user logged on) is in Administrators group of target server, then
you may issue:

sc \\SERVERNAME start MSSQLService

(to exact service name, see Services snap-in)


0
 
Cedric_DCommented:
... when you still have some connection problems, you can switch to TCP/IP protocol with the fixed port at server side.
0
 
mte01Author Commented:
>>chapmandew

Yep; that did the trick; many thanks for your help!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.