Problem

Installation of SecureTransport LEC with MS SQL database fails with the following messages in the install.log:

com.tumbleweed.st.server.appframework.sql.DatabaseConfigurationException: Cannot setup partitioning

and

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The EXECUTE permission was denied on the object 'st_proc_CreateNewPartitions', database '<DB_NAME>', schema 'dbo'

Note: In some cases the above error messages can been seen during the execution of the Log Maintenance Applications.

Resolution

This is usually caused by the database owner account being different from the MS SQL account that is used by SecureTransport (ST) to access the database. If this is desired, and in order to have ST using the DB with a different account than the db owner, follow the steps below.

1. Ensure that the default permission prerequisites are met as outlined in the ST Installation Guide. The account used by ST needs to have at least:

db_datareader
db_datawriter
db_ddladmin

2. Perform the below additional steps in the MS SQL Management Studio:

1. Right Click on the ST database and select Properties
2. Select Permissions
3. Grant the ST application user Execute permission under the Explicit Permissions tab