Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Internet------> Router in my network

------->LocalMachine(Windows 2003) -->Sqlserver2005

How access sqlserver through internet via Router in local

network.

My router IP Address is =192.168.1.86; My local machine which is connected to the router Ip

Address is= 192.168.1.81 At port No=1433

tell how to connect to my sqlserver. Thanks for help in advance

share|improve this question

4 Answers 4

The 192.168.1.81 address is a local address and will not be accessible from the internet.

I would not make sql server accessible from the internet - you are just asking to be hacked. But, if you really must...

You need an external address. You can go to grc.com and do a shields up port scan. It will tell you your external ip at home as well as the security holes...

You need to put rules in place on your physical firewall to allow access through that port.

You need to put rules in place on your windows firewall on the sql server machine to allow access.

share|improve this answer

You simply need to open port 1433 in your router/firewall and point it to your local machine where your SQL server is installed. On some SOHO routers this is called virtual server.

You should be aware though, this is not the best security practice to open outside access to your LAN. Better way is to make a DMZ segment.

share|improve this answer

Everything mson said applies, but in addition you may need NAT port forwarding rules to forward the incoming connection on port 1433 to your internal IP address. Depending on the version of SQL Server, you may need to specifically enable TCP as a connection method.

share|improve this answer

check this

share|improve this answer
    
Please refrain from just posting links, thank you :) –  Lucas Kauffman Jul 27 '12 at 8:05

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.