MsSQL 2005 Express connection problem

After installing an application, it could not access the local MsSQL 2005 Express Database. There was a message: Error : 40 – could not open a connection to SQL server.

After investigating that the tcp/ip protocol was enabled (;EN-US;914277) it appeared that the port 1433 needed to set up.

You can check the port by doing the following:

  1. Open SQL server 2005 Configuration Manager
  2. Select the Protocols for SQLexpress (beneath SQL Server 2005 Network Configuration)
  3. Select the properties of the tcp/ip protocol
  4. Tab IP Addresses
  5. Enter TCP port 1433

Leave a Reply

Your email address will not be published. Required fields are marked *