Got more questions? Find advice on: ASP | XML | Regular Expressions | Windows
in Search
Welcome to SqlAdvice Sign in | Join | Help

SQL Server 2000 and SQL Server 2005 Express

Last post 04-20-2006, 7:52 PM by michael.k.campbell. 1 replies.
Sort Posts: Previous Next
  •  04-17-2006, 7:34 AM 16527

    SQL Server 2000 and SQL Server 2005 Express

    Does anyone know if SQL Server 2000 and SQL Server 2005 Express can co-exist on the same machine? I need to access newer 2005 databases and my older 2000 databases at the same time. (2000 will not attach a 2005 database, you get an Error 602 if you try.)
  •  04-20-2006, 7:52 PM 16723 in reply to 16527

    Re: SQL Server 2000 and SQL Server 2005 Express

    They can co-exist quite well actually.

    At one point I had:

    SQL Server 2005 (default instance)
    SQL Server 2000 (named instance)
    and
    SQL Express (\SQLExpress named instance) all running on my machine all at once.

    (That's the only caveat... SS 2000 and SS 2005 can't both be default instances, one will be, the other will have to be a named instance - otherwise everything works fine...)

    Oh, and if you're trying to move DBs from SS 2000 to SS 2005, I'd suggest backing them up and restoring them on to the new server - works fine, seems to encounter less issues down the road.
View as RSS news feed in XML