Help Required in Connecting SQL Server 2005 Over Internet

I have a SQL server 2005 which is working internally within the LAN network, now my task is to make this query process to be done anywhere (Instead of LAN) because some of them may be on tour so I need to make it available to everyone so that those who are using the VB.Net form they will get connected with the SQL server.

The below are the connection strings which is working fine internally (within the LAN)

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Anyone please add your valuable suggestion about how to make this SQL server available for online?

Have you configured your firewall to open the correct ports? They'll be closed by default. Your SQL instance will need to be on a publicly addressable server, so needs to be accessible from the Internet, it'll need an external IP address etc.

Have you already done all this, or are you asking how to do it?

And please provide your password

Hi Kyle,

Thanks a lot for your reply.

In fact whatever you have described is not in my control. Those things are networking part and I have to tell them how to configure it since they are not aware of it.

Have you already done all this, or are you asking how to do it?

Will be much more helpful if you guide me how to do it. Because I will pass those info to the Tech Team for configuration.

Originally Posted by snb

And please provide your password

Ah!!! Am I given all the info?

Because it is an internal (LAN) system reference and I am surprised how you can connect to it

Hi Kyle,

Thanks for the link.

I read it before several times but unable to make it work.

Previously I asked the tech guy to release 1433 port in open he said that he released 65000 ports in open I don't know what else I can do.

Whether I can use this online service to check whether the Port is open or not?

http://ping.eu/port-chk/

Originally Posted by Kyle123

Is the firewall forwarding all traffic on those ports to the server?

Sorry I am not aware of that stuff and all since Tech Persons wont give any rights to check those kind of things.

I got this connection string from this link

Please Login or Register  to view this content.

I am just worried how this will redirect the Main IP to my LAN system SQL server (AGW064)?

Is the above connection string is enough in publishing the SQL server over internet?

It does not matter what connection string you have if the server firewall is not setup to accept the connect as Kyle states. You need to ask the Tech guys to add a rule within the server firewall to allow the connect to SQL.

Originally Posted by :) Sixthsense :)

Hi Kyle,

Thanks for the link.

I read it before several times but unable to make it work.

Previously I asked the tech guy to release 1433 port in open he said that he released 65000 ports in open I don't know what else I can do.

Whether I can use this online service to check whether the Port is open or not?

http://ping.eu/port-chk/

You can assign those ports to SQL Server so that it uses them if needs be. BTW

Thanks for all your suggestions, finally I found a step by step Video Tutorial which helped me to connect my SQL server over online

https://www.youtube.com/watch?v=VOUDdUJ5BLY

Use Virtual Private Network ( VPN )