Reputation: 316
I have a Laptop, with msSql sever 2005, and it is connected to my Wifi router which gets the internet. So My laptop get connected to internet. But I need to access my msSql Sever from internet to connect my webpage which I made using ASP.Net.
Please Help me... And please give a solution for this...
Upvotes: 0
Views: 451
Reputation: 161
First setup a static IP address on your laptop and after that you need to set up port forwarding in your router. This process differs slightly depending on your routers manufacturer and model.
After this is set up properly make sure that SQL Servers port is open on your laptops firewall.
By using Dynamic DNS you can point to your possibly changing IP address with static name so you don't have to change this constantly in your connection string.
Upvotes: 0
Reputation: 105
you want to write web service and host that service in sql machine
Upvotes: 0
Reputation: 528
You'll need your IP adress to connect, then open the SQL-Port in your router. (default is 3306
)
When you connect to the server just use your current ip adress.
Maybe you want a static ip or something like http://dyndns.org
Upvotes: 1