Software being used:
- Microsoft SQL Server 2016
- Microsoft SQL Server Management Studio 18.4
- VMware Horizon 7.12.0
Configure Microsoft SQL Server
After installing Microsoft SQL Server, a few things need to be configured:
1. Ensure TCP port 1433 is open on any firewall software running on the server.
2. Add a machine certificate to local machine personal store (certlm.msc)
2a. Be sure to add the account that runs the SQL service to the private key. See this post for more details. MSSQL SSL/TLS Certificate Chain Fix
3. Add certificate to Microsoft SQL server. (ref: https://support.microsoft.com/en-us/help/316898/how-to-enable-ssl-encryption-for-an-instance-of-sql-server-by-using-mi)
4. Open Sql Server Configuration Manager. Right-click Protocols for <INSTANCE-NAME>, choose Properties.
5. Click on the Certificate tab.
6. Choose the machine certificate you added earlier, click OK.
7. Back on the Sql Server Configuration Manager window, double-click TCP/IP.
8. Ensure the following settings:
9. Check the Active, Enabled, IP Address, and TCP Port settings. Modify as necessary and click OK. If you do make any modifications, be sure to restart the SQL service.
Creating the VMware Horizon Database and User
- Open Microsoft SQL Server Management Studio.
- Ensure the SQL server authentication is set to SQL Server and Windows Authentication mode. VMware Horizon does not use Integrated Windows Authentication. (https://docs.vmware.com/en/VMware-Horizon-7/7.12/horizon-installation/GUID-1360BFDF-9F90-47FD-8B6C-E842CF951A53.html)
3. Right-click Databases and choose New Database…
4. Fill in the Database name with a meaningful name. Click OK.
5. Expand Security and Right-click Logins.
6. On the General page, fill in the Login name with a meaningful name. Also choose a password and uncheck Enforce password policy unless you use a strong password. Change the Default database and Default language accordingly.
7. On the Server Roles page, check the sysadmin role.
8. On the User Mapping page, check the database name you created earlier. Click OK.
Configure the Event Database on Horizon View Connection Server
ref: https://docs.vmware.com/en/VMware-Horizon-7/7.12/horizon-installation/GUID-E04FDAC2-AD7B-4B09-B6E0-4A541646869B.html
