p2p.wrox.com Forums

Need to download code?

View our list of code downloads.

  Return to Index  

sql_language thread: How can you connect to SQL server 7 over the net?

Message #1 by <nickm@s...> on Wed, 13 Dec 2000 09:36:28 -0500
If the problem that you are having is how to configure the firewall, it
all depends on how you have things configured.  Supposing that you have it
like this:

Internet user  ----  Web server  ---- Firewall  ---- SQL Server

Then you would set the web server to connect to the firewall's address. 
Unless you have changed the port in the DSN, this connection will be on
port 1433.  So, the firewall would be set to gateway port 1433 (sql
server's tcp port) to port 1433 on the sql server.


> > Hi,
> >
> > Are  there any settings that I have to set on SQL server 7 to enable this
> > 'web connection'? I am assuming that this is done on TCP or is it on UDP.
> > The reason I am asking is that I need to open up some ports in my
> firewall.
> >
> > Do you have to name the server or just gives it's IP address?

You are currently subscribed to sql_language as: $subst('Recip.EmailAddr')
To unsubscribe send a blank email to leave-sql_language-$subst('Recip.MemberIDChar')@p2p.wrox.com

  Return to Index