InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 13:31:35 GMT20http://www.sqlservercentral.com/Forums/Topic640802-5-1.aspx[quote][b]Prudhviraj (4/10/2013)[/b][hr][quote][b]prasad-994585 (1/21/2009)[/b][hr]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[/quote][b]Type in the following while connecting to the sql serverComputerName\NamedInstanceName,2085Substitute computer name with your computer name and named instance name with your named instance. For example: Prudhvi-PC\SQL2012,2085[/b][/quote]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.Wed, 10 Apr 2013 13:56:58 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic640802-5-1.aspx[quote][b]prasad-994585 (1/21/2009)[/b][hr]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[/quote][b]Type in the following while connecting to the sql serverComputerName\NamedInstanceName,2085Substitute computer name with your computer name and named instance name with your named instance. For example: Prudhvi-PC\SQL2012,2085[/b]Wed, 10 Apr 2013 12:36:52 GMTPrudhvirajhttp://www.sqlservercentral.com/Forums/Topic640802-5-1.aspxhi 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 .Wed, 13 Feb 2013 00:56:18 GMTa20kushhttp://www.sqlservercentral.com/Forums/Topic640802-5-1.aspxYou need to reference the SQL Server as Server\Instance,Port I believe.Wed, 21 Jan 2009 08:47:52 GMT Jack Corbetthttp://www.sqlservercentral.com/Forums/Topic640802-5-1.aspxHi 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,PrasadWed, 21 Jan 2009 08:33:57 GMTprasad-994585