Post reply

Could I have an instance sql 2000 and sql 2005 in the same server?

  • August 14, 2006 at 12:44 pm

    #114085

    Hello everybody,

    Could I have an instance sql 2000 and sql 2005 in the same server?,

    What should I consider?

     

    Thanks a lot,

     


    L.I. Amaury C.R.

  • August 14, 2006 at 1:18 pm

    #654928

    Yes you can.  Only one of them can be installed as the default instance.  The other has to be installed as a named instance.

    hth

     

  • August 14, 2006 at 6:17 pm

    #654984

    Thanks a lot Lynn,


    L.I. Amaury C.R.

  • August 15, 2006 at 8:54 am

    #655073

    You should install SQL2000 prior to SQL2005. We did some work in SQL2005 to ensure that when one of the other is uninstalled none of the DLL registration is broken - however this only works if SQL2005 was installed post-SQL2000.

    Cheers,

    Dan

  • August 15, 2006 at 1:48 pm

    #655143

    Another thing to consider...

    If you install the Management Studio (formerly Enterprise Manager) on your desktop box, in most cases Enterprise Manager will no longer open.  I found documentation about why on Microsoft's web page once, but I don't remember off hand...I think 2005 replaces a .dll that Enterprise Manager needs or something.

    You can do everything in Management Studio that Enterprise Manager can do, just something to be aware of.  Also, I think Management Studion only works on 2000 and 2005, not on 7.0.

    The Redneck DBA

  • August 15, 2006 at 2:21 pm

    #655146

    You must be very new in Microsoft SQL Database Administration.

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

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