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 (http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277) it appeared that the port 1433 needed to set up.
You can check the port by doing the following:
- Open SQL server 2005 Configuration Manager
- Select the Protocols for SQLexpress (beneath SQL Server 2005 Network Configuration)
- Select the properties of the tcp/ip protocol
- Tab IP Addresses
- Enter TCP port 1433