Edit the server and administration configuration database

Open the database properties to create, edit, test or update the administration database The administration database (or configuration database) contains information and settings for System Administration. on the server.

Edit your SQL server settings

This is only applicable to Sage 200 Professional deployed on-premise.

Open: System Administration

Select Sage 200 SA (at the top of the Navigation Area), then select Action > Properties.
Enter the Database properties.
1. Enter the SQL Server name, or select it from the list (if available).
  
  To update the list, select the refresh button.
2. Enter the Database Name of the administration database, or select it from the list (if available).
Select Test to check your server and database details.

If the database connection is found, the version of the administration database is displayed.
Select OK to confirm the changes.

Test administration database settings

If you change your server or database details, you can test the connection to confirm they are correct.

Open: System Administration

Select Sage 200 SA (at the top of the Navigation Area), then select Action > Properties.
Select Test to check your server and database details.

If the database connection passes the test, the version of the administration database is displayed.

Update administration database

You should update the administration database if you have updated Sage 200 to a new version, or have migrated an administration database from an older version.

Open: System Administration

Select Sage 200 SA (at the top of the Navigation Area), then select Action > Properties.
Select Update to update the administration database.

Note: You must enter SQL credentials (Logon Name and Password) in order to perform actions on the administration database.

Once the database has been updated, the version number of the administration database is displayed.

Create a new administration database

Open: System Administration

Select Sage 200 SA (at the top of the Navigation Area), then select Action > Properties.

If you haven't set up an administration database, the database properties are displayed when you first open System Administration.
Enter the SQL Server name, or select it from the list (if available).

To update the list, select the refresh button.
Enter the Database Name, such as Sage200Configuration.
You will be asked to enter your SQL credentials.

Enter the User Name and Password for an SQL user that has rights to create a database, or choose Use Integrated Windows Authentication.

Note - information
This is only applicable to Sage 200 Professional deployed on-premise.
Select OK to confirm the changes.

Restore an administration database

This is only applicable to Sage 200 Professional deployed via the Sage Provisioning Portal.

If you are migrating an administration database to Sage 200 Professional deployed via the Sage Provisioning Portal, you can select Restore to restore this database from a bacpac.

You must first upload the bacpac file with the administration database to the Sage Provisioning Portal.

Open: System Administration

Select Sage 200 SA (at the top of the Navigation Area), then select Action > Properties.

If you haven't set up an administration database, the database properties are displayed when you first open System Administration.
Select Restore to restore a database.
Select the bacpac file you have uploaded to the Sage Provisioning Portal.

Restoring the database can take a while to complete.

Note: After this has completed, you will be prompted to link your users from the administration database using Manage User Lists. See Manage user lists (update users).

Reconnect an administration database

This is only applicable to Sage 200 Professional deployed via the Sage Provisioning Portal.

This feature is only available from Sage 200 Professional 2025 R1 version onwards.

When you update to a new version of Sage 200 Professional deployed via the Sage Provisioning Portal, you can use the Import databases feature (in SPP) to copy the databases from your previous site to your new site. For help on how to upgrade your site in SPP, see Knowledgebase article: Sage 200 Professional – Deployed via the Sage Provisioning Portal (Sage Partner Cloud) – Upgrade FAQs (opens in a new tab).

After you have imported the databases to your new site in SPP, you must first reconnect the administration configuration database in System Administration. This will configure the connection to the administration configuration database on your new site.

To reconnect your administration configuration database:

Open: System Administration

You will be asked to set up the administration configuration database properties when you first open System Administration, if a database cannot be found.

If you need to display the database properties again, select Sage 200 SA (at the top of the Navigation Area), then select Action > Properties.
Select Reconnect.
Select the administration configuration database that you imported to your site in the Sage Provisioning Portal, then select Reconnect.
After the database has been reconnected, use Manage User Lists to update your users list. New users that are associated with the administration configuration database can be added, and old unlinked users can be removed. For more information, see Manage user lists (update users).
Enter your licence details to register Sage 200.

To find your details, see Where do I find my licence details in the Sage Provisioning Portal?

You must also reconnect any company databases that you imported to your new site. See Reconnect a company database (SPP).

Troubleshooting

If Sage 200 detects any background task These are long running processes, for example, creating and updating databases., you will see the message Another administration task is in progress. Please retry at a later time.

Check whether another Sage 200 user is creating, updating or deleting companies at the time.

If other users are using Sage 200, wait until they have finished before trying again.
If other users are not using Sage 200, you can clean up the background tasks.

To do this, select Sage 200 SA to display the information page, then check Active Background Tasks. If any background tasks are running, then you will be able to select Clean up background tasks.