Page History
...
- In the Microsoft Cluster Administrator tool (Windows Server 2003) or Microsoft Failover Cluster Management Console (Windows Server 2008), select the SQLComplianceCollectionService resource and take the service offline.
- Log on with an administrator account to the computer on which you want to upgrade SQL Compliance Manager.
- Run
Setup.exe
in the root of the SQL Compliance Manager installation kit on the first cluster node. - Under Install, click SQL Compliance Manager.
- Read the Welcome window, and then click Next.
- Review and accept the license agreement by clicking I accept the terms in the license agreement, and then click Next.
- Verify that the installation folder is the same location where you initially installed SQL Compliance Manager, and then click Next.
- Select the Clustered Collection Server setup type, and then click Next.
- Check the Install the Collection Server in a Windows Cluster check box.
- Select whether you are upgrading the Collection Service on the Currently Active Node or A Passive Node, and then click Next.
- If you upgrade the currently active node , verify that the SQL Compliance Manager Collection Service trace directory is the same location where you current directory resides, and then click Next. If you install on a passive node , continue with the next step.
- Type the service account information, and then click Next.
- Verify that the Repository path is the same SQL Server instance name hosting the Repository.
- Select the authentication method used to upgrade the Repository database and include credentials, if required, and then click Next.
- In the Repository Warning dialog box, click Preserve to retain your current Repository. If you click Delete, the upgrade tool DELETES all of your current Repository databases.
- Click Install.
- In Windows Services, stop the SQL Compliance Manager Collection Service and set the Startup type to Manual.
- Repeat the previous steps on each cluster node. Point to the SQL Compliance Manager Repository installed on the first node.
- In the Microsoft Cluster Administrator tool (Windows Server 2003) or Microsoft Failover Cluster Management Console (Windows Server 2008), select the SQLComplianceCollectionService resource and bring the service online.
Excerpt |
---|
SQL Compliance Manager audits all activity on your server. Learn more > > |