Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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.

share|improve this question
add comment

3 Answers

up vote 0 down vote accepted

Xor,

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!!

share|improve this answer
    
Yeah, I shared a folder from host (local) machine and was able to see that from VM machine –  Romil N Dec 9 '12 at 14:53
    
You are all done, SQL Server connection should work! –  Arsalan Adam Khatri Dec 9 '12 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! –  Romil N Dec 15 '12 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 –  Arsalan Adam Khatri Dec 16 '12 at 6:41
    
1- is it necessary to connect to SQL Instance using SQL Server Authentication? I'm able to connect using Windows Authentication. –  Romil N Dec 16 '12 at 10:29
show 7 more comments

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/

share|improve this answer
    
I'm using VM-Ware. –  Romil N Dec 9 '12 at 11:32
add comment

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.

share|improve this answer
    
Thanks. With ref to my question, does that mean that my local PC should be under DOMAINNAME domain? –  Romil N Dec 9 '12 at 11:31
add comment

Your Answer

 
discard

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.