Microsoft SQL Compact server 3.5 error while installing STAAD.Pro CE


Applies To
Product(s):STAAD.Pro
Version(s):22.10.00.153 and higher
Environment: ALL
Area: STAAD.Pro Download/Installation/Security/Performance
Subarea: Installation
Original Author:Ranjana, Bentley Technical Support Group

Description:

While installing Staad Pro, error pops up " Failed to install Microsoft SQL Compact server 3.5 SP2 English (x64) with error code ,fatal error.

Solution:

There may be a possibility that you have limited permissions to install. To check, please download the STAAD installer with layout option (so that you have all the installable components separately) and try installing the following in the mentioned order. 

Procedure to download staad installer layout image given in the link . 

https://bentleysystems.service-now.com/community?id=kb_article_view&sysparm_article=KB0115011 

Try installing in the below mentioned order :

SSCERuntime_x86-ENU.msi

SSCERuntime_x64-ENU.msi

now run the setup file for STAAD.Pro and check if still the error appears.