Click the Resources tab to configure the servers and database assigned to this role.
- Servers:
Servers hosting this role.
- Database status: Current status of the database.
- Database server: Name of the SQL Server service. The value
(local)\SQLEXPRESScorresponds to Microsoft SQL Server 2014 Express Edition installed by default with Security Center Server. - Database: Name of the database instance.
- Actions: Maintenance functions you can perform on the role database:
- Create a database (
): Create a new database with the option to overwrite the existing one. - Delete the database (
): Delete the database. - Database info (
): Show the database information. - Notifications (
): Set up notifications for when the database space is running low. - Backup/Restore (
): Back up or restore the database.
- Authentication: Specifies which SQL Server authentication is to be used:
- Windows: (Default) Use Windows authentication when the role server and the database server are on the same domain.
- SQL Server: Use SQL Server authentication when the role server and the database server are not on the same domain. Mandatory for Azure SQL Database. You must specify a username and password in this case.
- Database security: Security options for communication between the role and its database server.
- Encrypt connections: (Default) Uses Transport Layer Security (TLS) protocol for all transactions between the role and the database server. This option prevents eavesdropping and requires no setup on your part.
- Validate certificate: Authenticates the database server before opening a connection. This is the most secure communication method and prevents man-in-the-middle attacks. The Encrypt connections option must first be enabled.NOTE: You must deploy a valid identity certificate on the database server. A valid certificate is one that is signed by a certificate authority (CA) that is trusted by all servers hosting the role and that is not expired.
- Images saved to: Archiver role responsible to manage the images (license plate, contextual, and wheel images) that are associated to the reads and hits.BEST PRACTICE: Select an Archiver that is not also managing video units. If all your current Archiver roles are managing video units, create a new one.
NOTE: When using the cloud base Azure database, the Notifications and
Backup/restore options are disabled.
