Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

What is the best way to configure a SQL Server on a host OS so that a guest OS can access it but it is not available outside the host OS?

I am using VirtualBox to host the guest OS.

share|improve this question

migrated from Feb 23 '11 at 1:01

This question came from our site for professional and enthusiast programmers.

First, figure out how to set up a private network, possibly with NAT, between the host computer and the VirtualBox VMs. I've never used VirtualBox, so I can't guess as to the steps for doing this.

Once you've got a little private virtual LAN between the two, you can configure SQL Server to only listen on the IP address associated with that network. Run SQL Server Configuration Manager, go into the Network Configuration node, drill down to TCP/IP, and open the properties for it. On the IP Addresses tab you can configure which addresses SQL Server will accept connections on. You might want to also disable the Named Pipes protocol so that it doesn't inadvertently allow access to the outside network.

share|improve this answer

Configure SQL Server to allow remote connections from your guest OS. Here's a tutorial with screenshots.

share|improve this answer
Wouldn't the linked configuration expose the MS SQL Server to anyone outside the host OS? I want to make sure only the host and any guest OS on the host can connect to the SQL server. – NeoModulus Feb 22 '11 at 17:14

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.