I am trying to configure an instance of SQL Server 2008 across virtual clients in Windows Server 2008. The environment has these components:
Host: Windows Server 2008 64-bit
Guests (clients): Windows Server 2008 32-bit.
SQL Server 2008 installed on the host and one of the clients
The host and the clients are networked through an internal connection. They are visible and shareable, I can ping all machines. The SQL Servers perform with no issues on each individual machine, however, when I try to set up an ODBC across the images, it fails. I tried different protocols with the same result.
1) Is it possible at all to configure a SQL Server instance across images?
2) If yes, what is the trick to make it work?
Any suggestions would be appreciated.