Allowing Remote Connections to SQL Server 2005 through Windows Firewall

Hi all,

I am trying to allow sql remote connections to SQL Express 2005.

Now if I turn off the windows firewall I can connect successfully, However when I turn on the public profile settings it stops any connection being made.

I've added UDP port 1434 and TCP port 1433 to be allowed as both incomgin and outgoing ruls on the fire wall.

However when I try to connect through VS im getting the 40 error, saying the server doesnt exist?

Any ideas?
Who is Participating?
Vitor MontalvãoConnect With a Mentor MSSQL Senior EngineerCommented:
Do you have more SQL Server instances in that server?
And are you sure that instance is listening on 1433?
VB ITSSpecialist ConsultantCommented:
Have you tried all the steps in this article?

Take note of the text in bold blue text as they collapse to reveal instructions when clicked.
flynnyAuthor Commented:
Thanks for the replies guys,


Yes there is an instance of SQL Server 2008 running on the server as well. How do I identify theport thats being used on the instance?

(As far as I was aware 1434 UDP redirected to the correct instance? am I wrong?)
The Lifecycle Approach to Managing Security Policy

Managing application connectivity and security policies can be achieved more effectively when following a framework that automates repeatable processes and ensures that the right activities are performed in the right order.

Vitor MontalvãoMSSQL Senior EngineerCommented:
The 1433 and 1434 are used by default for the first installed instance but you can confirm it in SQL Server Configuration Manager by checking in the TCP/IP properties of the instance.
flynnyAuthor Commented:
Many thanks Vitor, there insrance was running on a different port.

helped me identify and solve.

Thanks for pointing me in the right direction.
Vitor MontalvãoMSSQL Senior EngineerCommented:
Just a warning. If the server is behind a firewall you won't want to set a dynamic port for that instance because after each reboot it may use a different port so it's better you chose a static port.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.