Windows XP Firewall & SQL Server 1

[password99]

I Have a cleint-server application using MSDE. The database server is installed as named instance on Windows XP machine. However, the Windows XP firewall prevents it from being accessed by client computers.

Is there a workaround to be able to connect to MSDE Server without disabling the Windows XP firewall?

 

[JFBouchard]

Hi, you can go to connexions, properties of your LAN connexion, advanced parameters tab, parameters and add the service MSDE or create a custom one by specifying the external port for MSDE.

Or this article can help you:

http://www.docs.com/HelpFiles/WindowsXPServicePack2Fix.htm

Hope this helps. Please let know if this resolve your issue

Jeff