How to connect with remote sql server using ip address

Question

1.00/5 (1 vote)

See more:

SQL-Server-2008R2

Hi,
I obtained IP address of the target computer using:

C#

Dim hostname As String = Dns.GetHostName()
       Dim vrIPAddress As String = CType(Dns.GetHostByName(hostname).AddressList.GetValue(0), IPAddress).ToString

Then i tried to connect with that computer using connection string:

C#

"Data Source=192.168.0.2,1433\MyInstance;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;

After a long pause, it says:

VB

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.)

The target system is configured for Firewall, allows Remote Connection etc, allows both TCP/IP connections.

Please advise.
Thanks

What I have tried:

I have searched google, tried different code snippets

Posted 24-Feb-16 1:20am

Furqan Sehgal

Updated 28-Feb-16 7:22am

Add a Solution

Comments

Richard MacCutchan 24-Feb-16 7:32am

The address 192.168.0.2 is the address of your system, not the remote one. Why not just ask the administrator for its address?

Furqan Sehgal 24-Feb-16 7:36am

There is no administrator, how can I check the address myself?

ZurdoDev 24-Feb-16 8:10am

1. Reply to the comment so that the user is notified.
2. You don't need the 1433 on the connection string. Is the server on your network?

Furqan Sehgal 25-Feb-16 2:07am

1) Thanks for the tip!
2) No, I want to access the remote server over internet

ZurdoDev 25-Feb-16 7:27am

Then it needs to have that port open, which is not normal for external access. You probably should get with a tech guy and create a vpn or have them forward a port for you.

Furqan Sehgal 26-Feb-16 4:29am

Forwarding a port is a better option. Kindly elaborate little further.

ZurdoDev 26-Feb-16 7:11am

Talk to your IT people. They can open a port just for you that then forwards to sql.

2 solutions

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)

adityasahver · Answer 1 · 2016-02-28T01:08:00

Solution 1

The port for sql connection is not open at the server level and you cant do much about the same unless you are getting the proper ip address with the port.

Posted 28-Feb-16 1:08am

adityasahver

Maciej Los · Answer 2 · 2016-02-28T07:22:00

If you're trying to connect to MS SQL Server placed on another computer, take a look here:
Lesson 2: Connecting from Another Computer[^]
How to: Enable the TCP/IP Protocol for a Database Instance[^]
In some cases, you'll need to Configure the Windows Firewall to Allow SQL Server Access[^]

But, it seems you want to connect to MS SQL Server on local machine. Many useful information about "connection string" you'll find here: SQL Server connection strings - ConnectionStrings.com[^]