This article applies to:

• WebMarshal 6.X and 7.X

Question:

• How do I create a WebMarshal logging database if I do not have database creator rights?
• What SQL collation does the WebMarshal logging database use?

Information:

To create a WebMarshal logging database, the product requires use of a SQL or Windows account with Database Creator privilege on the SQL server. By default the SQL 'SA' user and accounts in the Windows administrators group have this privilege.

In a secure network environment where the database is hosted on a corporate database server, the database administrator might not allow the WebMarshal product to use a SQL credential with Database Creator privilege.

To work around this security concern, you can proceed as follows:

1. Use SQL tools to create an empty database for WebMarshal.
• The SQL collation for the database MUST be SQL_Latin1_General_CP1_CI_AS.
2. Configure a database user (Windows or SQL account) with Database Owner privilege on the database.
3. Open the WebMarshal Configuration Wizard or Server Properties > Database Logging window.
4. On the Create Database window, enter the user name and password of the database owner account. Enter the name of the empty database, and select Recreate the database. WebMarshal will create the required tables and procedures.

Notes:

• LevelBlue recommends use of SQL Management Studio or Management Studio Express to create or edit a database.
• To set the database collation using SQL queries, first ensure that you have exclusive use of the database (no other connections active). Enter the following:
  
  ALTER DATABASE WebMarshal database name COLLATE SQL_Latin1_General_CP1_CI_AS
  
• Database Owner (DB_Owner) privilege is the minimum required to initialize or upgrade the WebMarshal database. Normal logging and reporting operations do not require this privilege. From the WebMarshal Server Properties > Database Logging window you can configure an "operational user" with lower privileges.