Its best to use SQL configuration manager to set the ports explicity and then open these in the firewall.
Make sure that UDP 1434 is open for the browser service.
I think i can tell you exactly what the issue is,
I spent over 48 hours trying to sort this. didnt find anything on the net. also happen to be with 1and1
look at these settings:
IP security policies.....
which opens box...............Packet Filter Properties
near the bottom of the list there is a box ticked called :
'Close MSDE (TCP/UDP)' (I am asuming that MSDE = Microsoft SQL Database Engine?)
Select it
Press Edit...
which opens box............... Edit Rule Properties
Select (again) >> 'Close MSDE (TCP/UDP)'
Press Edit...
which opens box................IP filter List
then you will see a list of ports tcp 1433, udp 1434
{Thats our list of ports all down as a blocking rule.....}
I think what needs to be done from here is
either....
close that screen ..IP filter List
on the screen Edit Rule Properties
there is a tab Filter action, could just change that from Block to permit?
(maybe changing it to permit, will allow us to tick the "Block All" option again - which sounds safer, but the support guys said there is a know bug, so might not work)
or
on the Packet Filter Properties
just untick the the rule 'Close MSDE (TCP/UDP)'
you might have to untick the rule 'Block ALL' to get it running
its probably to late for this to help you, but hopefully will help someone else with the same issue.
Best Answer
The principal steps to allow access are:
Configure the Database Engine to use a specific
TCP/IP
port. The default instance of the Database Engine uses port 1433, but that can be changed. The port used by the Database Engine is listed in theSQL Server
error log. Instances ofSQL Server Express
,SQL Server Compact
, and named instances of the Database Engine use dynamic ports. To configure these instances to use a specific port, see Configure a Server to Listen on a SpecificTCP Port
(SQL Server Configuration Manager).Configure the firewall to allow access to that port for authorized users or computers.