Database creation utility parameters

Creating the Log Database | Web Protection Solutions | 29-Apr-2022

The database creation utility can be run with the following parameters.

Note that this list omits parameters not used in this version (either preserved from legacy versions or reserved for future versions)


Parameter	Description
-debug	Values: true / false Set this parameter to true to send debug messages to the console. By default, debug messages are not displayed.
-help	Displays the list of valid parameters with a description of each. No values (arguments) are associated with this parameter.
-ip	Required. Used to specify the IP address of the Microsoft SQL Server machine that hosts or will host the Log Database. To specify an instance other than the default, use the format: IP_address\instance_name
-installdir	Specifies the directory on the Log Server machine that hosts the database creation utility (CreateDbU.exe) and its support files. If no value is specified, this is the SQL folder as recorded in the Windows registry during Log Server installation (default C:\Program Files\Websense\Web Security\SQL).
-name	Provides the name of the database to create or upgrade (default wslogdb70). The name must begin with a letter (not a number or special character).
-pass	Specifies the password for the account defined via the -user parameter. Required when -user is used.
-path	Provides the full path to the location where database files will reside. If Microsoft SQL Server runs on a different machine than the database creation utility, the path must already exist. If no path is entered, the database files are created in the following default directory on the SQL Server machine: C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA
-port	Indicates the port used to connect to SQL Server. If this parameter is not specified, 1433 is used.
-ssl	Values: true / false Determines whether SSL encryption is used to connect to the database. If the parameter is set to true, encryption must already be configured in SQL Server for database creation to succeed.
-trusted	Values: true / false Indicates whether to use Windows Authentication (a trusted connection) to connect to the database. If this parameter is set to true, do not include the -user or -pass parameters. By default, this parameter is set to false, and SQL Server authentication is used.
-user	Specifies which SQL Server account to use to connect to the database. (Required with SQL server authentication.) This user becomes the database owner, and the owner of the database jobs associated with it. If you are using a trusted connection, do not include the -user parameter.