Thank you for your feedback.

Was this useful?

How to unlock the SQL database after an update failure

Article ID

kba-02842

Article Name

How to unlock the SQL database after an update failure

Created Date

12th July 2011

Product

Problem

During the update process the PTP Accounts Production SQL database is locked to prevent user access during the update. However, should an update fail, the database may be left in this locked state and users may encounter a message saying that the database is locked to do an update.

Resolution

The following steps should unlock the PTP Accounts Production database:

 

1.       Click StartAll ProgramsMicrosoft SQL ServerSQL Server Management Studio

2.       In the Server Name box, select the PTP SQL instance (by default this is PTPACCOUNTS)

3.       Click the Connect button

4.       Click the + next to Databases

5.       Right click on the PTP database (by default this is called PTPACCTS) and choose Properties

6.       Go to the Extended Properties section

7.       Change the IRISDatabaseUpgradeInProgress value to FALSE

8.       Click the OK button

9.       Close the SQL Server Management Studio

 

It should now be possible to open PTP Accounts Production (or re-run the update).

Thank you for your feedback.

Was this useful?