Chat now with support
Chat mit Support

Active Administrator 8.8.1 - Installation Guide

Installation Considerations for Active Administrator Installing and configuring Active Administrator
Backing up your data Installing Active Administrator server Configuring the server Installing Active Administrator console Setting up the console Setting up workstation logon auditing Using Active Administrator
Appendix: Active Administrator Server Manager

To use an existing database

1
Ensure the existing database has been upgraded to the latest version before proceeding.
2
Select Use an existing Active Administrator database.
3
Type the target SQL Server or Azure SQL Managed instance.
4
Type the database name or browse to select the database.
5
Select the encryption to use for all data sent from the named server to the Active Administrator archive database.
Strict: Select this option for SQL Server 2022 and Azure SQL Managed Instance or when the instance has Force Strict Encryption enabled.
Mandatory: Select this option when the instance has Force Encryption enabled. It can also be used when no encryption is configured for the instance, but Trust server certificate is enabled. While this method is less secure than installing a trusted certificate, it does support an encrypted connection.
Optional
6
Enabling Trust server certificate, when 'Optional' or 'Mandatory' encryption is selected, or if the server enforces encryption, means that SQL Server will not validate the server certificate on the client computer when encryption is enabled for network communication.
* 
NOTE: If the Trust Server Certificate check box is not selected, Active Administrator will walk the validation chain until it finds a valid authority.
7
Under Host name in the certificate, you can provide an alternate, yet expected, Common Name (CN) or Subject Alternative Name (SAN) in the server certificate. You would use this option when the server name does not match the CN or SAN, for example, when using DNS aliases.
Leaving this option blank allows certificate validation to confirm that the CN or SAN matches the server name.
8
If using an Azure SQL Managed instance, select SQL Server Authentication, enter a SQL user ID that has login privilege for the SQL Managed instance, and enter the password for the SQL account.
9
The characters in the password will be hidden. Each character will be represented by a displayed dot. Select Show Password to display the password.
10
Click Test Connection to validate the database.
11
Click Next. See Setting the Active Administrator archive database.

Setting the Active Administrator archive database

The Active Administrator archive database stores events. By default, events older than 60 days are archived. You can either create a new archive database or use an existing archive database.

* 
NOTE:  
•
After you complete the configuration wizard, you can use the Active Administrator Console to manage archive databases by selecting Configuration | Archive Databases.
•
In a TLS 1.2 only environment, SQL 2012 Native Client must be installed on the Active Administrator server and agent servers, and the database server must be configured to use TLS 1.2.
•
Active Administrator supports TLS 1.3; however, TLS 1.2 remains a requirement since SQL Server 2022 satellite services require TLS 1.2 to be enabled. For more information on TLS support, see Microsoft documentation.

To create a new archive database

1
Select Create a new Active Administrator Archive database.
2
Click Next.
3
Type the target SQL Server or Azure SQL Managed instance.
4
Type a name for the database or use the default.
5
Select the encryption to use for all data sent from the named server to the Active Administrator archive database.
Strict: Select this option for SQL Server 2022 and Azure SQL Managed Instance or when the instance has Force Strict Encryption enabled.
Mandatory: Select this option when the instance has Force Encryption enabled. It can also be used when no encryption is configured for the instance, but Trust server certificate is enabled. While this method is less secure than installing a trusted certificate, it does support an encrypted connection.
Optional
6
Enabling Trust server certificate, when 'Optional' or 'Mandatory' encryption is selected, or if the server enforces encryption, means that SQL Server will not validate the server certificate on the client computer when encryption is enabled for network communication.
* 
NOTE: If the Trust Server Certificate check box is not selected, Active Administrator will walk the validation chain until it finds a valid authority.
7
Under Host name in the certificate, you can provide an alternate, yet expected, Common Name (CN) or Subject Alternative Name (SAN) in the server certificate. You would use this option when the server name does not match the CN or SAN, for example, when using DNS aliases.
Leaving this option blank allows certificate validation to confirm that the CN or SAN matches the server name.
8
If using an Azure SQL Managed instance, select SQL Server Authentication, enter a SQL user ID that has login privilege for the SQL Managed instance, and enter the password for the SQL account.
9
The characters in the password will be hidden. Each character will be represented by a displayed dot. Select Show Password to display the password.
10
Type a name for the archive or use the default.
11
Click Next.
12
If necessary, adjust the database size or file paths.
13
Select the security group type for the SQL groups.
14
Using the default group types is recommended.
15
Click Next. See Configuring purge and archive settings.

To use an existing archive database

1
Select Use an existing Active Administrator Archive database.
2
Type the target SQL Server or Azure SQL Managed instance.
3
Type the database name or browse to select the archive database.
4
Select the encryption to use for all data sent from the named server to the Active Administrator archive database.
Strict: Select this option for SQL Server 2022 and Azure SQL Managed Instance or when the instance has Force Strict Encryption enabled.
Mandatory: Select this option when the instance has Force Encryption enabled. It can also be used when no encryption is configured for the instance, but Trust server certificate is enabled. While this method is less secure than installing a trusted certificate, it does support an encrypted connection.
Optional
5
Enabling Trust server certificate, when 'Optional' or 'Mandatory' encryption is selected, or if the server enforces encryption, means that SQL Server will not validate the server certificate on the client computer when encryption is enabled for network communication.
* 
NOTE: If the Trust Server Certificate check box is not selected, Active Administrator will walk the validation chain until it finds a valid authority.
6
Under Host name in the certificate, you can provide an alternate, yet expected, Common Name (CN) or Subject Alternative Name (SAN) in the server certificate. You would use this option when the server name does not match the CN or SAN, for example, when using DNS aliases.
Leaving this option blank allows certificate validation to confirm that the CN or SAN matches the server name.
7
If using an Azure SQL Managed instance, select SQL Server Authentication, enter a SQL user ID that has login privilege for the SQL Managed instance, and enter the password for the SQL account.
8
The characters in the password will be hidden. Each character will be represented by a displayed dot. Select Show Password to display the password.
9
Click Test Connection to validate the archive database.
10
Click Next. See Configuring purge and archive settings.
Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen