SQL (ODBC) and Firewall

[Stefan Leopoldseder]

Hi Freaks!

I have a SQL Server (LAN). This Server is behind a firewall. The IIS ist in
the DMZ. Witch prot I moust open to get a ODBC conntection to the SQL
server.

Thanks
__
Stefan Leopoldseder
E Mail: stefan.le...@iss.at
Web: http://www.issl.at

[Psycho]

If you are using a sonicwall Firewall
open up access to ports

TCP Port 5631
UDP Port 5632

"Stefan Leopoldseder" <stefan.le...@issl.at> wrote in message
news:3gqY5.26$Xx3....@nreader1.kpnqwest.net...

[User]

TCP 1433

Stefan Leopoldseder <stefan.le...@issl.at> wrote in message
news:3gqY5.26$Xx3....@nreader1.kpnqwest.net...

[Stefan Leopoldseder]

Hi!
Yes it is a sonicwall. I have open the ports but it doesn`t work. Are there
any other ports I must open?

Psycho <gsz...@home.com> schrieb in im Newsbeitrag:
koEY5.40269$Z9.20...@news1.rdc1.mb.home.com...

[wail...@my-deja.com]

There is a technote at the SonicWALL website about this:

go to www.sonicwall.com, hit the support link, and then hit the FAQ link.

search for technote #10230
(Allowing access from a DMZ server to a LAN computer)

This requires that the IIS webserver on the DMZ can be pointed manuall to
the public address of the SQL server on the LAN.

Configuring Internet servers on my network

Public LAN Server: Easy way for configuring servers in NAT mode(10144)

One-to-One NAT: Configuring servers with more flexibility on a LAN(10151)

Configuring servers on the LAN in Standard mode(10152)

Configuring a server on the DMZ port(10203)
How do I test my internet servers?(10206)

How do I configure the SonicWall for servers on the WAN segment?(10220)

Allowing access from a DMZ server to a LAN computer(10230)

In article <6R3Z5.10$cU3...@nreader1.kpnqwest.net>,

Sent via Deja.com http://www.deja.com/
Before you buy.