Error at Startup - Error 40 Could Not Open a Connection


 Product(s):Promis.e & Bentley Substation
 Version(s):through 08.11.12.137
 Environment:N/A
 Area:Database Platform Support
 Subarea:N/A

Error or Warning Message

The following error appears at startup on the [[Setup]] dialog.

Configuration not saved:A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Shared Memory Provider, error: 40 - Could not open a connection

Explanation

The software is unable to open a SQL connection due SQL server instance in a stopped state.

Steps to Resolve

  1. Open SQL Server Configuration Manager and select SQL Server Services.
  2. Right-click the "SQL Server (BENTLEYECAD)" item (typically) and select Start.

See Also

[[Troubleshooting Project Database Connection Problems]]

 Original Author:K_obsr