/
Server database update button is disabled

Server database update button is disabled

Owned by Mattias Löfstrand
Last updated: 12 Oct 2016

Problem

When trying to update the server database, the update button is disabled despite several pending migrations.

Solution

Likely your server database was created in September 2016 or earlier.

  1. Start SQL Server and create a backup of the server database.
  2. Download the below sql script.
  3. Select the server database.


  4. Run the script in SQL Server.
  5. Verify by signing in to the ServerAdmin of the web viewer and check that the update button now is enabled.

Download sql-script




Note! Ensure to make a backup of Server database before running any migration scripts.

It is recommended that you test migration of client ServerDB in a staging environment prior to updating production environment.


Related content

Problem saving permissions in Manager
Problem saving permissions in Manager
Signifikant Knowledge Base
More like this
Update server database or asset database
Update server database or asset database
Signifikant Knowledge Base
More like this
Migrate editor database to version 5.1 fails
Migrate editor database to version 5.1 fails
Signifikant Knowledge Base
More like this
Update site database
Update site database
Signifikant Knowledge Base
More like this
Create DATABASE permission denied in database 'master'
Create DATABASE permission denied in database 'master'
Signifikant Knowledge Base
More like this
The server was not found or was not accessible
The server was not found or was not accessible
Signifikant Knowledge Base
More like this