• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 186
  • Last Modified:

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?
  • 2
2 Solutions
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.
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)

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

Yep; that did the trick; many thanks for your help!

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now