Sql-server – Installing SQL Server 2000 32-bit on Windows Server 2008 x64

sql serversql-server-2000

Am I correct in assuming there won't be any issues installing SQL Server 2000 32-bit on a Windows Server 2008 x64 system?

I understand the memory limitations, etc, but that doesn't matter at this point.

Best Answer

SQL Server 2000 is incompatible with Windows Server 2008; that being said I have only ever tried to install it on Windows 7 (which shares the same code base as Windows Server 2008) and it outright rejected the install.

You might be able to install it but it will depend on the exact features that you select. For example: I know that you cannot install Reporting Services for instance because it depends on IIS6 which is not available for Windows Server 2008. There is a short section on SQL Server Central where someone has tried to install SQL 2000 on Windows Server 2008 and has come across problems.

If you must use SQL Server 2000 I would recommend putting it on a VM running a known compatible version of Windows Server - though to be frank, I'd rather move the databases to a higher version of SQL and run them in compatibility mode (though this may not be an option for you.)

I hope this helps you.

Related Question