Solved

Server 2008 R2 Hyper V Firewall

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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

February 24, 2017 — On February 23, Travis Ormandy, a vulnerability researcher at Google, reported on Twitter (https://twitter.com/taviso/status/834900838837411840) that massive stores of data have been leaked by CloudFlare, a company that provide…
The related questions "How do I recover the passwords for my Q-See DVR" and "How can I reset my Q-See DVR to eliminate a password" are seen several times a week.  Here we discuss the grim reality of the situation.
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

821 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