Author: Ekrem ÃnsoyEkrem Ãnsoy Date: Aug 8, 2008 10:53
As SQL Server 2005 Express Edition is installed as a Named Instance by
default (unless you change it during SQL Server Setup), it must be using a
Dynamic Port for TCP protokol now.
In some cases I witnessed people experienced conneting remotely and they
were using Dynamic Ports. When they change it to a Static Port, they
successfully connected.
I've an article about remote connection settings, however it's in Turkish.
You can configure your port settings through SQL Server Configuration
Manager. Simply, to use a Static Port for your SQL Server Instance:
- Open up SQL Server Configuration Manager
- From the left side...
|