Connecting to different instance of SQL Server

Question

Connecting to different instance of SQL Server

prasad-994585

SSC Veteran

Points: 254
More actions
January 21, 2009 at 8:33 am

#97091

Hi all,
I have installed 2 instance of SQL Server on a same computer . One is a defualt instance and other is named instance:I am able to connect to default instance since it is on port 1433.My named instance is on port 2085.Can any body plz tell me how to connect to this named instance form cmd line and likewise from the SQL Studio .
Regards,
Prasad

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Jack Corbett SSC Guru Points: 184394 More actions · Answer 1

You need to reference the SQL Server as Server\Instance,Port I believe.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

a20kush SSC Journeyman Points: 75 More actions · Answer 2

hi Prasand i want to know how to create diffiirent server name instance .

please write in steps. i need for sql server 2008.

please replay me .

Prudhviraj SSC Veteran Points: 262 More actions · Answer 3

prasad-994585 (1/21/2009)
Hi all,
I have installed 2 instance of SQL Server on a same computer . One is a defualt instance and other is named instance:I am able to connect to default instance since it is on port 1433.My named instance is on port 2085.Can any body plz tell me how to connect to this named instance form cmd line and likewise from the SQL Studio .
Regards,
Prasad

Type in the following while connecting to the sql server

ComputerName\NamedInstanceName,2085

Substitute computer name with your computer name and named instance name with your named instance. For example: Prudhvi-PC\SQL2012,2085

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 4

Prudhviraj (4/10/2013)
prasad-994585 (1/21/2009)
Hi all,
I have installed 2 instance of SQL Server on a same computer . One is a defualt instance and other is named instance:I am able to connect to default instance since it is on port 1433.My named instance is on port 2085.Can any body plz tell me how to connect to this named instance form cmd line and likewise from the SQL Studio .
Regards,
Prasad
Type in the following while connecting to the sql server
ComputerName\NamedInstanceName,2085
Substitute computer name with your computer name and named instance name with your named instance. For example: Prudhvi-PC\SQL2012,2085

Try it first without the port number. If you haven't assigned a fixed port, it will be dynamically assigned each time the named instanced is started. The SQL Browser service will help you connect to the named instance.