While configuring the Events Database in VMware Horizon View 5.x, you might see the following error message:
An error occurred while attempting to configure the database. Double check the database parameters and ensure that the database is not down, restarting, or otherwise unavailable
A customer had this problem for a while and they had tried quite a few things to resolve this without success. All the usual things e.g. Firewall, UAC, database ownership etc. were as expected but all attempts to configure the database resulted in the error message shown above.
The environment was slightly different from the norm in the sense that the database server (Microsoft SQL 2008 R2) had “SQL Instances” configured. So, I double-checked that TCP Dynamic Ports setting is disabled and a static port is configured for that instance. It was all good too!
Running out of options, I checked the collation set for the database. It was set to “Case Sensitive” i.e. Latin1_General_CS_AS. As far as I knew, it should be set to “Case Insensitive” i.e. Latin1_General_CI_AS so the database was deleted and recreated using that collation. Once done, the configuration was retried and it worked immediately!
Collation is not something that one would look at normally and hence this post. It can happen if you don’t set anything on the database when creating it, in which case, the database is created with the collation set on the server. That collation might not be what you want. Obviously, it could also be a genuine mistake and set manually or via a script upon creation. Either way, the fix is to recreate the database with the case-insensitive collation set.
Hope this helps!
Ather
[…] persistently pestering me the message contained in the title of the post. On the Internet you can find quite a few hints as to deal with it, but none has proved to be helpful for […]
Hi Ather,
I had very big exhausting experience with this problem. Every step was taken, nothing left out, to run the database properly. So in my case it was:
I got a certificate from my sysadmin without private key! I installed it and it seemed ok. Then I tried to configure the database and it went wrong. Numerous days and hours and nothing until:
I ran mmc and added the certificate add-in and went to Certificates/Personal/Certificates and right click on my installed certificate and disabled for all intended purposes.
What a surprise after I restarted the service and tried to add the DB. It smoothly connected.
But be careful “ODBC connection is not same as direct connection”. I had no problems with ODBC but with the direct connection. In this case it was Horizon View 6.0.1 Connection Server which needed this direct connection.
Best regards,
Andrew
Cheers Andrew!
This is great and very helpful feedback. I’ll definitely keep this in mind.
Best regards,
Ather
Thanks Ather. It’s not a rocket science to configure event database but I always fail to configure this first time 🙂
There is an alternate option to configure event database i.e syslog server, local / UNC file event logging.
http://goo.gl/u28EFP
Cheers!!
Thanks Joseph. Indeed, it isn’t rocket science to configure the events database but still, there are many ways in which one can get it wrong. Case in point the article above – not a common error!
Of course, there are many other options but the client in this case, wanted the events database itself 🙂
Ather