Start an instance

Posted on 2008-11-10
Last Modified: 2012-05-05
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?
Question by:mte01
    LVL 60

    Accepted Solution

    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.
    LVL 7

    Assisted Solution

    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)

    LVL 7

    Expert Comment

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

    Author Comment


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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Introduced in Microsoft SQL Server 2005, the Copy Database Wizard ( is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
    Introduction In my previous article ( I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
    Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now