lundi 6 janvier 2014
SQL Server 2000 Standard Edition (+SP4) on Linux using Wine
Par david techer, lundi 6 janvier 2014 à 14:11 :: SQL Databases

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 doexport 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 wineconsolewineconsole 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.