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 Express Edition
settings
Install Microsoft SQL Server 2005 Express
Edition
Install
Install
Microsoft SQL Server 2005 Express Edition 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
