Looks like you have an authenticiation error.
Go to your Services icon in your control
panel to see what NT Account the MSSQL Service
is using.  Generally, it is set to the
system account.  What ever account you use,
you MUST insure that this account has all the
necessary rights to all the files, registry
settings, and advanced rights (such as "run
as service" right).

One way you can diagnose if you are having
a problem is to add the service account
to the administrator's group of the
local machine (or domain if it is a domain
controller/member).  If your service
starts correctly, you have a rights problem.

I would not recommend keeping your service
this way though, since it allows for
SQL server to have full rights to every
thing on your server.  One hack or user
mistake may cause irrepairable damage
to your system or your whole network.

Hope this helps.

Cardyin

-----------------------------------------
Cardyin Kim
Client/Server and Web Development Analyst
San Antonio Community Hospital
Upland, California
ckim@s...        (xxx) xxx-xxxx
-----------------------------------------


-----Original Message-----
From: Sai Krishnan [mailto:saikrishnan_d@y...]
Sent: Friday, May 10, 2002 4:13 AM
To: professional vb
Subject: [pro_vb] SOS.. SQLServer does not run.


Hello all,
	I'm having a problem running sqlserver.  When I try to open the 
database in Enterprise manager, I get an error stating 
		"The connection to SQL server 'DOMAINNAME' has been 
broken.  The connection  to the SQL server is broken.  Do you want to try 
reconnecting to it?"


	Also when I try to run the server manager, I get the following 
error"
	"An error 1069 - (The service did not start due to a logon 
failure.) occured while performing  this service operation on the 
MSSQLServer service."


	I don't know why this happens.  Even if I reinstall SQL server,  
the error remains.  The only thing I've been doing is uninstall the NT 
itself and reinstall NT and SQL server.  This happens quite frequently.  
Can anybody pull me out of this trouble?

- Sai
to unsubscribe send a blank email to ..