Reconnect an administration configuration 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
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
-
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).