Monday, February 20, 2012

Is there an issue running SQL 2000 on a 2003 R2 64 bit operating system?

I am trying to istall SQL 2000 on a new Server. The server is running 2003 R2 Standard x64 addition. When I try this I get an error message that says

file is valid but not for this machine type?

Are these just not compatible?I had SQL 2000 running under Windows 2003 R3 and it was fine. You have to force the setup NOT to check for machine type:

<cd drive/network drive>:\setup.exe /force

Before you install, run setup.exe /? and get the command line options and make sure that FORCE and DO NOT CHECK MACHINE TYPE options are available and used.

Also, check out the following link which gives information on SQL 2000 and the SP level needed to run under x64: http://www.sqlmanager.net/en/news/sql/mssql/683

Mark|||Here is another link from Microsoft concerning x64 support for SQL 2003 in SP4: http://www.microsoft.com/sql/prodinfo/previousversions/sp4.mspx

Mark

No comments:

Post a Comment