Hello, I need to be able to access a SQL server that resides on my SBS 2003 network. The SBS server is acting as the gateway and there is no other firewall device. The SQL 2000 server is hosted on a Windows 2000 server in the domain. I need to be able to work with tables in a database on that server from an ASP.net application that is hosted on a remote site. I've tried accessing with just the gateways IP address and the SQL port, but that did not work.

Can someone walk me through the process of setting up SBS and the SQL server to be accessed in this way? For example, how do you configure the port to be opened to allow port fowarding? I'm at a loss on how to do this so any help would be great.

You'll need to open port 1433 for this traffic and edit the connection string in your web.config so that it points to the SQL server.

Hello and thanks for responding. How do you open ports in SBS 2003?

Do you have ISA installed?

No, the SBS 2003 is the standard version.

Hi Scott,

 

If that SQL server is on a member server in your LAN, and you want to access it from the internet, you will have to add a port in the RRAS configuration of the SBS. But be very very careful with opening port 1433 to the internet as that is a port used for trying to hack your server.

Thank you Marina for responding. I have yet to get this to work. Do you know of a tutorial or step by step to add a port in the RRAS configuration of the SBS? I understand the security risks and do not want to get this wrong. I should be able to add an account for Internet users on the SQL server to allow access for select only to the required tables. That should be ok? Any help would be great.

Hi Scott,

 

Do you have 2 nics in the server?

Yes, There are two nics. I am able to touch the SQL box via RDC.

Hi Scott,

 

Than you should be able to add that port in RRAS yourself. Have a look at this article for some clues: Config of the UPnP Router by the CEICW wizard