How can I access SQL server database over internet? When both pcs are not on same network?

Question

1.00/5 (1 vote)

See more:

, +

I am developing a project for School and i have installed SQL server on a computer.It runs perfect on when both system are on same network.
Now i want to access SQL database from home.When these two machines are not on same network.

What I have tried:

I have tried using IP Address but cant get solution.

Posted 9-Jan-17 20:40pm

Member 12882662

Updated 9-Jan-17 21:28pm

Add a Solution

2 solutions

Solution 1

The server has to be configured to allow it. You have to contact the DBA that owns the server, and after it's properly configured, he can provide the appropriate connection string. However, any DBA worth his salt won't do as you ask, because it's more secure and auditable to have an outward facing web service that provides controlled access to the database server.

Posted 9-Jan-17 21:05pm

#realJSOP

Comments

Member 12882662 10-Jan-17 3:11am

I have permission to configure Server.
Please can you tell me how to configure ?? Security is not issue...

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 · Accepted Answer · 2017-01-09T21:28:00

Solution 2

Few things you need to ensure:
- Configure the SQL Server to listen to TCP/IP traffic
- Ensure that the firewalls are not blocking the traffic (Windows or other)
- Ensure that a secure communication is used, in other words VPN or similar. Otherwise the server easily becomes vulnerable to outside attacks.
- Ensure that you use complex enough passwords if using SQL Server authentication

To configure SQL Server, see Configure a Server to Listen on a Specific TCP Port (SQL Server Configuration Manager)[^]

To configure Windows firewall see Configure a Windows Firewall for Database Engine Access[^]

Posted 9-Jan-17 21:28pm

Wendelius

Comments

Member 12882662 10-Jan-17 3:59am

i have configured all tha but still can not connect to database.
can you tell me which IP has to use in connection string???And all details

Wendelius 10-Jan-17 4:18am

In the connection string you need to specify the IP address along with the port. See Connect via an IP address - SqlConnection - ConnectionStrings.com[^]

Member 12882662 10-Jan-17 4:27am

it gives error: The remote computer refused the network??

Wendelius 10-Jan-17 4:32am

Sounds like the firewall is blocking the traffic. Ensure that proper ports are open on both ends

Member 12882662 10-Jan-17 4:39am

both ends means?? on both PC?

Wendelius 10-Jan-17 4:41am

The client that connects SQL server and the computer that is running SQL server and all firewalls in-between

Member 12882662 10-Jan-17 4:51am

On client PCwhat i have to configure??plz

Wendelius 10-Jan-17 4:55am

Ensure that the firewall isn't blocking the traffic. Go through the link I posted in the answer.

Member 12882662 10-Jan-17 5:26am

sorry for disturbing! but its not working!!

Wendelius 10-Jan-17 5:50am

I'm afraid that's not telling much. What exactly isn't working and how? What are the exact steps you try and what error messages you get? Also please post relevant code parts if any.