SQL 2000 and 2005 on same server

Hot Topic

Pipe Dream : SQL Express access from VB6
Using connection managers inside custom log provider failing!
synchronize MDB file
Unexpected behavior when setting a script task breakpoint in package w/ multiple script tasks
Also for Sql server 2000
Replication Question
Can we add tooltip to the Reports available in Report Manager?
rs:ClearSession not working
Configuration of Database Mail
Simulate ROW_NUMBER () in SQL 2000

SQL Server

Install SSMSE - Installation failed
ReportViewer Height
Modification of MsDTSSrvr.ini.xml does not work in June CTP
logging the DDL stmts
Can update in SQL 2000 but not express beta 2
Date picker not showing in RS2005
Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index
Pkg Execution Works in VS but not in SQL
How to check if row exists...
How to convert a timestamp into dateTime in SQLServer 2000

SQL 2000 and 2005 on same server

Does SQL Server support instances of SQL 2000 and SQL 2005 on the same server If so - are there any instance naming standards to follow for this scenerio

Thanks

-J

Answer this question

SQL 2000 and 2005 on same server

  • Captain Anonymous

    I think that this must be a common issue as I have exactly teh same problem. 1 server running SQL2000 on a network where other machines have SQL2005 installed.

    I get the same error from the sqlmangr.exe program.

    This stops you from connecting to teh server and maintaining it, however the server itself seems to be running without any problems at all.

    Does anyone have any suggestions as its going to be difficult running my server at 2000 and I need to do this.

    Many thanks

    Rob

  • DismasX

    I have the same error in my network on PCs having sql server 2000 and they dont have SQL server 2005 installed. BUT, there are other servers in the network that have SQL Server 2005 installed.

  • bluntcoder

    What is the different story for a 'side by side' install on a cluster (Win2003)

    Regards

  • Lale Divringi - MSFT

    (1)Chad Boyd, Could you please provide the link for your post in regards to the memory error issue

    (2) After I install MSDE 2000, I got Sql manager crash error, could you please give me some hint for resolving this issue

    Problem description:

    Whenever I run the sqlmangr.exe after the system reboot, the sqlmanagr.exe generated program error. "sqlmangr.exe has generated errors and will be closed by Windows. You need to restart the program."

    I am using MSDE 2000. The OS is Windows 2000.

    One thing I noticed is that sqlmangr.exe will not crash if I disconnect the system from the NETWORK. (By unplugging the network cable.)

    YOUR HELP IS APPRECIATED.



  • Nils Andreas Svee

    This is fully supported.

    Keep in mind that named instances cannot be named DEFAULT, MSSQLSERVER and has a limit of 16 characters, among other rules (see BOL)

  • Praveen.P.L

    Sune is correct, this is a fully supported configuration, so long as you are not running on a cluster solution, which is a different story...there are many, many deployments with this configuration currently, including my own :-)...

    As for the memory error, I posted a response on your other post in regards to this...see that for more info...



  • wojciu

    I dont think so , there have been a couple of my firends that have not been able to install SQL 2005 on the same box which already had SQL 2000.....

    Infact I have tried it mysefl & have got the following error :-

    sqlmangr.exe - Application Error

    The instruction at "0x780104ac" referenced memory at "0x1083e7b7" .The memory could not be read

    Click Ok to terminate the program
    Click on Cancel to debug the program

    So please make sure you try it on a test server & not on your production server.
  • SQL 2000 and 2005 on same server
Answer this question