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

I have setup SQL Server express R2 on WIndows Server 2008 R2 and i can connect locally with SQL Management studio.

Remotely with the firewall enabled i cannot connect.

If i disable the firewall then remotely i can connect.

THis is very strange.

My firewall setting is set to TCP 1433 (although i also added 1434 as well)... but it refuses to work.

In the SQL Express R2 i have TCP/IP Enabled and it listens on 1433

Any help really appreciated, i am little lost. I have searched the net and i believe i am doing everything correctly.

Thanks in advance

share|improve this question
    
Do you have the permissions to connect both sql server to and database? –  Guido van Brakel Jun 17 '11 at 21:23
    
well if i disable the firewall i can connect without an issue. I am using sa ... infact i am using the exact same settings... all i do is disable the firewall and it works ... enable the firewall and it won't let me through. –  Martin Jun 17 '11 at 21:43
    
This brings an assumption that there may be a rule that actually denies SQL port (could be named "Block MSDE", for example). I assume is it Windows Firewall not 3rd party? Maybe (just maybe) the rule that enabled SQL Server port is enabled only to certain Profile? –  LazyOne Jun 17 '11 at 22:11

2 Answers 2

Have you restarted the SQL service since you made the configuration changes to enable TCP/IP and set a static port? These changes will not take effect until the service is restarted.

You can verify what ports are being listened on by using netstat -a on the server.

share|improve this answer

Add these ports:

TCP 1433, 1434, 1444 UDP 1434

To be honest, I don't remember how I found these, or if I had to do anything to SQL (I don't think I did), but I took these from a SonicWALL I set up to do just what you are trying to accomplish, and it works.

Make sure you do it on both the hardware firewall and local software firewall.

share|improve this answer

Your Answer

 
discard

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.