Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenPlant | AutoPLANT
  • Product Communities
OpenPlant | AutoPLANT
OpenPlant | AutoPLANT Wiki Error: "Connection Test Failed" While Mapping SQL Database to Plant Project
    • Sign In
    • -OpenPlant | AutoPLANT Wiki
      • -OpenPlant
        • +CONNECT Services - OpenPlant
        • +Example Configuration - CONNECT Edition
        • +Installations - OpenPlant CONNECT Edition Applications
        • +OpenPlant Download Links & Videos
        • OpenPlant Product Compatibility
        • +OpenPlant Modeler CONNECT
        • +OpenPlant PID CONNECT
        • +OpenPlant Isometrics Manager CONNECT
        • +OpenPlant Orthographics Manager CONNECT
        • +OpenPlant Support Engineering CONNECT
        • +OpenPlant Project Administrator CONNECT
        • +OpenPlant CONNECT Edition-PlantSight Integration
        • +OpenPlant Modeler v8i
        • +OpenPlant Isometrics Manager v8i
        • +OpenPlant Project Administrator v8i
        • -OpenPlant PID v8i
          • +Application Solutions - OPPID
          • +Class Editor - OpenPlant PID
          • +Customization - OpenPlant PID
          • -Database - Plant Project
            • How to Create a new SQL Server Project and Synchronize OpenPlant PID Projects to it?
            • How do I turn on Number Auto Incrementation of Components on placement?
            • How to Associate an OpenPlant PID Drawing with Another Project
            • How to Change OPPID and Plant Project's Names
            • How to Configure Particular Project to Work in Offline Mode By Default
            • How to Create Custom Border and Map Custom Property with Database
            • How to Get Related Valve Tag in Instrument List in Data Manager
            • How to Map Custom Properties with Database
            • How to Map Input/Output Signal of Instrument in OpenPlant PID
            • How to Select Field Value from External Database PickList
            • How to Setup a Batch Routine to Sync all Drawings in my Project to the Database at one time
            • How To Show Modified Tag Format in Data Manager
            • Importing Data into the Plant Project Database from an Excel Spreadsheet
            • Mapping Plant Project Extended Data Fields to OpenPlant PowerPID
            • OPPID - How to use the Class Editor Mapping Extension for the Plant Project Database
            • OPPID- How to add custom properties to specific piece of equipment or sub class and link to a database
            • Plant Project Database - Class Mapping
            • Plant Project Database - Operations with Schema Mapping and Mapping Add-in panel
            • Plant Project Database - Oracle Install notes
            • Plant Project Database - Relationship Mapping
            • Plant Project Database Tag Format - Tag Codes
            • Setting OpenPlant PowerPID Project with Plant Database Project
            • To Import Modified Tags from Excel in Data Manager
            • Error: "Connection Test Failed" While Mapping SQL Database to Plant Project
            • Calculated EC Property Shows Failure Value in Data Manager
            • "{SERVICE_IS_RELATED_TO_EQUIPMENT(VG.0000003279)} belongs to the ECSchema {ECSchema: PlantProjectSchema.01.04} which is not supported in this connection" Error on Synchronizing from Database to Drawing
            • "Project ID 'XXXX' not found in AT_PROJ.DB3"
            • How to Fix Folder ID Error Upon Performing Follow Page Connector and Update in OpenPlant PID SS10
            • How to Fix Issue of Missing Tables upon Unpackage SQL Mode Project to Access Mode
            • How to Move a Project Database from One Directory to Another For OPPID
            • How to Work with Follow Page Connector and Update for a ProjectWise Managed Env in OpenPlant PID SS10
            • Troubleshooting Synchronization issues using Component Selection Tool
          • How to Cascade Associated Item's Value from Associated Class to Fitting Class in OpenPlant PID V8i
          • How to cascade Associated Items value from Pipeline to Reducer using Notifier in OpenPlant PID V8i
          • How to Change the Existing Cell Component Graphics in OpenPlant PID V8i
          • How to Fix Modified Tag Value Upon Second Sync in OpenPlant PID V8i
          • How to Hide the Actuator Prompt for Control Valve in OpenPlant PID V8i
          • How to include custom schema in OpenPlant PID under component manager
          • How to Point Custom WorkSpace Location in OpenPlant PID SS10
          • How to set the Fail Mode List for control valve Placement in OpenPlant PID V8i
          • +Properties - OpenPlant PID
          • +Release Notes - OpenPlant PID
          • +Training - OpenPlant PID
          • +White Papers/Guidelines - OPPID
        • +OpenPlant Orthographics Manager v8i
        • +OpenPlant Support Engineering v8i
        • +OpenPlant ModelServer v8i
        • +OpenPlant Reporting v8i
        • How to Connect with Bentley Technical Support Team using Microsoft Teams
        • How to Connect with Bentley Technical Support Team using Microsoft Teams via Browser
        • How to get list of installed applications/programs on Windows Machine using Command Prompt.
        • How to get list of Windows Updates installed on the machine using Command Prompt.
        • How to Package WorkSpace to be Shareable to Users for OpenPlant Projects
        • How to find iModel.dgn file of another domain in PlantSight
      • +Bentley AutoPLANT
      • +Bentley Navigator
      • +Bentley PlantSpace
      • +Plant Project Tools
      • +Bentley Raceway and Cable Management
      • i-model Composition Service for S3D
      • Working from home with OpenPlant
      • Working from home with Bentley Raceway and Cable Management
      • Working from home with AutoPLANT Modeler
      • Your Feedback is important to us!

     
     Questions about this article, topic, or product? Click here. 

    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

    http://communities.bentley.com/products/plant/design___engineering/w/plant_design_and_engineering__wiki/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!

    • OpenPlant PID
    • Mapping
    • error
    • Plant Project
    • 08.11.11.XXX pw
    • Class Editor
    • SQL
    • Connection Test Failed
    • Database
    • Share
    • History
    • More
    • Cancel
    • Harpreet Singh Created by Harpreet Singh
    • When: Thu, Dec 8 2016 10:04 AM
    • Kestutis Mitkus Last revision by Bentley Colleague Kestutis Mitkus
    • When: Wed, Mar 6 2019 3:27 PM
    • Revisions: 3
    • Comments: 0
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2023 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies