How can I connect to SQL server installed on PC from another PC connected with different networks?

Question

1.40/5 (2 votes)

See more:

, +

I Want to connect to SQL server from a windows application, that can be install on any PC but database should be same on my own server.

What I have tried:

I have searched a lot but can't get any solution, I just found how to connect on same network.But i want to connect from cross network.

Posted 5-Jan-17 18:25pm

Member 12882662

Updated 5-Jan-17 20:38pm

Add a Solution

Comments

F-ES Sitecore 6-Jan-17 4:50am

Just to expand on solution 1, for the client to see your database then the two obviously have to be on an accessible network otherwise it's like trying to phone someone when you don't know their phone number, or trying to speak to someone who is in a different building. If this is not a corporate environment then you might well need to use the internet as the network both machines are on, so either give your server a fixed IP that is exposed on the internet, or register a domain for it "sql.mydomain.com" or whatever, and that is what you use in the connection string;

server=sql.mydomain.com;

You'll obviously need to consider the security aspects of all of this though.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Answer 1 · 2017-01-05T20:38:00

If I understand your question correctly, in order to connect from remote PC to the SQL Server you need to know the IP address where the server resides and the port the SQL Server is using. For the syntax of the connection string using IP address, have a look at Connect via an IP address - SqlConnection - ConnectionStrings.com[^]

Ensure that communication between the computers is allowed using that port so that for example firewalls do not block it. Another thing is that if you're using public networks, the traffic can be seen and the the SQL Server is available in public so I suggest for example using VPN in such case and blocking all access to SQL Server from outside world.