Tyler Deploy error during Configure Database step

Owned by Knowledge Assistant
Mar 15, 2022
Description of Issue

During Munis ERP installation in Tyler Deploy the update failed with the below error:

OperationStopped: Could not create database user [username] in database [database]:

System.Management.Automation.MethodInvocationException: Exception calling "Drop" with "0" argument(s): "Drop failed for User 'username'. " ---> Microsoft.SqlServer.Management.Smo.FailedOperationException: Drop failed for User 'database'. ---> Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch. ---> System.Data.SqlClient.SqlException: Failed to update database "database" because the database is read-only.

Context
  • Munis ERP
  • Tyler Deploy
  • SQL Server
  • Database Properties
  • Permissions
Cause

SQL Server is unable to execute a Drop as the target database is in read-only mode stopping Tyler Deploy from finishing the step and update installation

Resolution

Option 1:

  1. Login to the Munis databases SQL Server instance
  2. Expand the Databases folder
  3. Right click on the effected Munis database
  4. Select properties from the context menu
    1. In the Database Properties window select the Options page
      1. In the Other Options menu scroll to the category labeled State
      2. In the Database Read Only drop down menu select False
  5. Click OK
  6. Run the desired Munis ERP update in Tyler Deploy
    1. How to Run or Schedule an Update in Tyler Deploy for a Product

Option 2:

  1. Login to the Munis databases SQL Server instance

  2. Use SQL query

  3. AlterDB Read-Only 
    ALTER DATABASE [database] SET READ_WRITE
Additional Information