For the moment I am able to get SQL Server 2000 Standard Edition + SP4 working on Linux using Wine 1.7.10. Two days were required to be able to set everything up! Only TCP/IP works but it is worth having that :).

1. Prerequistes

Wine 1.7.X must be installed -- where X=8,9,10 --. wine must be available /provided in your PATH. Your folder where wine is installed must be added in your environment variable. Since I am used to build wine from source I have to do
export PATH=/opt/wine/apps/SQL_Server_2000/bin/:PATH

2. Installation

In a nutshell you have to
  • make a fresh MSDE SP4 installation. This step is not very complicated.
    • Set up a new/fresh WINEPREFIX
      export WINEPREFIX=/where/you/want/your/SQL/Server/to/be/installed
    • Use winetricks
      winetricks vcrun2003
      This command above aims at copying expected DLL into your $WINEPREFIX
    • Set the DLL mscvp71.dll and msvcr71.dll as native through winecfg
    • Download SQL2000-KB884525-SP4-x86-ENU.EXE (google)
    • Run it. Command shown below will perform a silent installation using /S switch
      wine SQL2000-KB884525-SP4-x86-ENU.EXE /S
    • Go to the directory where the files have been extracted
    • Generate a batch file
      echo 'setup.exe DISABLEROLLBACK=1 BLANKSAPWD=1 DISABLENETWORKPROTOCOLS=0 SECURITYMODE=SQL TARGETDIR="C:\Program Files\Microsoft SQL Server\" DATADIR="C:\Program Files\Microsoft SQL Server\" /L*v C:\MSDE_Setup.log' > setup.bat
      Run it using wineconsole
      wineconsole setup.bat
    • The installer may crash and it can't end properly. However it didn't prevent your from going ahead.
    • You will have to copy a few DLLs...This step has to be completed!
  • Download the SQL 2000 Standard Edition (google)
  • Run the installer
    cd /path/where/your/CD/is/installed
    wine x86/setup/setupsql.exe
  • Choose the expected options to upgrade your current SQL Server installation based on MSDE.