Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Administration (2000)  Network Protocols have been disabled...

Author  Topic  drman Starting Member 38 Posts Posted - 2009-03-02 : 06:37:06 I was performing an update to an older VB application that utilizes SQL 2000 in the development environment. Since it is very rarely accessed on the development machince, updates were not done on the SQL environment. While working on a crystal report, I was unable to locate the SQL instance. I soon realized that the application would not connect either... so I assumed I must have screwed something in the application/development environment. Next I realized that I could not find the server in the enterprise manager. After going through the event log, I found the following message: Event Log message: You are running a version of Microsoft SQL Server 2000 or Microsoft SQL Server 2000 Desktop Engine (also called MSDE) that has known security vulnerablilites when used in conjunction with this version of Windows. To reduce your computer's vulnerabilitiy to certain virus attacks, the TCP/IP and UDP network ports of Microsoft SQL Server 2000, MSDE, or both have been disabled. To enable these ports, you must install a patch, or the most recent service pack for Microsoft SQL Server 2000 or MSDE from ... MS Download site I am afraid to update the sql instance to sp4 after issues that I have heard of related to sql sp updates. How do I re-enable the network protocols? If I go into theClient Network Utility, everything looks fine. Thanks in advance for any direction that can be offered.. DRMAN