Post reply

Named Instance Connection Problem

  • September 12, 2008 at 9:37 am

    #125462

    hi folks,

    i have inherited 2 sql server instances >

    liveserver and liveserver\instance2

    i can connect to liveserver and have registered it in management studio.

    we can only connect to liveserver\instance2 by it's IP address however hence have registered 10.0.20.43 in management studio.

    liveserver\instance2 is browsable in when you try and connect to network servers however.

    The exact error is >

    Cannot connect to liveserver\instance2

    Additional information :

    Instance failure (System.data)

    Any pointers into how to resolve this would be most appreciated.

    thanks

    r

  • September 12, 2008 at 11:55 am

    #871227

    If I understood your problem exactly, following is the solution,

    if you are able to connect the server thru IP address but not with name of the server means you can try add an entry in the hosts file ( host file path: C:\windows\System32\drivers\etc).

    Jay

    Thanks
    Jay
    http://www.sqldbops.com

  • September 12, 2008 at 12:03 pm

    #871231

    run this command to check ur instance name SELECT @@SERVERNAME.

    ..>>..

    MobashA

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

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