Le blog de Jean David TECHER, un Réunionnais à Saint-Priest/Lyon

http://www.tux-planet.fr/activer-le-mode-read-only-sur-un-serveur-mysql/

Wine 1.6.2 is used. Tools like 'Enterprise Manager', 'Query Analyzer', 'OSQL' are used. The Server 2000 is running on Linux

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)

  wget ftp://ftp.akdeniz.edu.tr/Microsoft/SQL%20Server/SQL_Server_Service_Pack/Sql2000SP4/SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE

• 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

  cd $WINEPREFIX/SQL2KSP4/MSDE

• 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.