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?


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


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

|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.

|improve this answer|||||

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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