Error Message

EVBAAdmin error in the Customer Properties under Current Status | Info:

Only System Administrator can specify WITH LOG option for RAISERROR command.

EV Event Log error entries:

Log Name:      Veritas Enterprise Vault
Source:        Accelerator Manager 
Event ID:      50
Task Category: None
Level:         Error
Keywords:      Classic
Description:
APP ATM - Failed to create database: server=;Initial Catalog=Customer_Database_Name>;Integrated Security=true;Connection TimeOut=500;Connection LifeTime=200;Max Pool Size=300;Application Name=Compliance Accelerator. System.Data.SqlClient.SqlException (0x80131904): Only System Administrator can specify WITH LOG option for RAISERROR command.
   at Symantec.EnterpriseVault.DatabaseAccess.EVSqlBase.Do[T](Func`1 action)
   at Symantec.EnterpriseVault.DatabaseAccess.EVSqlCommand.ExecuteNonQuery()
   at KVS.Accelerator.Application.Install.RunScript(String ScriptName, EVSqlCommand CMD, Int32 CustomerID)
   at KVS.Accelerator.Application.Install.CreateDatabase(Int32 CustomerID, String DSN, CustomerType CustType, String LanguageID, String configDSN, ProductType productType)
ClientConnectionId:9b939844-49ad-4139-9444-85b91b7c0f33
Error Number:2778,State:1,Class:16

V-437-50

Log Name:      Veritas Enterprise Vault
Source:        Accelerator Manager 
Event ID:      64
Task Category: None
Level:         Error
Keywords:      Classic
Description:
APP ATM - Error installing a Customer.
Install Thread - worker thread (0)
Customer ID: X
Number of tries: 1
Cause: Only System Administrator can specify WITH LOG option for RAISERROR command.

V-437-64

Note

The documentation for future versions will be updated to include this requirement.

In CA versions 14.3.0 and higher, multiple SQL stored procedures in the Customer database were edited to use the WITH LOG option. Per Microsoft Books Online (BOL) at https://learn.microsoft.com/en-us/sql/t-sql/language-elements/raiserror-transact-sql, the use of the WITH LOG option requires the user to have the SQL SysAdmin role. The error is generated when the Vault Service Account (VSA) does not have the SQL SysAdmin role assigned, regardless of whether or not the VSA has the DBCreator role assigned.

Note that at the time of writing, this option was not present in Discovery Accelerator (DA); however, this may change in future versions.

There are two options to alleviate the error - implement the applicable option:

Option 1 - Assign the SQL SysAdmin role to the VSA before the creation of the new CA Customer database. Please refer to the onsite SQL team for the specific steps. 

Option 2 - Grant the Alter Trace permission securable to the VSA before the creation of the new CA Customer database. Please refer to the onsite SQL team for the specific steps.

Note that both options can be used concurrently. Once implemented, a new Customer database can be created, or the creation of the existing new Customer can be retried as follows:

1. Request the assistance of the onsite SQL team to delete the incomplete database that was created by the new Customer creation process. Continuing with the steps below without deleting the database created for the new Customer will result in error: Database '' already exists. Choose a different database name.

2. In the EVBAAdmin administration website at http://localhost/evbaadmin, right-click the new Customer in EVBAAdmin, then go to the Properties page and finally click on Retry Install.

3. Monitor the Current Status pane for the new Customer until the State lists Installed, the Customer's tasks lists Running, and the Info pane states Customer database created. The Customer is now ready for use.