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

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.

Download

• http://muawaydown.com/Server/SQLs/
• http://wesleyferreirabr.blogspot.com.br/2013/08/instalando-o-microsoft-sql-server-2000.html

Documentation

• http://www.codeproject.com/Articles/8788/Hands-on-how-to-configure-the-Microsoft-MSDE
• http://blogs.msdn.com/b/sqlserverfaq/archive/2009/05/27/info-sql-2000-msde-installation-will-fail-if-you-have-number-of-cpus-on-a-box-which-is-not-in-power-of-2.aspx
• http://support.microsoft.com/default.aspx?scid=kb;en-us;285097
• http://technet.microsoft.com/en-us/library/aa176565%28v=sql.80%29.aspx
• http://technet.microsoft.com/en-us/library/aa933150%28v=sql.80%29.aspx
• http://technet.microsoft.com/en-us/library/aa175266%28v=sql.80%29.aspx
• http://technet.microsoft.com/en-us/library/aa933149%28v=sql.80%29.aspx

All hotfixes

• http://basitaalishan.com/2013/05/08/microsoft-sql-server-2000-builds/
• Latest hotfixe: http://www.microsoft.com/en-us/download/details.aspx?id=30533

Repair http://blogs.msdn.com/b/joaol/archive/2008/03/13/how-to-rebuild-your-master-database-in-msde-when-it-became-corrupted.aspx

• Get the sources

   git clone git://git.code.sf.net/p/interdbconnect/code interdbconnect-code

Tips ti know

• If you got this error

  biotricks=# ALTER SERVER remote_biopacs_production VERSION '1.0'  OPTIONS ( host '10.1.0.244', port '5433', dbname 'biopacs_production');
  ERROR:  option "host" provided more than once

  then use set

  biotricks=# ALTER SERVER remote_biopacs_production   OPTIONS ( SET host '10.1.0.244');
  ALTER SERVER
  biotricks=# ALTER SERVER remote_biopacs_production   OPTIONS ( SET port '5433');
  ALTER SERVER
  biotricks=# ALTER SERVER remote_biopacs_production   OPTIONS ( SET dbname 'biopacs_production' );
  ALTER SERVER