Re: SQL server service manager
From: Jacco Schalkwijk (NOSPAMjaccos_at_eurostop.co.uk)
Date: 03/15/04
- Next message: Rob Beene [MSFT]: "RE: Installation Question (Cross-Post)"
- Previous message: gustavoLopez: "Re: MSDE fails to install"
- In reply to: Blickityblick: "SQL server service manager"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 15 Mar 2004 14:26:20 -0000
Check the registry key HKLM\SOFTWARE\Microsoft\Microsoft SQL
Server\Tools\Service Manager\Default. you can change that to the instance
you want the Service Manager to start with.
If that doesn't help, and you want a somewhat easier way to stop and start
SQL Server, you can create a batch file on your desktop consisting of:
NET STOP|PAUSE|START MSSQLSERVER (for the default instance)
You can combine STOP and START if you want to be able to do a one-click SQL
Server recycle:
NET STOP MSSQLSERVER
NET START MSSQLSERVER
-- Jacco Schalkwijk SQL Server MVP "Blickityblick" <paul.fredericks@ntlworld.com> wrote in message news:cdc401c40a1e$03b385d0$a301280a@phx.gbl... > I have msde installed. Both the sql service manager and > sql agent are set to start automatically, which they do. > However, the service manager tray icon does not detect my > instance of msde and has no start stop icon displayed. > > How do I get the service manager to recognise my database > at start up. > > The database is used for providing data to a development > website using aspx pages developed in VB.net, which it > does. > > Everything was installed in the right order. Everything > else works fine, it's just that I can't stop or pause the > server without going into my computer | admin tools | > services. > > Any ideas would be greatly appreciated. > > Thanks in anticipation. >
- Next message: Rob Beene [MSFT]: "RE: Installation Question (Cross-Post)"
- Previous message: gustavoLopez: "Re: MSDE fails to install"
- In reply to: Blickityblick: "SQL server service manager"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
