Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Server 2008 R2 Hyper V Firewall

Posted on 2014-12-10
5
Medium Priority
?
232 Views
Last Modified: 2014-12-10
Dear All,

I have a Hyper V server running Intranet (SharePoint 2010) and I am trying to connect to the SQL (SQL 2008 R2) with Server management console and the firewall blocks the packets every time.

I have enabled a rule for the port 1434 and also created a All ports Rule but still it blocks the packet..

The Windows Filtering Platform has blocked a packet.

Application Information:
      Process ID:            0
      Application Name:      -

Network Information:
      Direction:            Inbound
      Source Address:            192.168.2.2
      Source Port:            50402
      Destination Address:      192.168.2.30
      Destination Port:            1434
      Protocol:            17

Filter Information:
      Filter Run-Time ID:      117179
      Layer Name:            Transport
      Layer Run-Time ID:      13
0
Comment
Question by:Smartsystemsltd
  • 2
  • 2
5 Comments
 
LVL 4

Expert Comment

by:Smighty
ID: 40491094
is your SQL Server running as a VM on the Machine?
is your Sharepoint Server installed on the Hyper-V Host or on another VM?
how are your network settings configured on the - I assume - VM that holds the SQL Server?
0
 

Author Comment

by:Smartsystemsltd
ID: 40491137
Hi,

Yes the SQL / SharePoint is on a instance on a  VM server and the same server has x4 Hyper v VM's and another VM instance has SQL and I can reach that just fine so I know its not the host VM server.

This install of windows is ignoring the All Ports rule that I have set and still block the packets to the SQL port 1434 ext
0
 
LVL 40

Expert Comment

by:Philip Elder
ID: 40491533
Is the _Host_ blocking the packets or the _Guest_ blocking the packets?
0
 

Author Comment

by:Smartsystemsltd
ID: 40491655
Guest blocking packets
0
 
LVL 40

Accepted Solution

by:
Philip Elder earned 2000 total points
ID: 40491707
Please follow this MSDN article for the ports to open to allow SQL to work: Configure Windows Firewall for SQL
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

It’s time for spooky stories and consuming way too much sugar, including the many treats we’ve whipped for you in the world of tech. Check it out!
Ransomware - Defeated! Client opened the wrong email and was attacked by Ransomware. I was able to use file recovery utilities to find shadow copies of the encrypted files and make a complete recovery.
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

916 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