+ Reply to Thread
Results 1 to 2 of 2

Starting SQL Server 2005 Manually

  1. Starting SQL Server 2005 Manually

    I am working on WinXP Pro & use SQL Server 2005 as the database server.
    Whenever I log into WinXP, I find that it takes considerable time to
    start (though the desktop appears in a jiffy). When I had a look at the
    processes running in my m/c by opening Task Manager & clicking the
    Processes tab, I found "sqlservr.exe" already running. I opened
    "Services" (from Control Panel-->Administrative Tools) & found that the
    "Startup Type" for "SQL Server (SQLEXPRESS)" was set to "Automatic" (&
    not "Manual").

    In order to lessen the time taken by WinXP to start, I changed the
    "Startup Type" of "SQL Server (SQLEXPRESS)" from "Automatic" to
    "Manual". This means that before I connect to SQL Server, I have to
    open "Services", right-click "SQL Server (SQLEXPRESS)" & then click
    "Start" from the context menu to start SQL Server. If I don't do so,
    then SQL Server generates the "Cannot connect to MyServer\SQLEXPRESS"
    error (where "MyServer" is the name of the database server).

    What I would like to know is instead of starting SQL Server in this way
    day in & day out to connect to SQL Server, is there any shortcut route
    by which I can start SQL Server whenever I want to work with SQL
    Server?

    Let me reiterate that I wouldn't prefer SQL Server starting
    automatically when the OS starts.


  2. Re: Starting SQL Server 2005 Manually

    You could open a command shell... start -> run ->
    and use
    'net start MSSQLSERVER'
    Or another example...

    'net start MSSQL$Instance'

    net start
    net stop
    vice versa

    There are also arguements you can pass when you start the server from
    the command shell
    They are located on:
    http://msdn2.microsoft.com/en-us/library/ms190737.aspx

    Write a batch file to simplify the process even more.


    On Dec 18, 9:51 pm, r...@rediffmail.com wrote:
    > I am working on WinXP Pro & use SQL Server 2005 as the database server.
    > Whenever I log into WinXP, I find that it takes considerable time to
    > start (though the desktop appears in a jiffy). When I had a look at the
    > processes running in my m/c by opening Task Manager & clicking the
    > Processes tab, I found "sqlservr.exe" already running. I opened
    > "Services" (from Control Panel-->Administrative Tools) & found that the
    > "Startup Type" for "SQL Server (SQLEXPRESS)" was set to "Automatic" (&
    > not "Manual").
    >
    > In order to lessen the time taken by WinXP to start, I changed the
    > "Startup Type" of "SQL Server (SQLEXPRESS)" from "Automatic" to
    > "Manual". This means that before I connect to SQL Server, I have to
    > open "Services", right-click "SQL Server (SQLEXPRESS)" & then click
    > "Start" from the context menu to start SQL Server. If I don't do so,
    > then SQL Server generates the "Cannot connect to MyServer\SQLEXPRESS"
    > error (where "MyServer" is the name of the database server).
    >
    > What I would like to know is instead of starting SQL Server in this way
    > day in & day out to connect to SQL Server, is there any shortcut route
    > by which I can start SQL Server whenever I want to work with SQL
    > Server?
    >
    > Let me reiterate that I wouldn't prefer SQL Server starting
    > automatically when the OS starts.



+ Reply to Thread