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 your configuration 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 click to select it from a list.
   2. Enter the Database Name, or click to select it from a list.

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. Select Create to create a new database.

3. You must enter the SQL credentials to create an administration database.

   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.

4. Click 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 following message:

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.