Solved

Server 2008 R2 Hyper V Firewall

Posted on 2014-12-10
5
205 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 38

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 38

Accepted Solution

by:
Philip Elder earned 500 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

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

If you're not part of the solution, you're part of the problem.   Tips on how to secure IoT devices, even the dumbest ones, so they can't be used as part of a DDoS botnet.  Use PRTG Network Monitor as one of the building blocks, to detect unusual…
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…

762 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now