Login/Register
  • Home
  • Community
  • Knowledge
  • Technical Docs
  • RWS Support Policy
  • Trados Studio Licensing Help
  • Login for Support
Back to Search Results

Error “Database Operation Failed” during the Trados GroupShare installation related to SQL job for Transparent Data Encryption (TDE)

000019784 |11/10/2022 11:44 AM
Scope/Environment
Symptoms/Context

During the installation process of Trados GroupShare, the installer fails with the error:

Database operation failed

 

The installation log provides a more detailed error message:

Job '[JOB NAME]' started successfully.
.Net SqlClient Data Provider: Msg 5061 Level 16, State 1, Line 5 ALTER DATABASE failed because a lock could not be placed on database '[DATABASE NAME]'. Try again later.
Script execution error. The executed script:

IF EXISTS (SELECT 1
FROM [master],[dbo].[sysdatabases]
WHERE [name] = N'$(DatabaseName)') 
BEGIN
ALTER DATABASE [$(DatabaseName)]
SET FILESTREAM(NON_TRANSACTED_ACCESS = OFF)
CONTAINMENT = NONE
WITH ROLLBACK IMMEDIATE;
END
Resolution

Disable the Transparent Data Encryption (TDE) job.

  1. Open the SQL Management Studio and connect to the relevant SQL instance.
  2. Go to SQL Server Agent > Job
  3. Open the properties of the job that is applying the Transparent Data Encryption (TDE)
  4. Untick the box "Enabled"

    User-added image
     
  5. Confirm the changes.
  6. Re-run the Trados GroupShare installer.
Root Cause
This error is caused when a SQL job is enabled/running to apply Transparent Data Encryption (TDE) on the unencrypted database immediately after they are created.
 
Reference
Send Article Feedback
RWS Machine Translation Translation Software Language Services Content Management
All Contents Copyright © RWS.
COPYRIGHT PRIVACY POLICY COOKIE POLICY TERMS AND CONDITIONS