Access SQLServer remotely.
Can somebody tell me how can I access the SQL Server instance which is running on a different network? I'm developing a website which should access the instance of sql server running on user's computer. The user can be on a different network. I'm not able to find a way to achieve this.
Software/Hardware used:
Software/Hardware used:
ASKED:
August 25, 2006 5:52 AM
UPDATED:
August 25, 2006 9:39 AM
Answer Wiki:
Many factors involved here:
1) If the servername/static IP-address is known, you can connect as username@servername(or IP) considering a single SQL instance per server.
Some pre-requisites to this access are that the Servername or IP-address are published throughout the network(or recognised by DNS Server, no DHCP or dynamic IP's).
To see all answers submitted to the Answer Wiki: View Answer History.
yeah, I agree, also I can get the DNS name of the user. But the problem is how do I get the access to user’s computer. e.g. My site will ask the user his DNS name and his machines IP address. Now, when the user will provide this information..I can resolve the IP address of the DNS name but now how do I get access to the machine in the network where the SQL server instance is running?
Also, is it the right approach to do this or is there any other feasible solution?
Please somebody look in to this, if possible, let me know.
If you have a static IP address you should use it, or setup a DNS entry if you like. on a WAN its best to setup a VPN (point to point) at the router level to the remote network where the SQL server is located. That way the SQL Sever ports ar not open at the firewall for Slammer type worm attacks. As long as the network protocol on the SQL server box has TCP/IP protocols enabled its cool. Othewise if its just named pipes there are other ports that must be opened. BE careful opening ports to the SQL sever box