Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
ProjectWise
  • Product Communities
ProjectWise
ProjectWise Design Integration Wiki Error Could not connect to the datasource
    • Sign In
    • ProjectWise Design Integration Wiki
    • ProjectWise Software Download
    • +ProjectWise Learning
    • +Projectwise Licensing
    • ProjectWise Programming and PowerShell
    • +Projectwise Documentation
    • -ProjectWise Explorer Client
      • +ProjectWise Client
      • +Featured Articles - Projectwise Explorer
      • +Audit Trail - ProjectWise Explorer Client
      • +Bentley IMS Login
      • +BS1192 Rules Engine - ProjectWise Explorer Client
      • +Check In Dialog - ProjectWise Explorer Client
      • +Document Code - ProjectWise Explorer Client
      • +Document Creation - ProjectWise Explorer Client
      • +Documentation & Help - ProjectWise Explorer Client
      • +Environments and Attributes - PWE
      • +Export / Import Tool - ProjectWise Explorer Client
      • +Folders / Subfolders - ProjectWise Explorer Client
      • +GUI - ProjectWise Explorer Client
      • -Installation - ProjectWise Explorer Client
        • ProjectWise Design Integration Connect Edition Client Unattended Install
        • ProjectWise Explorer Connect Edition Upd3 Unattended Install
        • Clean Uninstall for ProjectWise
        • Installing PW error 0x80070643
        • ConnectClientWrapperNative.VC100.dll is missing from your computer.
        • Connecting to multiple gateway servers, not all datasources appear
        • Document status incorrect on one PW client machine
        • Error 1722 uninstalling Integration server
        • Error 1935. An error occurred during the installation of assembly
        • Error 41 when deleting folder
        • Error 58510. Your ProjectWise user profile requires that you activate this ProjectWise product using the SELECT Server settings configured on this workstation.
        • Error Could not connect to the datasource
        • Fatal Error during Explorer installation
        • How to silently unattend the install of the application
        • Installing new CAD software and integrating with ProjectWise
        • Installing on to a Windows7 32-bit machi... (Solution 500000102136)
        • Internal Error 2738 installing PW Explorer
        • Manually install VPR for V8i
        • MSXML Error installing ProjectWise Explorer
        • Not enough space on drive C:\ to extract this package
        • Projectwise datasources do not display in Projectwise Explorer
        • ProjectWise Explorer CONNECT Edition Update 2 > Programs and Features > right-click > "Change" does not work as expected
        • Registry keys for ProjectWise Integration
        • Setting the default startup folder
        • Could not complete the operation due to error 80041002
        • Error 1316 A network error occurred while attempting to read from the file
        • Error 1607 Unable to Install Installshield Scripts Runtime
        • Error 1935. An error occurred druing the installation of assembly Microsoft.VC90.ATL
        • Where are ProjectWise connect edition installer log?
        • Internal error 2894 126 when trying to install Projectwise explorer
      • +Integration - General
      • +Integration - AutoCAD - ProjectWise Explorer Client
      • +Integration - Civil 3D - ProjectWise Explorer Client
      • +Integration - DGN Platform - ProjectWise Explorer Client
      • +Integration - MicroStation - ProjectWise Explorer Client
      • +Integration - Office - ProjectWise Explorer Client
      • +Integration - Revit - ProjectWise Explorer Client
      • +Logs Troubleshooting- ProjectWise Explorer Client
      • +Messaging Service - ProjectWise Explorer Client
      • +MISC - ProjectWise Explorer Client
      • +Open / Save / Copy / Move - ProjectWise Explorer Client
      • +Photo Preview - ProjectWise Explorer Client
      • +ProjectWise Managed Workspaces
      • +Project - ProjectWise Explorer Client
      • +Search - ProjectWise Explorer Client
      • +Security and Permissions - ProjectWise Explorer Client
      • +User Tools - ProjectWise Explorer Client
      • +Views - ProjectWise Explorer Client
      • +Workflows & States - ProjectWise Explorer Client
    • +ProjectWise Administrator
    • +ProjectWise Integration Server
    • +ProjectWise Caching Server
    • +ProjectWise Gateway Server
    • +ProjectWise User Synchronization Service
    • +ProjectWise Orchestration Framework
    • +ProjectWise Connected Services
    • +Working from Home with ProjectWise
    • +ProjectWise Glossary
    • ProjectWise Hosting - Manage Services

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

    Error Could not connect to the datasource

      Product(s): ProjectWise Server V8i
      Version(s): 08.11.07.443
      Environment:  Windows 2008 R2
      Area:  Installation
      Original Author: Bentley Technical Support Group

    Problem Description

    Error: Could not connect to the data source because of the following problem. See figure below.

    Solution

    User ran DMSCONVERT which went well, then tried to create the data source and ran into problems.
    The problem was creating storage areas on new 2008 server and was failing. The problem per the log pointed to adding the computer name/ip to the Trusted Servers and NameResolution sections; where the errors were cleaned up and no useful errors pointed to the real problem. The problem was related to a folder created off the root directory's user permissions. Both userA and the PwSvcUser were local administrators and the user expected that userA could create the storage off the root for the PwSvcUser to use. Due to Windows 2008 WRP design you need to explicitly add ownership to the folder for the PwSvcUser off the root if that user did not create that folder. Once a storage was created by the PwSvcUser (ownership could have been assigned as well) there were no issues adding it in the PW admin.

    Below is a simple explanation where the Microsoft admin links to this topic (1st link), a more detailed explanation (2nd link) and a 3rd link (from Microsoft) that explains the admin side of this.

    Windows treats files and directories off the Root partition of the Operating system drive in a special manner. If userA creates a folder (folderA) directly off the root directory and has permissions to do so explicitly or implied through the administrator group, they are the owner of that object. Being part of the administrator group only allows you to take control of that object, but not obtain full permissions inherently. When userB part of the admin group goes to write files under userB’s directory off the root userB needs permissions to do so explicitly at that root object level (folderA) so that new files and folders inherited off of folderA will obtain the appropriate access control permissions (ACLs). Windows is protecting files in Windows Vista/2008 with WRP (Windows Resource Protection) that replaces WFP (Windows File Protection) and adds better registry protection and only allowing the Trusted Installer user to directly modify files protected by WRP.

    We can use cacls to review the users and permissions on files and directories; which can also be viewed when using the Windows Effective Permissions tool on the file/folder properties > Security Tab > Advanced button, then selecting the Effective Permissions tab and providing a specific user to validate permissions of. Chances are, if you use the Effective permissions tool you on the ProejctWiseTempStorage folder you may have seen that the PW service account does not have ownership and permissions to create directories off this folder. The 1st and 2nd articles referenced below should be able to help explain the theories and reasoning behind the need and use of the trusted installer ownership of resources and the explicit need to change ownership of objects. The 3rd article tries to present a more direct approach to solving this type of problem encountered for deleting files and folders.

    Using Windows Installer and Windows Resource Protection
    http://msdn.microsoft.com/en-us/library/aa372868(v=vs.85).aspx
    Access Control - Understanding Windows File And Registry Permissions
    http://msdn.microsoft.com/en-us/magazine/cc982153.aspx
    Windows 7 – How to Delete Files Protected by TrustedInstaller
    http://helpdeskgeek.com/windows-7/windows-7-how-to-delete-files-protected-by-trustedinstaller/

    See Also

    Product TechNotes and FAQs

    External Links

    Bentley Technical Support KnowledgeBase

    Bentley LEARN Server

    Comments or Corrections?

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

    • SELECTservices
    • ProjectWise
    • Share
    • History
    • More
    • Cancel
    • Elisabeth Pry Created by Bentley Colleague Elisabeth Pry
    • When: Wed, Aug 7 2013 3:36 PM
    • Dana Guthrie Last revision by Bentley Colleague Dana Guthrie
    • When: Fri, Sep 30 2022 1:51 PM
    • Revisions: 4
    • 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