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:
SQL Server Error: 2
[Microsoft][SQL Server Native Client 10.0]Named Pipes Provider:
Could not open a connection to SQL Server .
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.