VMWare View 4.6 Compose ODBC Data Connector Fails

Posted on 2011-04-26
Last Modified: 2012-05-11
I am setting up a new VMWare View installation.  I am using VMWare ESXi 4.1 update 1, I have a VM running MS Server 2008 R2, MS SQL Server Express 2008 R2 64bit.  I have successfully installed VMWare View ConnectionServer 4.6.0-366101 (the latest) 64bit.  It is up and running, the licensing is in place, etc.  I am trying to install VMWare View Composer on the ConnectionServer, but when I try to setup ODBC connection to the local SQL Express server, I get the following error:  Connection failed:
SQLState: '08001'
SQL Server Error: 2
[Microsoft][SQL Server Native Client 10.0]Named Pipes Provider:
Could not open a connection to SQL Server [2].
Connection failed:
SQLState: 'HYT00'
SQL Server Error: 0
[Microsoft][SQL Server Native Client 10.0]Login timeout expired

I am trying to use Integrated Windows Authentication, which is how I setup SQL Express

I did go into SQL Server Configuration Manager and enabled SQL Server Network Configuration > Protocols > Named Pipes and TCP/IP and restarted the services and still nothing.

I am able to use SQL Server Management Studio to connect to the Databases and manage them, so I know it is actually up and running.
Question by:spencerburke
    LVL 116

    Expert Comment

    by:Andrew Hancock (VMware vExpert / EE MVE)
    have you tried setting up a connection with SQL Authentication?

    Author Comment

    I don't have a lot of experience with SQL in general (hence using express), so I am assuming in order to do this, I would go into the SQL Studio and change/add the SQL authentication?
    LVL 116

    Accepted Solution

    See this article here by Paul Slager

    Creating and Configuring the View Composer Database

    (it's for VMware View 4.5, but still valid for Composer database)
    LVL 116

    Expert Comment

    by:Andrew Hancock (VMware vExpert / EE MVE)
    use the SQL Server Authentication ID and Password when prompted.

    it's usually sa, followed by what ever password you've chosen.

    if you follow the article above, you'll see the dialogue box to use, tick the other box, not Windows one.

    Author Closing Comment

    Wow thanks, Composer has been installed!  That link was great...I was able to set it up using the correct terminology with Windows Authentication.  Apparently my lack of experience with setting the SQL and the connectors.  I followed the walk through in the link and everything went as I expected...thanks again!

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Suggested Solutions

    SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
    This Micro Tutorial walks you through using a remote console to access a server and install ESXi 5.1. This example is showing remote access and installation using a Dell server. The hypervisor is the very first component of your virtual infrastructu…

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now