Tyler Deploy error during Configure Database step

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.

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

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

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 Expand source

   ALTER DATABASE [database] SET READ_WRITE