VMware Horizon – Setup DB for Composer

Welcome to my VMware Horizon series. In this session I will describe how I setup my database for the VMware Horizon Composer server. I have, after I created this session, moved my SQL database to a SQL AlwaysOn Cluster, covered here: VMware Horizon – Move Composer DB to AlwaysOn Sql Cluster

For this database I will be using my existing MS SQL Database server.

 

Right-click Databases – New Database

sql-conf03

 

Give the database a name, as this will be the composer-database for the Composer-server, I’ll call it ViewComposer

setup_db_for_comp-02

setup_db_for_comp-03

setup_db_for_comp-04

 

Next we will setup sql-permissions for the ViewComposer-database, right-click Logins – New Login…

sql-conf06

 

I will create a new sql-user: viewcomposeradmin, be sure to uncheck “Enforce password policy”

setup_db_for_comp-06

 

The Server Role “Public” will be sufficient for my ViewComposerAdmin-user

setup_db_for_comp-07

 

I map my user to my newly created ViewComposer-database and give the user db_owner membership for this database.

setup_db_for_comp-08

 

Be sure to grant permission to connect and login to database is selected.

sql-conf11

 

Recommended reading:

 

VMware Horizon planning, deployment etc.

Disclaimer: Every tips/tricks/posting I have published here, is tried and tested in different it-solutions. It is not guaranteed to work everywhere, but is meant as a tip for other users out there. Remember, Google is your friend and don’t be afraid to steal with pride! Feel free to comment below as needed.