Post reply

SQL Server 2000 and 2005 on one Server

  • June 15, 2007 at 10:12 am

    #117509

    Hello,

    i'm running SQL server 2000 ent. and SQL 2005 std. on one server. SQL server 2000 uses the default instance and the sql server 2005 is a named instance. Until today everything worked very fine.

    But today I had a big problem connecting to the SQL server 2005 instance.

    Normaly I connect to the SQL server 2000 in the SQL server management studio, using SERVER as the servername. The

    connection to the SQL server 2005 is established using SERVER\INSTANCE2005 as the servername.

    When I enter SERVER as the servername, it connects to the SQL server 2000. When I enter SERVER\INSTANCE2005 he also connects to the SQL server 2000. I must use the IP of the server (1.1.1.1\INSTANCE2005 or 127.0.0.1\INSTANCE2005) to connect to the database. Connections from a remote maschine using SERVER\INSTANCE2005 is posible, localy not. It does'nt matter if the SQL server 2000 is running or not.

    Yesterday everything was fine and I don't know what could be wrong.

    I hope that someone can help me.

    Kind Regards,

    Andreas

  • June 15, 2007 at 12:10 pm

    #713360

    Is the SQL Server Browser service running?

  • June 16, 2007 at 11:29 am

    #713459

    Yes, the SQL Server Browser service is running. The only service which does not start, is the SQL Server Agent service. I think that's because it can not connect to the named instance.

    But the other Browser service is runnig.

    Kind Regards

    Andreas

  • June 18, 2007 at 2:08 am

    #713504

    Your agent service does not start because it tries to make a client connection within the locla machine. And you say that you are not able to coonecto to the server locally thats the reason your agent does not start and not because its a named instance. Check if the shared memory protocol is enabled if not try enabling the same and try connecting to sql server locally.

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

  • June 18, 2007 at 9:21 am

    #713584

    If I were the OPer, I would look for what has changed.  If something worked and now it doesn't, SOMETHING has been altered somewhere, somehow.

    I would check name resolution stuff since IP connections work.  At least you have a workaround! 

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

Viewing 5 posts - 1 through 4 (of 4 total)

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