Solved

SQL Server 2008 in Windows Server 2008 Hyper-V clients

Posted on 2009-07-10
1
264 Views
Last Modified: 2013-11-06
Hello,

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.

My questions:

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.

Thank you!


0
Comment
Question by:tqsneed
1 Comment
 
LVL 15

Accepted Solution

by:
plimpias earned 500 total points
ID: 24829839

1) Is it possible at all to configure a SQL Server instance across images?

of course, you may want to make sure you have network connection, make sure the firewall in the operating system isn't open.

2) If yes, what is the trick to make it work?

no trick, as long as you have the nic card bound to the virtual server and you can access resources on the network and internet. Treat it just like another machine if it were on a physical box. It appears this is an issue with the SQL config and not with hyper-v
Any suggestions would be appreciated.

Thank you!
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
This tutorial will walk an individual through the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space. Verify that the path to the shared storage is valid and that data can be written to that location:…
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…

839 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