Post reply

Connecting to named instance through SQLCMD

  • January 25, 2012 at 5:39 am

    #391402

    Hi,

    I am trying to connect to a named instance instance3 using the below command from the same server.

    sqlcmd -s .\instance3

    But it gets connected to default instance. I am not able to connect to instance3 anyway.

    Please advice.

    I checked the below link

    http://msdn.microsoft.com/en-us/library/ms188247.aspx

    Ryan
    //All our dreams can come true, if we have the courage to pursue them//

  • January 25, 2012 at 6:02 am

    #1438185

    Case matters. Use sqlcmd -S.\instance3 instead (uppercase s).

    -- Gianluca Sartori

  • January 25, 2012 at 6:31 am

    #1438204

    Gianluca Sartori, thank you very much. It worked now.

    Ryan
    //All our dreams can come true, if we have the courage to pursue them//

Viewing 3 posts - 1 through 2 (of 2 total)

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