Install Guide
6. Run the following script on the database:
Use RapportDB
GO
Update Install set ServerName='NEWCLUSTER01' where Module='Rapport4DB'
7. When you install the WDM components without the database, make sure you provide the name of the SQL Database Cluster
name in the Server IP Address eld.
8. Create the same directory structure pointing to the database location both in the primary as well as the secondary node. For
example, if the database is present in C:\Program Files\WYSE\WDM\Database in the primary node, create the same
structure in the secondrary server as well.
9. Launch the SQL Server Management Studio on the primary node. Login with the default SQL user name and password.
10. Right-click on RapportDB database and select Properties.
11. In the Database Properties screen, change the Recovery Model to Full.
12. Right-click on the RapportDB and select Tasks → Backup to take a backup of the RapportDB.
13. Leave the defaults on the Backup Database screen and click OK.
14. Right-click on AlwaysOn High Availability in the Object Explorer and select New Availability Group Wizard.
15. Click Next on the New Availability Group Wizard screen.
16. Provide a name for the Availability group such as Rapport_cluster and click Next.
17. Select the database and click Next.
18. Click Add Replica and select the Automatic Failover (up to 2) and Synchronous commit (up to 3) check-boxes.
Repeat the step for the secondary node.
19. Click Next.
20. Select the Full option and specify the shared folder location as \\
<Name of the Quorum Machine>
\quorum. Click Next.
21. Make sure that the Validation screen does not display any failures.Click Next.
22. If you see any warnings on the screen, you can ignore them and proceed with the installation.
23. Click Finish to complete installing the New Availability Group.
24. The progress window displays the progress of the installation. Click Next when installation completes.
25. View the results and click Close.
26. The primary and secondary nodes are displayed on the SQL Server Management Studio.
27. Shutdown the secondary node and check to make sure that the primary node is running in the cluster.
28. Launch the SQL Server Management Studio on the primary node. Login with the default SQL user name and password.
29. Click the Security node, select Login, right-click and select New Login to create the Rapport user. This step is important for
WDM to function as you are creating the SQL Server Authentication user.
30. Select Server Roles, select the sysadmin check-box and click OK.
31. View the Rapport user on the SQL Server Management Studio.
32. Repeat steps 28 — 31 on the secondary node.
NOTE: If there is a fail-over from the primary database to the secondary database, you must restart the WDM UI.
GUID-29EA3E95-3905-4306-9E74-02BDCD898FED
Running the HA Conguration Utility
WDM needs to connect to the cluster in order to function within the cluster and ensure that there is zero downtime.
The High Availability Conguration Utility is available after you install WDM on a separate node other than the primary and secondary
nodes.
1. Log in to the system where you have installed WDM.
2. Launch the HACongureUtility from Start → All Programs → Dell Wyse Device Manager → Utilities.
3. Enter the following details:
• Congure Setup As – select Cluster from the drop-down list.
• Database Name – this is displayed by default and cannot be edited.
67