Vmware Horizon View 6 "Unable to connect to view composer"

We are setting up vmware Horizon View 6 for a single domain environment of about 200 users. I have followed the VM Horizon 6.0 Installation Guide word for word. I am working with Server 2012 R2 servers, one each for the following roles: Composer, Connection server, Security server. I have made it to the point where I am trying to add the vcenter server in VMware Horizon View Administrator on the connection server. I have configured the viewcomposer databse in SQL Server Express 2012 as indicated by the horizon guide.

I have configured SSL certificates issues by a CA on our domain and installed the certs on the composer and connection server. When I am on the connection server localhost/admin/ I go to View Configuration -> Servers -> Add and I enter the vsphere ip and credentials as the IP for the Vcenter server address: IPaddress, domain\vcenteradmin and password -> view certificate -> accept -> Standalone View Composer Server -> Viewcomposerserver.domain.local -> domain\vcenteradmin -> password -> Next

And I am getting the error message "Unable to connect to View Composer"

I have also tried adding a user in vcenter as vsphere.local\vcenteradmin with full admin privileges and still had no success.

Any ideas?
LVL 1
CCtechAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

CCtechAuthor Commented:
Also, a lot of the guide asks to add the vcenteradmin user that was created in AD to the local administrators group on the vcenter server. However, we're not using a microsoft OS as vcenter server, we're using the linux vcenter appliance.
0
CCtechAuthor Commented:
I think it is an issue with connecting to the sql database.

I am using SQL server 2012 express with windows authentication. I have added the viewcomposer database. I can log in to the sql instance with a domain admin - mydomain\vcenteradmin. I have enabled the TCP/IP protocol. See attached. I have configured the ODBC connector shown in attachments. When I test the connector works.

When I go to add the vcenter server, it works. When I go to add the composer server, it fails. See attachments.
1.JPG
2.JPG
3.JPG
4.JPG
5.JPG
6.JPG
7.JPG
8.JPG
9.JPG
0
CCtechAuthor Commented:
We were able to make some progress. When looking through the event log on the Composer server we found a ton of authentication failures. We changed the SQLEXPRESS instance to sql server and windows authentication. We added the default view composer port to the TCP/IP properties for the SQLEXPRESS instance.



2.JPG
 

We also added an ODBC connector using the 18443 port to the connection server. After this, we got past the unable to connect error. We are now getting "Internal View Composer error. Contact your administrator." So we're past authentication errors with the SQL database, as we were also able to configure the event database now on the same sql server.

3.JPG
0
CCtechAuthor Commented:
I opened a support case with VMware. They had me remove and re-install View Composer. This resolved the issue.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
VMware

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.