How To Enable / Disable Maintenance mode Using SQL query in Dynamics 365 for Finance & Operations

In finance and operations for making any changes in License configuration form, you need to enable maintenance mode and after making desirable changes you need to disable to this mode. You can enable or disable maintenance mode using SQL query as well as command prompt. In this blog, we are performing this operation using the SQL query.

The following are steps to enabling/disabling maintenance mode:-

  1. Open SSMS(Microsoft SQL Server Management Studio) in your server.
  2. Click on New Query and enter the following query to enable maintenance mode:-

    update dbo.SQLSYSTEMVARIABLESset dbo.SQLSYSTEMVARIABLES.VALUE =1

    where dbo.SQLSYSTEMVARIABLES.PARM = ‘CONFIGURATIONMODE’

     

  3. You can verify status using following command:-SELECT * FROM [AxDB].[dbo].[SQLSYSTEMVARIABLES]

  4. After this restart IIS services in some cases, you need to restart the server.
  5. perform your changes to the License configuration form.
  6. after desired changes are made you can disable mode using the following command

    update dbo.SQLSYSTEMVARIABLESset dbo.SQLSYSTEMVARIABLES.VALUE =0
    where dbo.SQLSYSTEMVARIABLES.PARM = ‘CONFIGURATIONMODE’
  7. Now again you can verify status using the same query in step 3 and again repeat step 4.I hope this blog will help you

Comments