I have been asked to install SQL server 2000 standard edition (32 bit) onto a 64 bit server running Windows Server 2008. Obviously the installation is failing with message "cannot start or run due to incompatibity with 64-bit versions of Windows. Please contact the software vendor to ask if a 64-bit Windows compatible version is available."
Is there any way round this issue, or is it an impossible task?