Firewall settings for msde

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
hi Herbert,
"herbert" <praetorean.tech@.graffiti.net> ha scritto nel messaggio
news:EAE41221-4DE2-458E-84D7-B24A0531F1A1@.microsoft.com...
> 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.
>
you have to manually open TCP/IP port 1433, if MSDE instance you are running
is listening on the default port.. or the port you are using to connect to
it...
as regards multi instance support, Windows XP SP2 firewall will actually
disable the benefit of dynamic port detection by SQL Server... that's to say
you have to manually statically set a designed port for each instance, open
all the required ports on the Firewall and close UDP 1434 port, which is no
longer needed when dynamic detection is "disabled"..
Microsoft is developing a script for customers who need an automated
solution. If you need the script, contact msdewxp2@.microsoft.com, asking for
"script for customers who need an automated solution to enable MSDE network
connections" , as required by PSS email "Guidance for using MSDE on Windows
XP Service Pack 2"
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply