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. 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. From microsoft sql server management studio, right click databases and select new database. 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 version of vmware tools that corresponds to vsphere 4. You can optionally set up an events database to record information from horizon connection server about horizon events. Add a database and database user for view events vmware docs. Alternatively, you can use a suitable existing database server, such as a server that hosts a view composer database. If you do, the jdbc connection does not work, and certain features, such as performance charts, are not available. 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. 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.
Steps to create odbc database connection in horizon view composer. Verify that you have a supported microsoft sql server or oracle database server on a system that a connection server instance has access to. See add a database and database user for view events. With vmware, you have the freedom to build and deploy modern applications, from the data center to the cloud to the edge. Configure vmware horizon 6 event database and reporting. When i create a new event database for horizon view, persistently pestering me the message contained in the title of the post. In proof of concept poc environments ms sql server express can be used for the event database. Configuring vmware horizon view event database vmware. 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. To modify an existing sql server odbc connection, select the connection from the system data source list and click configure.
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. Please reconfigure your dsn to use one of the supported drivers. 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. How to configure microsoft sql, and deploy vmware horizon view composer.
The component of vmware horizon view that makes this functionality possible is the horizon view composer server. During the vcenter server installation, you use the dsn to establish a connection between vcenter server and the database. The database can reside on same server where vcenter database instance is located or you can setup dedicated database server for view composer. Either option requires you to setup odbc database connection and separate database instance. 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. When you configure an odbc dsn for view composer, secure the underlying. If you are using a named instance of microsoft sql server 2008 standard edition with vcenter server, do not name the instance mssqlserver. 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. So now, all we have to do is, create new database for view events and call the database in view admin. 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. So configuring the event database in the view environment is a best practice.
The database specified is not supported by productname. It allows aggregation of alerts across multiple horizon view pods and for near realtime alerting. Switch back over to the view administrator console, drill down to view configuration event configuration then click edit. Right click logins under security and select new login.
In the database information page, enter the name of the odbc dsn. The diagram below shows the environment that we have been working on. To view release notes for prior releases of vsphere 4. When you perform a new installation or upgrade to vcenter server 4. In the event database section, click edit, enter the information in the fields provided, and click ok. This application wraps around the vmware view client and allows the user to specify preconfigured settings. Sql server 2012 is already installed in db01 virtual machine running server 2012 r2. Database requirements for view composer and the events database.
For remote sql databases, only sql accounts will work. We had a requirement to migrate the view composer database from server1 to server2. Part 3 of the series will be creating the events database. For example, view composer can use the microsoft sql server instance provided with vcenter server. Horizon view uses the events database as a repository to store logging information such as user connections. 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. How to set up a sql express database for horizon view. Newer versions have a number of bug fixes for ssl certificate issues.
You do not need to create an odbc data source for this database. Optional in the description text box, enter an odbc dsn description. For either of the db server, you need to create odbc connection. Just wanted to know which os you are using for the connection server and have you done windows update on this machine. First download the microsoft sql server 2008 r2 native client and copy it in to view composer machine. Restart the vmware virtualcenter management webservices service. Configuring vmware horizon view event database vmware arena.
Create odbc connection for vmware horizon view composer. Add an odbc data source to oracle 11g or 10g vmware. Symptoms can include a black screen instead of correct desktop display. If you receive this error message, it means you have connection problems with the db. I had no problems with odbc but with the direct connection. Create one or more vms that can be used as a master vm for instantclone desktop pools. But be careful odbc connection is not same as direct connection. 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. The database server for the event database can reside on a view connection server host itself or on a dedicated server. This blog post will take you through the first part of creating the database that view 5 needs.
Optional in the event settings window, click edit, change the length of time to show events and the number of days to classify events as new, and click ok. This is not moving the composer service, just the database. 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. The name of the event database that you created on the database server. 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. Select the setup and right click, then select open to install the sql server 2008 r2 native client. Discover how you deploy and manage any application on any cloud, while maintaining the highest level of consistent infrastructure and operations. Enter the fqdnip address of your sql server, database name, and the login created from above. Configuring vmware horizon view event database once id. After the introductory post where i showed the basic setup which youll going to. See vmware 2081899 vmware horizon view composer fails to work properly after migrating the composer database to a new sql server. In this part of the installing and configuring vmware horizon view 6 series we will be installing the vmware view composer database component. 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.
How to install database and odbc for vmware view esx. Dealing with issues with view event database vmware. In this post, i will show you how to create odbc connection for view composer server installation. Install vmware horizon view composer server 4sysops. This brought up a dialog to set up the odbc connection. Setting up an odbc connection for horizon view composer. Below im going to create a database for horizon composer, and horizon events. For information about how to perform queries on all records in the event database, see the vmware view. Today i will walk you through the process of setting up the vmware view events. I dont see mention of this in the vmware kb articles relating to odbc. In the oracle odbc driver configuration dialog box, type a dsn to use with view.
Login to view administrator portal using the url s. 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. Enter the sql account credentials no windows accounts and click next. After you add a view composer database to sql server. 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. Create events database part 3 may 28, 2016 april 22, 2016 by daniel. October, 20 josh sinclair leave a comment deploying another view pod in our infrastructure i installed view. To access the event database from horizon you should create a new user using sql server authentication. The first thing on my list to add into my new sql database was vmware view 5. In previous post, i had shown you the installation of microsoft sql 2012 with service pack 2. Using sql express for the horizon view event and composer. The composer component makes it possible for linked clones to be utilised which will drastically reduce. The security of the database connection between the view connection server instance and an external database is the responsibility of the administrator.
Make sure sql server authentication option is selected. Add a database and database user for view events vmware. Add a database and database user for horizon 7 events vmware. Create odbc database connection in horizon view composer. Make sure that if the update manager database is on a remote machine, the database, and the system dsn use sql server authentication. Installing vmware view database and odbc connection in my lab. Event information is not stored by default, and an event log database must be set up for view to record these events. 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 in this post, i will show steps to create odbc database connection in horizon view composer server. If a database server instance does not already exist, you must install one. To create a new sql server odbc connection, click add, select sql native client, and click finish.
In the name text box, enter an odbc data source name dsn. 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. 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. Jmp and vmware horizon 7 deployment considerations vmware. Database requirements for view composer and the events. In a production environment you should use one of the supported databases mssql or oracle. 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.
Configured dsn is pointing to an unsupported odbc driver. After the introductory post where i showed the basic setup which youll going to follow, now we going to kick the installation process. Of course, if youre unsure or still struggling, by all means contact our support team. With this, you can provision and deploy multiple linkedclone or the new instant clone desktops from a single gold or base image. View composer server requires database of linked clone vdesktops. In view administrator, select view configuration event configuration. If you face this problem the first thing to do is to ensure that you are running a supported database. 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.
1623 648 620 647 1664 363 1539 1514 1089 235 27 364 1067 28 774 873 1284 895 1690 4 999 1018 1025 249 1372 629 692 156 1496 994 1354 788 203 807 186 691 1041 137 917 1463 1308 80 1396 568 1461 1062