Monday, March 26, 2012

msde 2000 on windows 2003 server

I "Managed" to install msde on windows 2003 server but the sql service manager does list an thing to connect to.
what am i doing wrong does mdse work on windows 2003 server and how do i fix it ?
Hi,
I have found the following KB article that describes a similar scenario.
http://support.microsoft.com/default...&Product=sql2k
#appliesto
================================================== ==========================
================================================== =========
BUG: The SQL Server 2000 Service Manager Utility Does Not List Instances
That Have Not Enabled Network Connections
View products that this article applies to.
BUG #: 363267 (SHILOH_BUGS)
SYMPTOMS
If you configure an instance of SQL Server 2000 or SQL Server 2000 Desktop
Engine (also known as MSDE 2000) to disallow network connections, that
instance will not appear in the SQL Server 2000 Service Manager utility.
CAUSE
The SQL Server ODBC driver does not return instance names to the SQL
Service Manager if the instance does not support network connections.
WORKAROUND
To work around this behavior, stop and then start the service for the
instance by following these steps:
Right-click My Computer, and then click Manage.
Double-click Services and Applications in the left-hand screen.
Double-click Services.
Right-click the service for the instance of SQL Server. The name of the
service for a default instance of SQL Server 2000 is MSSQLServer. The name
of the service for a named instance of SQL Server 2000 is
MSSQL$instancename.
Click the action that you want applied to the instance, such as stop or
start.
================================================== ==========================
================================================== =========
HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.

No comments:

Post a Comment