The Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) tab enables you to modify configuration settings specific to MSDE 2000 database engine.
MSDE 2000 is supported only on the following platforms:
-
Windows Server 2003 Standard Edition, Windows Server 2003 Enterprise Edition, Windows Server 2003 Datacenter Edition.
-
Windows 2000 Server, Windows 2000 Advanced Server, Windows 2000 Datacenter Server.
-
Windows NT Server 4.0, SP5 or later; Windows NT Server 4.0, Enterprise Edition, SP5 or later; Windows NT Workstation 4.0, SP5 or later.
-
Windows XP Professional, Windows XP Home Edition.
-
Windows 2000 Professional.
-
Windows Millennium Edition.
-
Windows 98. Windows 98 Second Edition is required if the computer does not have a network card.
Important Note Microsoft SQL Server Desktop Engine (MSDE) is not supported on the Microsoft Vista operating system. If you plan to build an application and redistribute it under Windows Vista, you should consider using SQL Server 2005 Express Edition instead.
Before you start the redistribution of the MSDE 2000 engine you must register on the Microsoft web site:
http://www.microsoft.com/sql/prodinfo/previousversions/msde/MSDErights.mspx
You can download a preconfigured package for MSDE 2000 support in the Add-On Packages topic.
The fields in http.ini specific to
the MSDE 2000 section are shown below:
[MSDE] ; Install MSDE 2000 Engine settings Install=1 InstanceName=DWEBPRO SaPassword=79b0d1e1 InstallPath=##DWEBPRO_PATH##\engine\msde\setup.exe InstallCustomParams=SAPWD="##DWEBPRO_MSDE_SAPASSWORD##" INSTANCENAME="##DWEBPRO_MSDE_INSTANCENAME##" DISABLENETWORKPROTOCOLS=1 SECURITYMODE=SQL TARGETDIR="##DWEBPRO_MSDE_TARGETDIR##" DATADIR="##DWEBPRO_MSDE_DATADIR##" InstallDataDir=##PROGRAMFILES##\MSDE for DWebPro InstallTargetDir=##PROGRAMFILES##\MSDE for DWebPro LazyErrorHandling=0 ; Database Restore settings DatabaseName=dwebpro BackupFile=##DWEBPRO_PATH##\engine\msde\dwebpro.bak RestoreSQL.0=RESTORE DATABASE ##DWEBPRO_MSDE_DATABASENAME## FROM DISK='##DWEBPRO_MSDE_BACKUPFILE##' WITH MOVE '##DWEBPRO_MSDE_DATABASENAME##_dat' to '##DWEBPRO_MSDE_DATADIR##MSSQL$##DWEBPRO_MSDE_INSTANCENAME##\Data\##DWEBPRO_MSDE_DATABASENAME##.mdf', MOVE '##DWEBPRO_MSDE_DATABASENAME##_log' to '##DWEBPRO_MSDE_DATADIR##MSSQL$##DWEBPRO_MSDE_INSTANCENAME##\Data\##DWEBPRO_MSDE_DATABASENAME##.ldf'
LazyErrorHandling to 1 if you want
that DWebPro continues the startup process even if it encounters
problems.BackupFile field.DatabaseName field.Restore SQL specifies the SQL
queries that DWebPro will execute to restore your databases. You
must insert one command per row. In the http.ini file, each command will be saved in a
field named RestoreSQL.X where the
X will be a number
>= 0 in concecutive order (i.e. RestoreSQL.0, RestoreSQL.1, RestoreSQL.2 and so on).
