Connect to the administration configuration database

When you first use System Administration, you must set up the connection to your server and administration database The administration database (or configuration database) contains information and settings for System Administration..

Connect to an existing administration database (SQL server)

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

Open: System Administration

If you haven't connected to the administration database (or it can't be found), you will be prompted to configure the database when you first open System Administration.
Enter the Database Settings.
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).

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 (SPP)

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 (SPP)

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.