Default TCP/IP Port of Microsoft SQL Server 2005 Express

After Install, the default settings for Microsoft SQL Server 2005 Express are different from those which are expected in previous versions.

• TCP/IP is not enabled for the Server
• The default TCP port is not 1433 (which is default previous versions)

So, if you would make JDBC connections from your applications, you should setup followings first.

• Enable TCP/IP for the serve :
  Load SQL Server Configuration Manager, in SQL Server 2005 Network Configuration/Protocols for SQLEXRPRESS dialog, make enable TCP/IP (SQLEXPRESS is instance name of SQL Server, so is dependent on your installation)
• Check the TCP port of your server :
  In above SQL Server 2005 Network Configuration/Protocols for SQLEXRPRESS dialog, double click TCP/IP item. At the loaded dialog, seek into IP Addresses tab, IP All section, and TCP Dynamic Ports and that is TCP port for JDBC connection.

Those may be same with SQL Server 2005.