MS SQL Server Service Manager does not find instance

[michaeljohnsmith@gmail.com]

I am running Win XP SP2 and MSDE 2000 SP3a. The user is logging on as
a POWERUSER. When the user logs on the MSSQLSERVER service starts but
the SQL Server Service Manager, that runs in the system tray, shows
that the instance has not started. The field that displays the
instance name is blank and it is not listed in the drop down list.
The MSSQLSERVER service is set to start with a Windows domain
administrator account. The SQL server can be accessed by a remote
computer through Enterprise Manager. The local programs cannont
interact with the server though.

Does anyone know if I could grant some user access rights to allow MSDE
to work under a POWERUSER login?

[Simon Hayes]

Re: MS SQL Server Service Manager does not find instance


<michaeljohnsmi th@gmail.com> wrote in message
news:1108080392 .121015.218450@ z14g2000cwz.goo glegroups.com.. .[color=blue]
>I am running Win XP SP2 and MSDE 2000 SP3a. The user is logging on as
> a POWERUSER. When the user logs on the MSSQLSERVER service starts but
> the SQL Server Service Manager, that runs in the system tray, shows
> that the instance has not started. The field that displays the
> instance name is blank and it is not listed in the drop down list.
> The MSSQLSERVER service is set to start with a Windows domain
> administrator account. The SQL server can be accessed by a remote
> computer through Enterprise Manager. The local programs cannont
> interact with the server though.
>
> Does anyone know if I could grant some user access rights to allow MSDE
> to work under a POWERUSER login?
>[/color]

If I understand correctly, you can connect to MSDE from another machine on
the network, but you can't connect to it locally on the MSDE box itself? How
are you trying to make the connection, and what error do you get? Are you
using SQL authentication or Windows authentication for the connection? You
might also check this KB article:

http://support.microsoft.com/default.aspx?scid=kb;en-us;328306&Product=sql

Simon

[jacquesm]

Try this

1. Go to "Start | Run" from windows
2. Type "SVRNETCN.e xe" (without quotes)
3. Enable "Named Pipes" and "TCP/IP".

Regards,
Jacques