I am not sure if msde uses the same port - but SQL Server listens on port 1433 by default.
-w-
>hi all,
>
>i'm testing some of my applications w/c runs on MSDE on the new Windows XP Service Pack2, which actually entails newer & more secure firewall settings.
>
>my application run on both the server & workstations only w/ the firewall switched off.
>but the problem comes w/n i have the firewall settings switched on. the applications runs on the server but the workstation applications cannot.
>
>how do i configure my workstations to be in the exception list on the firewall so they can access the server?
>
>i'll already added the workstation's IP address & subnet but still i can't get it connect.
>
>how do i configure my network to use TCP/IP protocol w/ a static port so i can add the workstations to the firewall's exceptions list.
>
>thanks.
>
>herbert
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown