Configuration Manager, SQL Settings

Configuration Manager, SQL Settings

Login to Content Central Server as an Administrator.

Launch Configuration Manager.




Go to SQL Settings.

Server Information

For Server name\Instance, enter the SQL Server Instance to use for the Content Central Database.

For Database Name, enter the Content Central Database Name to be used for Content Central Application.

Admin Login

Click to select the Authentication Method to use to connect to the SQL Server Name\Instance.

IF Windows Integration Authentication is selected, the User Account logged in as, must have Admin Rights to the SQL Server Name\Instance and Create/Update Rights to the Content Central Database in the Server Information.

IF SQL Authentication is selected, enter Username and Password to use. The SQL User Account must have Admin Rights to the SQL Server Name\Instance and Create/Update Rights to the Content Central Database in the Server Information.

User Login

Click to select the Authentication Method to use to connect to the SQL Server Name\Instance.

IF SQL Authentication is selected, enter Username and Password to use. The SQL User Account must have Read and Write Rights to the Content Central Database in the Server Information.

Click 'Test Admin Login'.
Connection will be tested to the SQL Server Instance using the Authentication Method under Admin Login settings.
Click 'Create/Update Database'
If the Content Central does not exist, a new Database for Content Central will be created under the SQL Server Instance selected.

If the Content Central exist, connection to the database is tested. 

After connection is established, schema version of the Content Central Database is verified and matched to the Content Central version.
Click 'Test UserLogin'.
Connection will be tested to the Content Central Database using the Authentication Method under User Login settings.

If the entered SQL User Account does not exist, a prompt will show to create a new user account using the User Name and Password enter under User Login settings.



    • Related Articles

    • Configuration Manager

      Configuration Manager is a Server Application for the configuration of Content Central. SQL Settings System Folders Active Directory License External Application Export Data  System Folders Document Root Folder  When a new Catalog is created, the set ...

    • OCR Settings

      This applies to Content Central Document Management System. There is OCR Settings in the System Settings where these settings can be enabled or disabled.  Steps:  1. Login to Content Central as Admin. 2. Go to "Administration>System Setting" 3. Click ...

    • How to Create an SQL Content Central Backup File using SSMS

      Launch SSMS or SQL Server Management Studio Connect to SQL Server. Refer to the Configuration Manager > SQL Settings for the "Server\Instance Name" to connect to. Locate the Content Central Database to back up under the Databases section. Refer to ...

    • Login Logout Settings

      This feature applies to Content Central Document Management System. The Login Logout Settings allows Content Central to be able to manage the Login and Logout Activities of the users in Content Central. Steps to configure Login Logout Settings  Login ...

    • Notification Settings, System Settings

      This applies to Content Central Document Management System. The Notification Settings in System Settings can be configured so that your preferred Content Central URL will be used for any outgoing notification or messages from Content Central, where ...