Set Port and Firewall to enable remote connect to SQL Server 2005 or 2008 Express Database


After 2 articles Remote connect to SQL Server 2005 Express or SQL Server 2005 and Change SQL Server or SQL Server Express Authentication Mode, the SQL Server remote connection still have more stuff to talk about.

Yes, we need to set Port and Firewall stuff to let remote computer can access.

Doug Kennard have given a nice instruction in his site and the article name is "How to Enable Remote Connection to SQL Server 2008 Express Database".

We can follow his guide to finish all left things that we have to finish for the database remote connection.

Some day I will give my own experience if I have free time to record all my setting steps.