ASP .NET, MS SQL Server 2000 with Window XP SP2 <- does not work???

[Thang T]

Hi everybody, I'm using ASP .NET with MS SQL Server 2000 Personal Edition. They work well in Windows XP SP 1, but when I set up Window XP SP2, an error occurs: SQL Server does not exist or access denied. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: SQL Server does not exist or access denied Then I thought it is an trouble with the MS SQL Server, so I reinstalled MS SQL Server several times, but this error still occurs. Please help me!!! Thank you very much! Ich liebe .NET :)

[Mike Ellison]

Hi Raymond. There are some known SQL Server connectivity issues in conjunction with the new Windows Firewall in XP SP2. Here are a couple of links you'll want to read to address your connectivity issues: FAQ: How Windows XP Service Pack 2 (SP2) Affects SQL Server and MSDE[^] How to configure Windows XP Service Pack 2 (SP2) for use with SQL Server[^]

[Thang T]

Thanks Mike! The problem has been fixed. Because in the SP2, the Firewall starts at default. So I have to add the instance of SQL Server in the Exception list of the Firewall Manager. Thanks for you links :) Ich liebe .NET :)