KB Article #178069

SecureTransport installation fails with "Cannot setup partitioning" error message


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


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.


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:


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