Connect to remote SQL Server from behind ISA

Greetings.
I have a C# Windows app that connects to a remote SQL Server over the
Internet to download records. The application works great until a user
tries to run the query from behind ISA. Is there anything I can do in
the code or configure on the ISA box to allow the connection?
Thank you in advance for your help.
In message <1110557721.844982.74370@.z14g2000cwz.googlegroups. com>,
HardBap <hardbap@.gmail.com> writes
>Greetings.
>I have a C# Windows app that connects to a remote SQL Server over the
>Internet to download records. The application works great until a user
>tries to run the query from behind ISA. Is there anything I can do in
>the code or configure on the ISA box to allow the connection?
>Thank you in advance for your help.
>
You will probably need to add some packet filters into ISA to open the
ports being used for the connection etc.
Andrew D. Newbould E-Mail: newsgroups@.NOSPAMzadsoft.com
ZAD Software Systems Web : www.zadsoft.com

Connect to remote SQL Server from behind ISA

Greetings.
I have a C# Windows app that connects to a remote SQL Server over the
Internet to download records. The application works great until a user
tries to run the query from behind ISA. Is there anything I can do in
the code or configure on the ISA box to allow the connection?
Thank you in advance for your help.In message <1110557721.844982.74370@.z14g2000cwz.googlegroups.com>,
HardBap <hardbap@.gmail.com> writes
>Greetings.
>I have a C# Windows app that connects to a remote SQL Server over the
>Internet to download records. The application works great until a user
>tries to run the query from behind ISA. Is there anything I can do in
>the code or configure on the ISA box to allow the connection?
>Thank you in advance for your help.
>
You will probably need to add some packet filters into ISA to open the
ports being used for the connection etc.
Andrew D. Newbould E-Mail: newsgroups@.NOSPAMzadsoft.com
ZAD Software Systems Web : www.zadsoft.com

Connect across Internet through NAT router

I am attempting to use Enterprise Manager to connect to SS 2000 across the
Internet. The machine running SQL Server is behind a NAT router.
Enterprise manager shows that the TCP/IP port that SQL Server is using is
1061. I have forwared port 1061 on the router to the machine running SQL
Server. When I attempt to register the server in Enterprise Manager I use
the WAN IP address of the router as the server name. However, registration
fails with the message "SQL Server does not exist or access denied."
What am I doing wrong?
Bill ToddI found an article in BOL saying that UDP port 1434 must also be
forwarded, however, doing so did not help.
Bill Todd

Connect across Internet through NAT router

I am attempting to use Enterprise Manager to connect to SS 2000 across the
Internet. The machine running SQL Server is behind a NAT router.
Enterprise manager shows that the TCP/IP port that SQL Server is using is
1061. I have forwared port 1061 on the router to the machine running SQL
Server. When I attempt to register the server in Enterprise Manager I use
the WAN IP address of the router as the server name. However, registration
fails with the message "SQL Server does not exist or access denied."
What am I doing wrong?
Bill Todd
I found an article in BOL saying that UDP port 1434 must also be
forwarded, however, doing so did not help.
Bill Todd