Home Forums SQL Server 7,2000 Administration Connecting to different instance of SQL Server RE: Connecting to different instance of SQL Server

  • April 10, 2013 at 12:36 pm

    #1605368

    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