I have configured Virtual machine to install Sharepoint 2010. The virtual machine is configured as;

a. OS: Windows Server 2008
b. Active Directory Configured (Domain Name as "DOMAINNAME" is configured)

I need to install SQL Server full installation but NOT on Virtual machine. I need it on my local PC. If I do so, would the VM be able to communicate through the SQL Server details? I need the SQL Server Details while configured the Farm Installation in Sharepoint Server 2010.

Let me know for any query.

3 Answers 3



Your VMWare Virtual machine should be using Internet Connection to your host machine, if you are having problem with that - have a look at :
Troubleshooting networking and internet connection issues in VMware Fusion

You can then install SQL Server Management Studio and Client Tools on Virtual Machine to check connection between your machine's SQL Server Instance!

As Sumol has suggested that 1433 default port should be allowed by FireWall of your host machine...

Its more than a try thing as to ask, in short there shouldn't be any problem!!

  • Yeah, I shared a folder from host (local) machine and was able to see that from VM machine
    – xorpower
    Dec 9, 2012 at 14:53
  • You are all done, SQL Server connection should work! Dec 9, 2012 at 15:06
  • I installed SQL on my local PC but the sql instance is not being recognized by Sharepoint when doing farm installation. Any ideas would be appreciated. Thanks!
    – xorpower
    Dec 15, 2012 at 20:43
  • 1- Make sure you are able to connect SQL Instance from your local PC.. 2- Disable the Firewall for your local PC as well as VM... 3- Try pinging the IP of your local PC from VM Dec 16, 2012 at 6:41
  • 1- is it necessary to connect to SQL Instance using SQL Server Authentication? I'm able to connect using Windows Authentication.
    – xorpower
    Dec 16, 2012 at 10:29

If you install SQL on your local machine and SharePoint on your virtual machine it should work without a problem as long the can access the same network.

Make sure that at least the following is true:

  1. Both machines are in the same domain and you can login to the machines using the SharePoint administrator account
  2. On the SQL machine make sure the port 1433 is open (this could be different if you are not using the default port)

When going through the SharePoint installation you should be able to connect to the SQL.

  • Thanks. With ref to my question, does that mean that my local PC should be under DOMAINNAME domain?
    – xorpower
    Dec 9, 2012 at 11:31

It will of course depend on what Virtualization software you use (Hyper-V, VM-Ware, etc.) as each one is configure differently. Beyond that, assuming your target is to simply communicate between host-client, you could simply make a private network between host-client - most virtualization software allow that.

With Hyper-V have a look at various types here http://blogs.technet.com/b/jhoward/archive/2008/06/17/hyper-v-what-are-the-uses-for-different-types-of-virtual-networks.aspx and detailed steps here http://ramazancan.wordpress.com/2010/02/26/hyper-v-r2-networking%E2%80%93-how-to-configure-management-vm-networks/

  • I'm using VM-Ware.
    – xorpower
    Dec 9, 2012 at 11:32

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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