Connect remotely to sql server

Question

0.00/5 (No votes)

See more:

hey guys, this is the situation:
i have a pc with sql server (express) 2012 install on it.
i have a laptop and i am trying to connect to a database on the pc throug c# application on my laptop.
after manipulayting all of the settings including open port, firewalls and tcp/ip protocols, i managed to connect to the database sitting on my pc and get access to all of the tables. the problem is that i succeed doing it only when i am on the same network (same wifi) of the pc. if i move my laptop to another wifi or my cell phone will use as a hotspot, i will get this error:

An error has occurred while establishing a connection to the server

the code is preety basic:

C#

System.Data.SqlClient.SqlConnectionSqlCon SqlCon = new SqlConnection(Data Source=(the ip address),1433;integrated Security=true;Network Library=DBMSSOCN;Initial Catalog=LocalDB);
SqlCon.Open();

What I have tried:

open port 1433 the the firewall, allow remote connectivity

Posted 11-Feb-16 10:27am

oronsultan

Updated 11-Feb-16 13:01pm

PIEBALDconsult

v2

Add a Solution

Comments

PIEBALDconsult 11-Feb-16 19:03pm

"integrated Security=true"
Do you have a domain controller that allows that?

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)

Garth J Lancaster · Answer 1 · 2016-02-11T11:15:00

I'd be looking at tracing the route between the two networks that dont work - ie, its obvious when you're on the same network, but when you're on a different network, there's nothing to say 'to get from network a (eg 'another wifi or phone) to network b (the one where sql server is running on the laptop), you need to go this way'

this is the first part you need https://support.microsoft.com/en-us/kb/314868[^]

you 'may' be able to do a 'route add' on your pc to add the missing information - it may also be more complicated than that - ie, if the sql server machine & network is behind a firewall, do you have a 'public address' NAT'd to it ?

[edit - Im trying to post this here because as a comment it doesnt render well]

C#

this really depends on what network infrastructure you have/know about  - for instance 

private/internal network |firewall| DMZ |firewall| public network         OR
private/internal network |firewall| public network 

in both case's, if you're 'out' in the public network on the right hand side, and need to see a machine in the private/internal network, you may need  (looking at the simpler case)

private/internal network |firewall                                          | public network
--------------------------------------------------------------------------------------
server with                     | Firewall Rules                              |  public address 
Tcp/ip address              | and Network Address Translates|
a.b.c.d                           | eg public address e.f.g.h goes to |
                                      | a.b.c.d internally                          |

[edit : I cant draw this properly here :-( ]