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 |
5 |
6 |
If the database is from a previous version of Enterprise Reporter, the database will automatically be upgraded. Confirm that you have created a backup of your database by selecting I understand and wish to continue, then click Next. |
10 |
Review the warning message and click OK to continue. |
11 |
12 |
When the upgrade completes successfully, click OK to open the Encryption Key manager. |
13 |
Select the Export Key option to create an encryption key backup file. For more information, see Exporting a Key File . |
If you no longer want an Enterprise Reporter database, you can use the Database Wizard to remove it from the SQL Server®. You must have rights to remove a database.
1 |
2 |
Click Next. |
3 |
Select Remove Database. |
4 |
Enter the SQL Server® where the database is stored. |
6 |
Click Finish to remove the database. |
You can use the Database Wizard to change the security mode of the SQL Server® where your database resides. SQL servers can use either Windows® authentication (Integrated mode), or Windows® and SQL authentication (Mixed mode). Changing the security mode may grant access to additional groups and revoke access from already configured groups, so you should exercise caution with this option.
NOTE: If you change the security mode, it affects all databases on the SQL Server®, not just the Enterprise Reporter database. You must have adequate rights on the SQL Server® to make this change.
If you change the security mode to Windows®, any service configured to connect to the SQL Server® using SQL authentication will fail. |
1 |
2 |
Click Next. |
3 |
6 |
8 |
Click Finish to change the security mode. |
Using the Select/Upgrade Existing Database option, you can:
• |
Switch to a different Enterprise Reporter database. The database must be properly configured as outlined in Configuring the Database and Security Groups . The database will be automatically upgraded if required, so ensure you back up before using this option. |
• |
Change the credentials you are using to access the database. You can switch between Windows® (which uses the currently logged in credentials) and SQL. You can enter or update the SQL credentials as necessary. |
• |
1 |
On the computer hosting the Enterprise Reporter server, click the Start menu and select All Programs|Quest|Enterprise Reporter|Database Wizard. |
2 |
Click Next. |
3 |
4 |
If desired, change the SQL Server® or database name. |
7 |
Click OK to accept the message. |
8 |
Click Next. |
9 |
Click Finish to close the wizard. |
10 |
When the database has been selected successfully, click OK to open the Encryption Key manager. |
11 |
Select the Export Key option to create an encryption key backup file. For more information, see Exporting a Key File . |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Conditions d’utilisation Confidentialité Cookie Preference Center