Page History
You can upgrade the SQL Server software running on the existing Collection Server when you use your current SQL Compliance Manager installation to audit instances running on multiple versions of SQL Server at the same time in a single environment. Use the following checklist and instructions to successfully upgrade the SQL Server software.
Upgrade checklist
Follow these steps ... |
|---|
Determine whether you want to upgrade to the latest version of SQL Compliance Manager. To verify whether you are running the latest version, click Check for Updates on the Help menu. |
Choose the appropriate upgrade strategy for your environment and your auditing needs. |
Ensure your Windows logon account has administrator permissions on the Collection Server computer and sysadmin rights on the SQL Server instance hosting the Repository. |
Run the Microsoft SQL Server Upgrade Advisor utility on the target instance. For example, for more information about upgrading to SQL Server 2008, see Upgrade on the Microsoft Solutions Web site (http://www.microsoft.com/sqlserver/2008/en/us/solutions.aspx). |
...