Connect to the administration 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 your SQL server

Open: System Administration

1. If you haven't set up an administration database (or it can't be found), you will be prompted to configure the database when you first open System Administration.

2. 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

1. 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.

2. Enter the SQL Server name, or select it from the list (if available).

   To update the list, select the refresh button.

3. Enter the Database Name, such as Sage200Configuration.

4. 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.

5. Select OK to confirm the changes.

Restore an administration database

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

1. 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.

2. Select Restore to restore a database.

3. 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).

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.