Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
  • Welcome
  • Products
  • Support
  • About
  • More
  • Cancel
OpenPlant | AutoPLANT
  • Product Communities
  • More
OpenPlant | AutoPLANT
OpenPlant | AutoPLANT Wiki To Resolve Failed to install Access Database Engine / SQL Server Express with error code 0xFFFFFFFF
    • Sign in
    • -OpenPlant | AutoPLANT Wiki
      • -OpenPlant
        • +CONNECT Services - OpenPlant
        • +Example Configuration - CONNECT Edition
        • -Installations - OpenPlant CONNECT Edition Applications
          • How to Create A Deployment Image for OpenPlant Modeler CONNECT Edition
          • How to Create a Deployment Image of OpenPlant PID CONNECT Edition
          • How to enable OpenPlant Specification Generator tools upon installing OpenPlant Project Administrator.
          • How to install OpenPlant Modeler CONNECT Edition
          • How to Resolve the Installation Issue for Access Database engine.
          • How to Troubleshoot the error "Failed to install OpenPlant Modeler CONNECT Edition with error code 0x80070643. Fatal error during installation" for OpenPlant Suits.
          • OpenPlant Isometric Manager CONNECT Edition- Silent Installation & Uninstalation Procedure.
          • OpenPlant Modeler CONNECT Edition- Silent Installation & Uninstallation Procedure.
          • OpenPlant PID CONNECT Edition- Silent Installation & Uninstallation Procedure.
          • OpenPlant Project Administrator CONNECT Edition- Silent Installation & Uninstallation Procedure.
          • To Resolve Failed to install Access Database Engine / SQL Server Express with error code 0xFFFFFFFF
        • +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
        • +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.
      • +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. 

    To Resolve Failed to install Access Database Engine / SQL Server Express with error code 0xFFFFFFFF

    Applies To 
    Product(s): OpenPlant CONNECT Edition Update
    Version(s):

    10.09.00.74

    Environment:  Windows 10 (64-bit)
    Area:  Installation
    Subarea:  -
    Original Author: Deepak Singh, Bentley Product advantage Group



    Troubleshooting for installation issue of OpenPlant suits like OpenPlant Modeler CONNECT, OpenPlant Project Administrator CONNECT and OpenPlant PID CONNECT.

    Background

    In this wiki article, we will explore the possible troubleshooting methods to resolve issues faced during installation of OpenPlant suits. In general installation issue has been observed on machines where Microsoft Office 32 bit is installed. The installation struck at installation of Access Database Engine/SQL Server Express and prompt an error code as 0xFFFFFFFF.

    Pre-requisites

    1. Deployment image of respective OpenPlant product.
      Click on provided link for creation of deployment image. >>>Click Here<<<

    2. Setup of Microsoft SQL Server Compact 3.5 Service Pack 2
      Click on provided link to download >>>Click Here<<<

    3. Microsoft Access Database Engine 2016 x64-bit
      Click on provided link to download >>>Click Here<<<

    Steps to Accomplish

    1. From workstation, navigate to control panel and search for installed components of Microsoft Access Database Engines. It might be that in your machine multiple databases with different versions are enlisting. Sample reference image as.

    2. Un-install all the Microsoft Access Database engines.
    3. From File Explorer, locate the download file of Microsoft Access Database Engine 2016 x64-bit.
    4. Click on the address bar of file location and type CMD as shown below.

    5. Enter the setup name then include a <space> <slash> and keyword as <quiet>. Refer as shown to image below.



    6. This will silently install Microsoft Access Database Engine x64-bit over installation of Microsoft Office 32 bit.
    7. From the deployment folder of respective product, in this case OpenPlant Modeler. Search for msi file and double click on the same to install the product.
    8. Once installation is done, please don’t load OpenPlant Modeler. We need to install few more components to make it work properly.
    9. Install Microsoft SQL Server Compact 3.5 Service Pack 2 both version 32-bit as well as 64-bit.
    10. From the deployment folder install 1.4.5 then SPCServerSetup08.11.11.21




    11. Run OpenPlant Modeler, it should load without any error message.

    See Also

    • OpenPlant Modeler
    • 0xFFFFFFFF
    • OpenPlant Modeler CONNECT edition
    • OpenPlant Modeler Installation
    • Access Database Engine Issue
    • SQL Server Express Issue
    • Share
    • History
    • More
    • Cancel
    • Deepak Singh Created by Deepak Singh
    • When: Mon, Jan 10 2022 3:34 AM
    • Shubham Sawant Last revision by Bentley Colleague Shubham Sawant
    • When: Thu, Mar 24 2022 4:38 AM
    • 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

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