• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1267
  • Last Modified:

VMWare View 4.6 Compose ODBC Data Connector Fails

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.
0
spencerburke
Asked:
spencerburke
  • 3
  • 2
1 Solution
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
have you tried setting up a connection with SQL Authentication?
0
 
spencerburkeAuthor Commented:
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?
0
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
See this article here by Paul Slager

http://paulslager.com/?p=717

Creating and Configuring the View Composer Database

(it's for VMware View 4.5, but still valid for Composer database)
0
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
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.
0
 
spencerburkeAuthor Commented:
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!
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now