Name: Anonymous 2012-11-09 20:37
I changed the scope for the firewall to include the Internet and in SQL Configuration Manager added the TCP port (1433) to both IP1 and IP All and set the Dynamic Port to blank.
changed the scope for the firewall to include the Internet and
In SQL Configuration Manager added the TCP port (1433) to both IP1 and IP All
And set the Dynamic Port to blank.
SQL Server Express (2005 & 2008) defaults to Dynamic Ports, whereas the Default Instance of other Editions listen on Static Port 1433 (by default).
Having a Zero in the Dynamic Port configuration will have been overriding the Static Port that you entered, and therefore causing your connection problems.
changed the scope for the firewall to include the Internet and
In SQL Configuration Manager added the TCP port (1433) to both IP1 and IP All
And set the Dynamic Port to blank.
SQL Server Express (2005 & 2008) defaults to Dynamic Ports, whereas the Default Instance of other Editions listen on Static Port 1433 (by default).
Having a Zero in the Dynamic Port configuration will have been overriding the Static Port that you entered, and therefore causing your connection problems.