The component of vmware horizon view that makes this functionality possible is the horizon view composer server. Jmp and vmware horizon 7 deployment considerations vmware. Database requirements for view composer and the events. Horizon view uses the events database as a repository to store logging information such as user connections. The database server for the event database can reside on a view connection server host itself or on a dedicated server. You do not need to create an odbc data source for this database. We will work on my vcenter vm which was already setup for my lab environment im using for vsphere 5, so this part of the setup is not included in.
Vmware horizon uses the event database to store logs about view manager events instead of storing data in a log file that is limited in information. In the oracle odbc driver configuration dialog box, type a dsn to use with view. Part 3 of the series will be creating the events database. First download the microsoft sql server 2008 r2 native client and copy it in to view composer machine. Configuring vmware horizon view event database once id. If you face this problem the first thing to do is to ensure that you are running a supported database. Alternatively, you can use a suitable existing database server, such as a server that hosts a view composer database.
Hi james, it is an sql api based connection to event database, there is no need of a odbc connection, view will do for you. Create odbc database connection in horizon view composer. From microsoft sql server management studio, right click databases and select new database. How to install database and odbc for vmware view esx. Restart the vmware virtualcenter management webservices service. In proof of concept poc environments ms sql server express can be used for the event database. Configuring vmware horizon view event database vmware. Please reconfigure your dsn to use one of the supported drivers. For an oracle 12c or 11g database, you must use the oracle system identifier sid as the database name when you configure the event database in view administrator.
The database specified is not supported by productname. Verify that you have a supported microsoft sql server or oracle database server on a system that a view connection server instance has access to. See add a database and database user for view events. In this part of the installing and configuring vmware horizon view 6 series we will be installing the vmware view composer database component. The first thing on my list to add into my new sql database was vmware view 5.
In the database information page, enter the name of the odbc dsn. See vmware 2081899 vmware horizon view composer fails to work properly after migrating the composer database to a new sql server. The purpose of this article is to explain how to use microsoft sql express to create a database server for the vmware horizon view event database and the composer database. Symptoms can include a black screen instead of correct desktop display. This tool connects to one or more existing horizon view event database s and allows the user to customize which types of alerts to be notified on. Sql server 2012 is already installed in db01 virtual machine running server 2012 r2. Database requirements for view composer and the events database. During the vcenter server installation, you use the dsn to establish a connection between vcenter server and the database. This brought up a dialog to set up the odbc connection. Of course, if youre unsure or still struggling, by all means contact our support team.
Steps to create odbc database connection in horizon view composer. Event information is not stored by default, and an event log database must be set up for view to record these events. After you add a view composer database to sql server, you must configure an odbc connection to the new database to make this data source visible to the view composer service. The composer component makes it possible for linked clones to be utilised which will drastically reduce. By the way, this blog part is in addition to the original blog post on how to install, configure and deploy vmware view 5 on vsphere 5. After the introductory post where i showed the basic setup which youll going to follow, now we going to kick the installation process. In view administrator, select view configuration event configuration. Update manager does not support windows authentication of the database when the database is located on a different machine because of local system account issues. So configuring the event database in the view environment is a best practice. But be careful odbc connection is not same as direct connection. Optional in the description text box, enter an odbc dsn description. Either option requires you to setup odbc database connection and separate database instance. Well that should be pretty straight forward you would think, stop the composer service, backup the database on server1, restore the database onto server2, change the odbc details on server1 to. In the event database section, click edit, enter the information in the fields provided, and click ok.
Add a database and database user for view events vmware docs. Using sql express for the horizon view event and composer. If you do, the jdbc connection does not work, and certain features, such as performance charts, are not available. Configure vmware horizon 6 event database and reporting. This application wraps around the vmware view client and allows the user to specify preconfigured settings. Configuring vmware horizon view event database vmware arena. Newer versions have a number of bug fixes for ssl certificate issues. Deploy the database server for the event database on a dedicated server, so that event logging activity does not affect provisioning and other activities that are critical for horizon 7 deployments. When you configure an odbc dsn for view composer, secure the underlying database connection to an appropriate level for your environment. If you receive this error message, it means you have connection problems with the db.
For remote sql databases, only sql accounts will work. For a list of supported database versions, see database requirements for view composer and the events database verify that you have the required database privileges to create a database and user on the database server. So now, all we have to do is, create new database for view events and call the database in view admin. Mssql and oracle are the supported databases to store the logs but in small environments the event database can be stored also in a ms sql express edition. So in this post, i will show steps to create odbc database connection in horizon view composer server.
If you are using a named instance of microsoft sql server 2008 standard edition with vcenter server, do not name the instance mssqlserver. Lets get started so the install of microsoft sql 2008 r2 should have been easy now the next step is to create the vmware view 5 database that view 5 will use. The database can reside on same server where vcenter database instance is located or you can setup dedicated database server for view composer. Make sure sql server authentication option is selected. When you configure an odbc dsn for view composer, secure the underlying. After you create and configure a sql server database and user for vcenter server, you must create a 64bit dsn on the machine on which you plan to install vcenter server. In a production environment you should use one of the supported databases mssql or oracle. To modify an existing sql server odbc connection, select the connection from the system data source list and click configure. With vmware, you have the freedom to build and deploy modern applications, from the data center to the cloud to the edge. Discover how you deploy and manage any application on any cloud, while maintaining the highest level of consistent infrastructure and operations.
How to set up a sql express database for horizon view. How to configure microsoft sql, and deploy vmware horizon view composer. With this, you can provision and deploy multiple linkedclone or the new instant clone desktops from a single gold or base image. The version of vmware tools that corresponds to vsphere 4. Following the steps to install new version of jdbc driver should address all the issue and completes the configuration of vmware view event database successfully. This is not moving the composer service, just the database.
Then after creating the odbc dsn using the 64bit driver and getting to the stage in the vcenter server installation process where you have to select an existing supported database you will see the name of the vcenter related database you created the 64bit odbc dsn for, as opposed to a blank white area with no sql servers specified. Make sure that if the update manager database is on a remote machine, the database, and the system dsn use sql server authentication. Switch back over to the view administrator console, drill down to view configuration event configuration then click edit. Enter the sql account credentials no windows accounts and click next. You can optionally set up an events database to record information from horizon connection server about horizon events. Dealing with issues with view event database vmware. Installing vmware view database and odbc connection in my lab. The diagram below shows the environment that we have been working on.
The security of the database connection between the view connection server instance and an external database is the responsibility of the administrator. For example, view composer can use the microsoft sql server instance provided with vcenter server. To view release notes for prior releases of vsphere 4. Last week i set up vmware horizon view 6 with view composer etc and ran into an issue with setting up a proper odbc connection for view composer. This blog post will take you through the first part of creating the database that view 5 needs. Configured dsn is pointing to an unsupported odbc driver. Create events database part 3 may 28, 2016 april 22, 2016 by daniel. If a database server instance already exists for vcenter server, view composer can use that existing instance if it is a version listed in supported database servers for view composer and for the events database. Using group policy to configure certificate checking in view client 83 8 creating an event database 85 add a database and database user for view events 85 prepare an sql server database for event reporting 86. To access the event database from horizon you should create a new user using sql server authentication.
Add an odbc data source to oracle 11g or 10g vmware. Right click logins under security and select new login. View composer server requires database of linked clone vdesktops. In this post, i will show you how to create odbc connection for view composer server installation. When i create a new event database for horizon view, persistently pestering me the message contained in the title of the post. In the name text box, enter an odbc data source name dsn. Setting up an odbc connection for horizon view composer. On the internet you can find quite a few hints as to deal with it, but none has proved to be helpful for me clues to solve my colleague, a specialist in ms sql, suggesting that it is probably a password policy that has been assigned to the local user, who owns the. When you perform a new installation or upgrade to vcenter server 4. The name of the event database that you created on the database server. Install vmware horizon view composer server 4sysops. Just wanted to know which os you are using for the connection server and have you done windows update on this machine.
If a database server instance does not already exist, you must install one. After you add a view composer database to an oracle 11g or 10g instance, you must configure an odbc connection to the new database to make this data source visible to the view composer service. For either of the db server, you need to create odbc connection. Before actually setting up a new odbc data source for vmware view composer, youll need to create a user and password on your database server. After the introductory post where i showed the basic setup which youll going to. Add a database and database user for view events vmware. Select the setup and right click, then select open to install the sql server 2008 r2 native client. After you add a view composer database to sql server. It allows aggregation of alerts across multiple horizon view pods and for near realtime alerting. For information about how to perform queries on all records in the event database, see the vmware view. October, 20 josh sinclair leave a comment deploying another view pod in our infrastructure i installed view. Verify that you have a supported microsoft sql server or oracle database server on a system that a connection server instance has access to. I dont see mention of this in the vmware kb articles relating to odbc.
To create a new sql server odbc connection, click add, select sql native client, and click finish. Today i will walk you through the process of setting up the vmware view events. Add a database and database user for horizon 7 events vmware. Create one or more vms that can be used as a master vm for instantclone desktop pools.
We had a requirement to migrate the view composer database from server1 to server2. In previous post, i had shown you the installation of microsoft sql 2012 with service pack 2. Below im going to create a database for horizon composer, and horizon events. On your vcenterserver system, select settings control panel administrative tools data sources odbc. I had no problems with odbc but with the direct connection. Login to view administrator portal using the url s.
1501 574 1303 282 1257 606 850 479 653 1043 1078 1528 4 102 865 374 204 552 42 455 310 404 816 52 380 320 485 918 916 177 1458 170 616 1019 143