Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - SQL inside firewall/Web Outside
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

SQL inside firewall/Web Outside

 Post Reply Post Reply
Author
Thunder7 View Drop Down
Newbie
Newbie
Avatar

Joined: 17 July 2002
Location: United States
Status: Offline
Points: 29
Post Options Post Options   Thanks (0) Thanks(0)   Quote Thunder7 Quote  Post ReplyReply Direct Link To This Post Topic: SQL inside firewall/Web Outside
    Posted: 12 May 2003 at 12:23pm
Is it possible to access a SQL database from a web server
that sits outside a firewall?

If so, what is required.  I believe we have port 1433 open
to allow any calls through, but I am not sure what else I
may need to get the SQL server to talk to the web server
out in the DMZ.  If its possible.

Not a SQL person, just use it for basic stuff like this forum.  So not sure how the communctions between the web server and SQL server.
Back to Top
michael View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
Post Options Post Options   Thanks (0) Thanks(0)   Quote michael Quote  Post ReplyReply Direct Link To This Post Posted: 12 May 2003 at 3:10pm

You need to forward the router/firewall to the pc with SQL installed.
Something like:
Inbound Port     Type         PrivateIP            Private Port
1433                 TCP         192.168.1.213   1433

It all depends on the type of router you have but should lead you in the right direction.

Back to Top
Thunder7 View Drop Down
Newbie
Newbie
Avatar

Joined: 17 July 2002
Location: United States
Status: Offline
Points: 29
Post Options Post Options   Thanks (0) Thanks(0)   Quote Thunder7 Quote  Post ReplyReply Direct Link To This Post Posted: 16 May 2003 at 5:54am

Well, I have verified that the firewall is allowing 1433 through it. I can get to the server on port 1433 from the Web server, but this forum softawre (6.34) gives the following error:

Microsoft OLE DB Provider for SQL Server error '80004005'

[DBNMPNTW]Specified SQL server not found.

/common.asp, line 176

 

Back to Top
MorningZ View Drop Down
Senior Member
Senior Member
Avatar

Joined: 06 May 2002
Location: United States
Status: Offline
Points: 1793
Post Options Post Options   Thanks (0) Thanks(0)   Quote MorningZ Quote  Post ReplyReply Direct Link To This Post Posted: 16 May 2003 at 11:08am

if the SQL server is sitting inside a firewall and has a "non public" IP address.. ie/ 10.10.xx.xx , 192.168.xx.xx (some common ranges), and your Web server doesn't have an internal address like that, you wont be have one access the other

but i dunno, you dont provide enough info about the setup there... but typically a common setup is (this is going to be impossible to demonstrate in text, but i'll try anyways):

Outside World
       V
Router/FireWall
V                 V
Port 80         No access needed
V                 V
Web Srv        SQL srv

The web server should access the SQL server by the "internal" IP, and this protects people from the outside having ANY sort of direct access to the SQL box

IF the webserver is on the other side of the firewall (Outside World), not only do you have to open up port 1433 on the Firewall, you also need to tell (at the router/firewall) which internal IP "gets" this traffic

Contribute to the working anarchy we fondly call the Internet
Back to Top
Thunder7 View Drop Down
Newbie
Newbie
Avatar

Joined: 17 July 2002
Location: United States
Status: Offline
Points: 29
Post Options Post Options   Thanks (0) Thanks(0)   Quote Thunder7 Quote  Post ReplyReply Direct Link To This Post Posted: 19 May 2003 at 5:30am
Originally posted by MorningZ MorningZ wrote:

if the SQL server is sitting inside a firewall and has a "non public" IP address.. ie/ 10.10.xx.xx , 192.168.xx.xx (some common ranges), and your Web server doesn't have an internal address like that, you wont be have one access the other

but i dunno, you dont provide enough info about the setup there... but typically a common setup is (this is going to be impossible to demonstrate in text, but i'll try anyways):

Outside World
       V
Router/FireWall
V                 V
Port 80         No access needed
V                 V
Web Srv        SQL srv

The web server should access the SQL server by the "internal" IP, and this protects people from the outside having ANY sort of direct access to the SQL box

IF the webserver is on the other side of the firewall (Outside World), not only do you have to open up port 1433 on the Firewall, you also need to tell (at the router/firewall) which internal IP "gets" this traffic

Thanks for the info and help.

Yes, we are using private IP addresses.  There is a "translation" that is taking place that the web server does use to get to the SQL box inside the firewall.  It is getting there via pings, and port 1433.

Are you saying, the problem is in the translation of the public IP to the private?

 

Back to Top
Thunder7 View Drop Down
Newbie
Newbie
Avatar

Joined: 17 July 2002
Location: United States
Status: Offline
Points: 29
Post Options Post Options   Thanks (0) Thanks(0)   Quote Thunder7 Quote  Post ReplyReply Direct Link To This Post Posted: 27 May 2003 at 5:28am
What authentication type should the database be set to in this scenario?  Maybe that is part of my problem now.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.