How to connect SQL Server using Instance Name?

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

Hi everyone,
How to connect SQL Server using Instance Name not using ip address? Actually SQL Server is not showing Instance Name in Network Server whereas if I connect same remote SQL Server using IP address it is connected well.

I have a network scenario of different gateway say :

1. 192.168.3.1
2. 192.168.4.1

I need to connect access SQL Server of 192.168.4.1 from 192.168.3.1 using Instance not using IP address. Instance from same gateway are only show in Network Server.

Please help me in this problem.
Thanking You

Posted 4-Nov-15 23:34pm

Gopal Rakhal

Add a Solution

Comments

Herman<T>.Instance 5-Nov-15 6:05am

What is the machine name for the 192.168.4.1? Have you checked using SSMS? That will reveal servername and Instancename

Gopal Rakhal 6-Nov-15 4:55am

Ya, checked using that also it is not working,Is there any thing to do with firewall if firewall is already off.
I am surprised that remote sql server can be access using IP address of that computer but when I use Instance name its is showing network related error, It is also not showing in Network server tab in connect windows

Corporal Agarn 5-Nov-15 6:54am

Are these linked the servers? (sp_addlinkedserver)

Gopal Rakhal 6-Nov-15 4:59am

These are simply remote sql server but in VPN

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)

ZurdoDev · Answer 1 · 2015-11-05T01:44:00

Solution 1

You have to use the IP address. The instance is just added on after the IP address. 129.168.4.1\instancename. See http://www.connectionstrings.com/sqlconnection/connection-to-a-sql-server-instance/[^]

Posted 5-Nov-15 1:44am

ZurdoDev