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'm running Microsoft SQL Express 2008 on a Windows 2012 Server box. Got everything work, and I even manage to connect with the firewall down. But I dont really want the firewall turned off at all times so what port do I need to open up?

I've allready have the two inbound rules with TCP port 1433 and 1434 but I still seem to be missing something?

share|improve this question

2 Answers 2

This Microsoft Support article for Windows 2008 might help you: http://support.microsoft.com/kb/968872/en-us

Update:

Just noticed that you asked for Windows Server 2012. I am not sure if this is still working.

share|improve this answer
    
In Visual studio, do i specify Server as "IP\InstanceName"? At home with the firewall down it connectable on "SERVER\SQLEXPRESS" –  Jason94 Sep 24 '12 at 8:24
    
@Jason94 Sorry, I cannot tell for Visual Studio –  Roman Sep 24 '12 at 15:43

The SQL Browser uses UDP port 1434, not TCP. If you're connecting using an instance ID, you need UDP 1434 open for the SQL browser service.

Alternatively, you can reinstall SQL Express and make sure that it's the default instance, then you'll only need port 1433 open.

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.