The Microsoft SQL Server 2005 Express Edition tab enables you to modify configuration settings specific to Microsoft SQL Server 2005 Express Edition databases.
The Microsoft SQL Server 2005 Express tab
Before you start the redistribution of the Microsoft SQL Server 2005 Express Edition engine you must register on the Microsoft web site:
http://www.microsoft.com/sql/editions/express/redistregister.mspx
You can download a preconfigured package for Microsoft SQL Server 2005 Express Edition support in the Add-On Packages topic.
The fields in http.ini specific to the
Microsoft SQL Server 2005 Express Edition section are shown below:
[SQLServer2005] ; Install SQL Server 20005 Expres Edition settings Install=0 InstanceName=DWEBPRO
SaPassword=79b0d1e1
LazyErrorHandling=0
InstallPath=##DWEBPRO_PATH##\engine\sqlserver2005\setup.exe
InstallCustomParams=/QB ADDLOCAL=ALL INSTANCENAME="##DWEBPRO_SQLSERVER2005_INSTANCENAME##" SAPWD="##DWEBPRO_SQLSERVER2005_SAPASSWORD##" DISABLENETWORKPROTOCOLS=0 SECURITYMODE=SQL INSTALLSQLDIR="##DWEBPRO_SQLSERVER2005_TARGETDIR##" INSTALLSQLDATADIR="##DWEBPRO_SQLSERVER2005_DATADIR##"InstallDataDir=##PROGRAMFILES##\SQL Server 2005 for DWebPro
InstallTargetDir=##PROGRAMFILES##\SQL Server 2005 for DWebPro\Data ; File Copy settings CopyDataToHardDisk=1 DataDir=##DWEBPRO_PATH##\engine\sqlexpress\data DestinationDir=##TEMP##\dwebpro\sqlexpress DatabaseVersion=1 DeleteOldDatabases=1 ShowCopyProgressWindow=1 Overwrite=1 AskUserForOverwrite=0 AskUserForOverwriteDefaultButton=Yes ClearOnShutdown=0 AskUserForClearOnShutDown=0 AskUserForClearOnShutDownDefaultButton=Yes ; Interactive Install settings UseInteractiveInstall=0 SpaceNeeded=0 ; Database Restore settings DatabaseName= RestoreSQL.0=
Install SQL Server 20005 Expres Edition settings
Install MSDE
Install
Install MSDE specifies whether SQL Server 20005 Expres Edition is
installed upon start up of DWebPro. The install process is executed only once.
Accepted values: 0, 1
Instance Name
InstanceName
Instance Name specifies the name of the Microsoft SQL Server 20005 Expres Edition instance that will be installed.
Accepted values: string
Admin Password (sa)
SaPassword
SaPassword specifies the password of the Microsoft SQL Server 20005 Expres Edition admin user (sa) that will be used for the installation process.
Accepted values: string
Install Path
InstallPath
InstallPath specifies the path of
the directory where the Microsoft SQL Server 20005 Expres Edition engine will be installed. Refer to the DWebPro Internal Constants topic for additional information on paths.
Accepted values: string
Custom Params
CustomParams
Custom Params specifies the additional parameters
that will be passed to the Microsoft SQL Server 20005 Expres Edition installer.
Accepted values: string
Target Directory
InstallTargetDir
Target Directory specifies the path of the directory where the Microsoft SQL Server 20005 Expres Edition engine will be installed. Refer to the DWebPro Internal Constants topic for additional information
on paths.
Accepted values: string
Data Directory
InstallDataDir
Data Directory specifies the path of the directory where the Microsoft SQL Server 20005 Expres Edition database files will reside. Refer to the DWebPro Internal Constants topic for additional information
on paths.
Accepted values: string
Lazy Error Handling
LazyErrorHandling
LazyErrorHandling specifies if DWebPro has to close itself if something goes wrong during the install process. Set
LazyErrorHandling to 1 if you want that DWebPro continues the startup process even if it encounters problems. Accepted values: 0, 1
File Copy settings
SQL Server 2005 Express Edition allows to attach databases at runtime using AttachDBFilename connection-string attribute. Use the File Copy settings if you need to copy a database from the CD/DVD to the user hard drive and then use the AttachDBFilename connection-string attribute to attach the database from the destination folder on the file system. Refer to the DWebPro Internal Constants topic for additional information on paths.
Copy Data to Hard Disk (from Data Directory to Destination
Directory)
CopyDataToHardDisk
Copy Data to Hard Disk specifies whether
the files specified in the Data Directory folder
are copied to the folder specified in the Destination Directory (on the user's hard drive).
Accepted values: 0, 1
Data Directory
DataDir
Data Directory specifies the path to
the directory where the Microsoft SQL Server 2005 Express Edition database files reside. Refer to
the DWebPro Internal Constants topic for additional
information on paths.
Accepted values: string
Destination Directory
DestinationDir
Destination Directory specifies the path
of the directory to which the Microsoft SQL Server 2005 Express Edition files will be copied. Refer
to the DWebPro Internal Constants topic for additional
information on paths.
Accepted values: string
Database Version
DatabaseVersion
Database Version specifies the version
of the SQL Server 2005 Express Edition database. If you want to distribute your application
with different versions of the database or distribute an updated version
of the database within the same application, you can use this field
to specify which version of the database you are distributing and
let DWebPro automatically start the database server with the correct
database.
Accepted values: integer
Delete Old Databases
DeleteOldDatabases
Delete Old Databases specifies whether
DWebPro has to delete an existing Microsoft SQL Server 2005 Express Edition database before copying
a new one.
Accepted values: 0, 1
Show Copy Progress Window
ShowCopyProgressWindow
Show Copy Progress Window specifies whether
the progress window displays during file copy routines.
Accepted values: 0, 1
Overwrite Data
Overwrite
Overwrite Data specifies whether the
databases copied to the user's hard drive are overwritten.
Accepted values: 0, 1
Ask User for Overwrite
AskUserForOverwrite
Ask User for Overwrite specifies whether DWebPro
prompts the user to confirm the copy of the files if the destination
directory already exists.
Accepted values: 0, 1
Default Button
AskUserForOverwriteDefaultButton
Default Button specifies the default
button on the confirmation form for file copies.
Accepted values: Yes, No
Clear on Shutdown
ClearOnShutdown
Clear on Shutdown specifies whether DWebPro
deletes the files copied to the user's file system prior to closing.
Accepted values: 0, 1
Ask User for Clear on Shutdown
AskUserForClearOnShutDown
Ask User Clear on Shutdown specifies whether DWebPro
prompts the user to confirm the deletions of the files in the destination
directory prior to closing.
Accepted values: 0, 1
Default Button
AskUserForOverwriteDefaultButton
Default Button specifies the default
button on the confirmation form for files deletion.
Accepted values: Yes, No
Interactive Install settings
Use Interactive Install
UseInteractiveInstall
Use Interactive Install specifies whether
DWebPro uses the Interactive Installation procedure. Refer to the Interactive Install Workflow topic for more information.
Accepted values: 0, 1
Space Needed
SpaceNeeded
Space Needed specifies the needed space
for the copy. Use the drop-down box to the right of this field to
specify the units of space desired. This option is relevant only when
using the Use Interactive Install option. Refer
to the Interactive Install Workflow topic for more
information.
Accepted values: integer
Database Restore settings
Database Name
DatabaseName
Database Name specifies the name of the database that will be restored using the
RestoreSQL.X field.Accepted values: string
Restore SQL
RestoreSQL.X
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).
Accepted values: string