Post reply

SQL Connection Question

  • January 9, 2007 at 4:25 pm

    #114997

    Hello all,

    We have sql accepting remote connections via all clients if the client uses server\instance name.

    *If we use 2005 Enterprise and connect it will connect using server\instance name and/or server ip address (LAN).

    *If we use a sql client that is not 2005 enterprise we can only connect using the server\instance name. If we try via ip, it fails.

    *Using the same client we can connect to one of our 2000 sql servers using ip address, but cant connect to the 2005 server using the ip.

    We want to be able to connect via IP for any sql client.

    Any ideas?

  • January 9, 2007 at 5:00 pm

    #682251

    It probably has to do with 'backwards/forwards' compatibility. SQL Server 2005 has more security built into it than SS2000. It also has more features than 2000. That's probably why you are having an issue going from the older version (2000) to the newer version (2005).

    -SQLBill

  • January 9, 2007 at 5:46 pm

    #682261

    So does 2005 only answer to server/instance? Is there a way to change that?

  • January 9, 2007 at 11:00 pm

    #682298

    i hope specifying only the IP address will take you to the sql server installed as default instance. if you have installed 2005 as named instance specify ip\instance name.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • January 9, 2007 at 11:32 pm

    #682307

    I think it is related to network protocol...

    Check the network protocol configuration...

    You can alias sql instance in client network utililty..

     

    MohammedU
    Microsoft SQL Server MVP

  • January 10, 2007 at 3:57 am

    #682327

    I did not install sql personally, but it sounds like maybe there was an option to install as a default instance or a named instance? Is that right?

  • January 10, 2007 at 4:08 am

    #682328

    I think that I have answered my own question via google

    See http://msdn2.microsoft.com/en-us/library/ms143219.aspx

    "On the Instance Name page, select a default or named instance for your installation. If a default or named instance is already installed, and you select the existing instance for your installation, Setup upgrades it and provides you the option to install additional components. To install a new default instance, there must not be a default instance on the computer. To install a new named instance, click Named Instance and then type a unique instance name in the space provided. To install a new named instance side-by-side with an existing instance, click Named Instance and then type a unique instance name in the space provided. For more information about instance naming rules, click Help at the bottom of the page, or see the Instance Name topic in SQL Server 2005 Books Online."

    Next question, can I revert to default instance from named instance w/o reinstalling?

Viewing 7 posts - 1 through 6 (of 6 total)

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