Connecting with remote SQL Server DB

Question

0.00/5 (No votes)

See more:

Hello,
Internet browsing has suggested me following connection string to access remote DB, attached to remote SQL server.

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

I want to access the DB over internet, not over LAN. My question is about the IP address and port.

1)What IP address I should use instead of 190.190.200.100? I mean how I can know what IP address my server has.
2) How to check the what port my server is using? Is it always 1433?

Thanks

[edit]Code block fixed[/edit]

Posted 28-Jun-13 5:23am

Furqan Sehgal

Updated 28-Jun-13 7:05am

Nelek

v2

Add a Solution

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)

Mehdi Gholam · Answer 1 · 2013-06-28T05:48:00

Solution 1

1) Get your external IP address for your server with : www.whatismyip.com

2) Create a virtual server or/and configure port forwarding on your ADSL modem and firewall.

Posted 28-Jun-13 5:48am

Mehdi Gholam

Comments

Furqan Sehgal 28-Jun-13 12:15pm

Thanks ! I have done process 1. Please guide me little further about 2

Mehdi Gholam 28-Jun-13 12:21pm

That depends on your modem and firewall, start by going into the web interface on your modem, and reading the manual for "virtual servers" and "port forwarding".

KuttiSankar · Answer 2 · 2013-06-29T00:26:00

Solution 2

XML

<connectionStrings>
        <add name="ConnectionName" connectionString="Data Source=Server;Initial Catalog=DBNAME;User ID=USERID;Password=PASSWORD; >

    </connectionStrings>

Server: Server Name, Get the Server IP and you need to give that IP here.

DB will be connected.

Posted 29-Jun-13 0:26am

KuttiSankar

Comments

Furqan Sehgal 30-Jun-13 3:36am

Thanks Kutti, I am confused about password and username. Is is sa and the password of sa?
secondly, if there are multiple instances on my SQL server and have the DB with same name (all of them) how will my connection string recognise which instance to connect with?

KuttiSankar 30-Jun-13 3:43am

Yes, you can identify the Instance by 'IP\Instance Name' '
say (190.190.200.100)\sqlexpress'.

give DB name after that.

& You may not have same Name for Different databases in a same instance. try this.

Furqan Sehgal 30-Jun-13 4:36am

and the user ID is sa or it is the one I gave while installing SQL server instance?

Furqan Sehgal 30-Jun-13 4:44am

I have given following connection string, but it says can not find server/instance
Data source=216.172.147.133;143\reomotetest; initial catalog=dbInvoices;user id=sa;password=abc123
1433 is my port, and I have done the forwarding as well

KuttiSankar 30-Jun-13 5:47am

Mostly we used to give sa only. but i don't know what the password you gave while install, and i am not sure port number we need to give. is 'remotetest' instance name?
Ensure your username and password.

Furqan Sehgal 30-Jun-13 6:08am

when I try to connect with my computer with FURQAN-PC\REMOTETEST, keeping other credentials the same, it works. When I change the servername (Furqan-PC) to my ip (taken from whatismyip.com), keeping other credentials the same, it returns error 26

KuttiSankar 30-Jun-13 6:34am

FURQAN-PC\REMOTETEST : is this local machine? and SQL instance name?

IP taken from remote server or checking your IP of local machine?

Furqan Sehgal 1-Jul-13 11:05am

FURQAN-PC\REMOTETEST is the name of local machine and instance name. The DB I am trying to access through IP address is attached to this machine and instance.
Also, I am taking IP address on the same machine.