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

Share Story :

SEARCH :

FOLLOW CLOUDFRONTS BLOG :

FOLLOW CLOUDFRONTS BLOG :

Enter your email address to follow this blog and receive notifications of new posts by email.

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close