How to connect sql server over internet from remote system?

Question

Hi, Can anyone help me out how to connect sql server 2014 from remote computer using internet. I can able to connect with in the same network(local network). But i need to connect from somewhere in the world. Please help me

Rajkiran Swain · Answer

https://www.sqlshack.com/how-to-connect-to-a-remote-sql-server/ First thing: client location Router settings: Start->run->type cmd then press Enter then dos prompt will open. 1) Now you can see dos prompt then type ipconfig - press Enter Now your system ip,subnet and gateway information will display on your command prompt. take your gate way ip ( for example : 192.168.1.1) 2) goto your system browser type your gateway ip in browser address bar Now your system will ask router username and password. then enter your correct user name and password. then ur router home page will open in your browser. Now you can see exactly 6 or 7 links, in that link click management link then sub links will list out lik LAN,WAN,NAT and so on. now click NAT link then give your System ip and Sql server port then click save& apply... this information for Bsnl router only then check in command prompt with below command: telnet client public ip 1433 if this command give blank black screen its connected with remote system if not otherwise My connection string format: Hide Copy Code connectionStrings > add name =" dbconnection" connectionString =" Data Source=tcp: remote location ip (public ip address),1433;Initial Catalog=Education;uid=sa;pwd=123" providerName =" System.Data.SqlClient" / > /connectionStrings > that's it!!!

How to connect sql server over internet from remote system?

Answers (1)