SQL Server blocked by default Rule

SQL Server is Working fine in 1433 port in internal network.

if i change port to 6060, I Get Connect from external, but if I change to 1433 , In log i Can See the follow error

0xc004000d FWX_E_POLICY

the default rule block SQL server

January 19th, 2014 4:29pm

Hi,

Thank you for your post here.

do you publish the SQL server via TMG?

You should confirm that you configured DNS on internal NIC.

Also i think there must be something wroing with your publishing configuration.

PLease double check your configuration based on the article below:

http://technet.microsoft.com/en-us/library/cc441596.aspx

Best Regards

Quan Gu

Free Windows Admin Tool Kit Click here and download it now
January 20th, 2014 12:10am

I make this configurations like above, but Forefront don't respect the new rule and go to default rule, I think than are some conflct with system rule 17 - Allow remote SQL logging from Forefront TMG to selected servers, or default rule 36 - Allow intra-array communication due in forefront log I can see blocked by Microsoft SQL (TCP) , and the name of my rule is "Publica SQL Server with 1433 port"
January 20th, 2014 12:04pm

Hi,

As you mentioned, you can temporarily disable the relevant system rule one by one so that you can locate which rule is blocking your traffic.

Please also check if your web listener is listening port 1433 and there is no any other service using this port.

Best Regards

Quan Gu

Free Windows Admin Tool Kit Click here and download it now
January 20th, 2014 10:10pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics