View Single Post

   
  #2 (permalink)  
Old 02-29-2008, 04:18 AM
Simon Hayes
 
Posts: n/a
Default Re: No default entries in SQL Server 2000 Service Manager Options


"R Bolling" <robboll@hotmail.com> wrote in message
news:6e776aa9.0406192206.1722bcb8@posting.google.c om...
> ver: SQL-DMO Version: 8.00.760
>
> I have the option to automatically start SQL Server on startup, but
> when it does start up, the SQL Server Service Manager does not have
> the green arrow indicating that it is active. When I double-click it
> to display the SQL Server Service Manager, it shows the name of the
> server, but no services in the drop-down box.
>
> When I start Enterprise Manager I see an instance of MSDE where
> someone installed an MSDE application. That is active. But I have to
> "connect" to the localhost. The instance name is the name of the MSDE
> application. I would like it to connect to the localhost on startup.
>
> Any ideas on how to correct this problem?
>
> Thanks,
>
> RBollinger


Check this article:

http://support.microsoft.com/default...32&Product=sql

By default, MSDE 2000 SP3a does not allow network connections - check the
installation guide for the DISABLENETWORKPROTOCOLS parameter.

Simon


Reply With Quote