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.