January 21, 2009 at 8:33 am
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
January 21, 2009 at 8:47 am
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
February 13, 2013 at 12:56 am
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 .
April 10, 2013 at 12:36 pm
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
April 10, 2013 at 1:56 pm
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.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply