Is there any solution for this situation ?

Hello !

I have a server where I have installed SQL server 2008R2.
I get internet from an ISP that has given to me a Dynamic IP address . ( the ISP can give also a static IP , but this will be a static IP inside ISP , so is not a real IP ).

I have created an application in VB.net that use a database on this server. The application works very well inside the local network.

But I want to give users the possibility to use my program outside the environment where is the server , for example from a remote office ..etc. So I need to access the database on the server in these condition.

Is there any solution to this situation ( but of course without changing anything to IP mode , because it's impossible ).

Thank you !

July 18th, 2015 10:31am

Ensure that your SQL Server's TCP/IP protocol is enabled (SQL Server Configuration Manager) and it uses a static port.

Then you need to configure your Firewall or modem (if it's a small shop) to direct incoming connections to your SQL Server Instance's port.

Free Windows Admin Tool Kit Click here and download it now
July 18th, 2015 2:11pm

Ensure that your SQL Server's TCP/IP protocol is enabled (SQL Server Configuration Manager) and it uses a static port.

Then you need to configure your Firewall or modem (if it's a small shop) to direct incoming connections to your SQL Server Instance's port.

July 18th, 2015 7:00pm
If you have a dynamic IP address, then you are kind of out of luck unless they give you some type of DNS name.  You will need to get your network team involved, so that they give you either a static IP or a DNS of some sort.  At least, I think the DNS names are something like myserver.domain.com.  Anyway, I generally just email my network guys for IP issues, since they are in charge of that stuff.
Free Windows Admin Tool Kit Click here and download it now
July 18th, 2015 9:38pm

Please read this web site

http://blogs.msdn.com/b/walzenbach/archive/2010/04/14/how-to-enable-remote-connections-in-sql-server-2008.aspx

July 19th, 2015 1:18am

Please read this web site

http://blogs.msdn.com/b/walzenbach/archive/2010/04/14/how-to-enable-remote-connections-in-sql-server-200

Free Windows Admin Tool Kit Click here and download it now
July 19th, 2015 2:07am
Have you tried by the name , like COMPNAME,portnumber if needed.
July 19th, 2015 2:42am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics