Trilight Zone

[digital8]

Q: After installing Windows XP SP2, MSDE connections stop working. Is this a known issue?

A: There are many aspects of SQL that make configuring Windows XP SP2 critical after installation. Microsoft has a slew of MSKB articles outlining changes you'll need to make:



"How to configure Windows XP Service Pack 2 (SP2) for use with SQL Server," http://support.microsoft.com/?id=841249


"How to enable SQL Server connectivity on Windows XP Service Pack 2," http://support.microsoft.com/?id=841251


"How to manually enable TCP/IP on Windows XP Service Pack 2 for SQL Server 2000," http://support.microsoft.com/?id=841252


"How to enable SQL Server 2000 Reporting Services on Windows XP Service Pack 2," http://support.microsoft.com/?id=841253


"How to enable the ISAPI component on SQLXML on Windows XP Service Pack 2," http://support.microsoft.com/default.aspx?kbid=842005


"How to enable SQL Server 2000 Analysis Services and OLAP Services on computers that are running Windows XP SP2," http://support.microsoft.com/?id=841256


"How to use a script to programmatically open ports for SQL Server to use on systems that are running Windows XP Service Pack 2," http://support.microsoft.com/default.aspx?kbid=839980


"Troubleshooting Windows Firewall settings in Windows XP Service Pack 2," http://support.microsoft.com/default.aspx?kbid=875357


"MSDN Webcast: SQL Server and Windows XP SP2 - Level 300," available at http://msevents.microsoft.com/cui/eventdetail.aspx?eventid=1032253410&culture=en-us


You may not be able to connect to an instance of SQL Server that is configured to use the Named Pipes server network library on a computer that is running Windows XP Service Pack 2," http://support.microsoft.com/?id=839269


"You may receive a 7391 error message in SQL Server 2000 when you run a distributed transaction against a linked server after you install Microsoft Windows XP Service Pack 2," http://support.microsoft.com/?id=839279


"You may receive a 7391 error message in SQLOLEDB when you run a distributed transaction against a linked server after you install Microsoft Windows XP Service Pack 2," http://support.microsoft.com/?id=873160