Open topic with navigation

> Administration / Manage database connection / Connect to database

/  More

Connect to database

Open: System Administration.

On Premise deployment

1. If your SQL server is password protected or has stopped, a prompt appears, asking if you want to configure the System Administration database.

   • Click Yes to set up a connection.
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.
3. Click Create to create the administration databaseThe administration database contains your configuration information and settings for System Administration. .

If Sage 200 detects any background taskThese 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 so, wait until they have finished before trying again. If not, you can clean up the background tasks. To do this, select Sage 200 SA and then select Clean up background tasks.

4. 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.
5. Click Test or Update to test or update the company.
6. Click OK to confirm the changes.

7. The Logon window appears, and you can log on to Sage 200 System Administration.

Sage 200 Online

1. Click Create to create the administration database.

If Sage 200 detects any background taskThese 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 so, wait until they have finished before trying again. If not, you can clean up the background tasks. To do this, select Sage 200 SA and then select Clean up background tasks.

2. Click Test or Update to test or update the company.
3. Click OK to confirm the changes.

The Logon window appears, and you can log on to Sage 200 System Administration.