Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I upgraded my Windows Server 2003 x64 to Windows Server 2008 R2 x64, and I noticed that I cannot connect to SQL Server (from within the LAN) which is running on the computer.

I ran the OpenSqlServerPort.bat script specified on http://support.microsoft.com/kb/968872/en-us, however the software Firewall is still somehow blocking access from within my LAN. I installed Microsoft's Port Query tool, and it verifies that the port is being FILTERED:

TCP port 1433 (ms-sql-s service): FILTERED
portqry.exe -n 192.168.1.15 -e 1433 -p TCP exits with return code 0x00000002.

I can also see in the EventLog it's being blocked:

The Windows Filtering Platform has blocked a packet.

Filter Information:
    Filter Run-Time ID: 74459
    Layer Name:     Transport
    Layer Run-Time ID:  12

I wish there were a way to lookup the filter rule which is causing the block. I did not find anything using the run-time ID on Google.

Anyone have any ideas?

share|improve this question

1 Answer 1

Use the firewall admin tools. If the firewall is active you will not ind a rule - normal mode is to block EVERYTHING that has NOT A RULE TO LET IT PASS. So, sorry, not rule to find.

You will have to put in your own rule to allow access to port 1433, TCP. Windows Advanced Firewall tool in Admin Tools.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.