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