Error: "Connection Test Failed" While Mapping SQL Database to Plant Project


Applies To 
Product(s):OpenPlant PID
Version(s):08.11.10.XXX (SS5) | 08.11.11.XX (SS6)
Environment: Windows 7/8.1/10 (64 bit)
Area: Installation-Configuration
Subarea: Database
Original Author:Harpreet Singh, Bentley Product Advantage Group

Problem Description

User gets errors while mapping SQL database with plant project through class editor. This error appears when user click the pull down button on Data Source field in below dialog.

Below error appears after clicking the drop down menu button.

As highlighted in above picture, it automatically tries to connect to SQLEXPRESS and fails, once this portion "\SQLEXPRESS" is removed from the datasource, different error appears as shown below.

Reason

Possible reason for this error is that if you are using Windows NT "Integrated Security" to login into SQL which is causing the issue.

Possible Solution

While mapping the database with Plant Project change Integrated Security to "True" as shown below.

Still a Problem

If there is still some problem while trying to perform any operation against OpenPlant PID, then please create a Service Request and contact Bentley Product Advantage group along with the list of all relevant details to get in depth analysis and for possible solution or workarounds. 

See Also

communities.bentley.com/.../18688.how-to-map-custom-properties-with-database

Comments or Corrections?

Bentley Product Advantage Group requests that you please confine any comments you have on this Wiki entry to this "Comments or Corrections?" section. THANK YOU!