Database creation utility parameters
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. |