MSSQL SERVER Desktop Involuntary shutdown

[Bob W]

I have installed MSSQLSERVER fron XPOffice on Windows XP Op Sys. On bootup
the MSSQL Server icon appears on the tray and on pointing indicates
\\WUND100 MSSQL Server running. When I bring up NorthwindCS.adp as a sample
program , an error message appears that no Server is installed. Attempting a
connection and an error message " [DBNetLib] [ Connection open(connect()0
SQL Server does not exist or Access denied" and the SQL Icon on the trey has
diappeared. The server \\Wund100 does not appear on the dropdown list.
Reading the Log , the last statement is " SQL Server terminated due to STOP
request from Service Control Manager". Somewhere some default or error is
causing a stop event to occur but I do not know where or how. I need to use
..adp and i need the MSSQL Engine to work on a desktop. I asked this question
before, but now have the Log info. HELP

 

[Sylvain Lafontaine]

The tray icon is not the SQL-Server but is the SQL-Server Service Manager.
It can be used to start or stop the SQL-Server service but exiting the
Service Manager or removing it from the AutoStartup has no effect by itself
on the SQL-Server.

To make sure that SQL-Server is started or stopped, take a look at the list
of services: MyComputer --> Contextual Menu (right-click) --> Manage -->
Services.

The name of the service is MSSQLSERVER if you have chosen the default
instance or MSSQLSERVER$InstanceName if you have installed a named instance.
Instead of \\Wund100, you can also try with (local) or with localhost. In
the case of (local), you must include the parenthesis.

If you have installed a named instance, then you must add its name:
\\Wund100\InstanceName, etc...

In the list of services, you will also see two other related services:
MSSQLServerADHelper and SQLSERVERAGENT (or SQLSERVERAGENT$InstanceName in
the case of a named instance). These services are related to SQL-Server but
are not necessary: they can be stopped or started without affecting the
SQL-Server service.

These instructions are for SQL-Server; to my knowledge, they are identical
for MSDE.