Monday, August 30, 2004

WinXP SP2 & SQL Server - Problem

I've spent the last two hours this morning working on a problem I've discovered when I tried to use my development SQL Server. I run a copy of Microsoft SQL Server 2000 Personal Edition (NOT MSDE) on my development laptop along with a copy of Macromedia ColdFusion application server. This morning when I attempted to connect to the SQL Sderver through an app I wrote in CF I received an error message. Turns out that I didn't have Service Pack 3a installed for SQL Server 2000 (thought I did) and because of that, according to the Windows application event log: You are running a version of Microsoft SQL Server 2000 or Microsoft SQL Server 2000 Desktop Engine (also called MSDE) that has known security vulnerabilities when used in conjunction with this version of Windows. To reduce your computer's vulnerability 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 http://www.microsoft.com/sql/downloads/default.asp Note that this only happens when connecting via TCP/IP. So if your running into problems, make sure you have the latest SQL Server 2000 service pack!

2 comments:

Anonymous said...

Did you find this problem after upgrading WinXP to SP2?

Troy said...

Yes, that is correct, this problem only occured AFTER I installed service pack 2 for Windows XP. Prior to that it was working fine.

After I installed the latest SQL Server 2000 service pack the problem went away.