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?