November 7, 2001 at 11:23 pm
is it possible for my asp scripts hosted on a external IIS to establish a connection with the sql server sitting in my intranet?
can i "open" a particular db to that external webserver?
November 8, 2001 at 8:53 am
yes. by default, SQL listens on port 1433, so you need to be able to get through this port.
I wouldn't "open this port" to everyone. Just your iis ip.
Steve Jones
November 8, 2001 at 6:50 pm
quote:
yes. by default, SQL listens on port 1433, so you need to be able to get through this port.I wouldn't "open this port" to everyone. Just your iis ip.
Steve Jones
how can i go abt configuring the db to be open to a particular ip?
November 8, 2001 at 7:19 pm
It's not the db, but the firewall/router where the access needs to be configured. Basically, an access list would be created that only a request to port 1433 from the web server's IP would be honored, all others would be blocked.
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply