The DBLayer service can authenticate with the SQL database using SQL Server Authentication. Here's how to configure it:

1. Edit the dblayer.ini File:

   • Locate the configuration file dblayer.ini.

   • Update the authentication settings as follows:

     Authentication=SQL Server User={SQL SERVER USERNAME} Password={SQL SERVER PASSWORD}

      

2. Use the Encrypted password:

   • The password should be encrypted. This encrypted password is created and stored during the Scout Board installation process.

3. Restart the DBLayer service:

   • After making changes, restart the Windows Server service:
     Scout Board DBLayer.

Scout Console and Scout Board access the SQL database differently:

1. Scout Console:

   • Connects directly to the SQL database and can switch to an application role.

2. Scout Board:

   • Uses a central service (DBLayer) to interact with the SQL database, similar to how the Scout Server operates as a central service.

• Scout Console connects directly to the database.
• Scout Board accesses the database via the DBLayer service, which can use SQL Server Authentication.
• To configure this, edit the dblayer.ini file with the SQL credentials, ensuring the password is encrypted, and restart the Scout Board DBLayer service.
• The SQL user must have appropriate permissions for all database tables.