Windows XP SP2 breaks SQL Server
SQL Server connectivity breaks after installing Windows XP SP2 (Service Pack 2) or Windows 2000 SP4. There are numerous solutions from Microsoft on correcting this issue. None of them worked for me.
The simplest way I’ve found to solve this problem is installing SQL Server 2005 (Express Edition) which is free. This solves the problem temporarily.
Other KB articles addressing this problem:
- How to enable SQL Server connectivity on Windows XP Service Pack 2
- How to manually enable TCP/IP on Windows XP Service Pack 2 for SQL Server 2000
- How to configure Windows XP Service Pack 2 (SP2) for use with SQL Server
- How to use a script to programmatically open ports for SQL Server to use on systems that are running Windows XP Service Pack 2
