• |
Click the Start menu, select All Programs | Quest | Enterprise Reporter | Database Wizard and click Next. |
1 |
• |
Strict (SQL Server 2022): 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. |
• |
For more information, see Security Groups in Enterprise Reporter .
9 |
Review the message box, and click OK to continue. |
11 |
Click Finish to create the database. |
12 |
When creation is complete and successful, a notice to backup the encryption key is displayed. Click OK to accept the message and start the Encryption Key Manager. |
IMPORTANT: It is important to backup the encryption key. The Encryption Key Manager will automatically start on the Enterprise Reporter Server. Use the Export Key option to create a back up file of the encryption key. For more information, see Appendix: Encryption Key Manager . |
For help troubleshooting errors, see Database Configuration Issues .
13 |
Click Cancel. |
1 |
If you are starting the Database Wizard from the Start menu, click the Start menu and select All Programs | Quest | Enterprise Reporter | Database Wizard and click Next. |
2 |
• |
Strict (SQL Server 2022): 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. |
• |
8 |
Confirm that you have created a backup of your database by selecting I understand and wish to continue and click Next. |
12 |
Review the warning message and click OK to continue. |
13 |
14 |
When the upgrade completes successfully, click OK to open the Encryption Key manager. |
15 |
Select the Export Key option to create an encryption key backup file. For more information, see Exporting a key file . |
1 |
2 |
Click Next. |
3 |
Select Remove Database. |
6 |
Click Finish to remove the database. |
1 |
2 |
Click Next. |
3 |
• |
Strict (SQL Server 2022): 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. |
• |
9 |
Click Finish to change the security mode. |
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center