Thread Content
Aspen Plus gets stuck on the loading screen; from time to time an EDR error appears, with the message “the database C:\ProgramData\AspenTech\Aspen Exchanger Design and Rating V14.0\1\main_2014.mdf could not be loaded”. The solutions are as follows: 1. First, right-click on C:\ProgramData\AspenTech\Aspen Exchanger Design and Rating V14.0\1\, select “Properties”, and then switch to the “Security” tab. In the “Group or username” list, ensure that your current user or the Users group has “Full Control” permissions. If not, click “Edit” to add and authorize it. 2. Reinstall Aspen_V14_ENG\aspenonesuite\core\SQLLocalDB\x64\SqlLocalDB.MSI. 3. Open cmd with administrative privileges, stop and delete the existing instance: cmd sqllocaldb stop “MSSQLLocalDB” sqllocaldb delete “MSSQLLocalDB”. Create a new instance: cmd sqllocaldb create “MSSQLLocalDB” sqllocaldb start “MSSQLLocalDB”. Enter the following command to check the status of the instance: sqllocaldb info “MSSQLLocalDB”. The output will be as follows: Name: MSSQLLocalDB Version: 15.0.2000.5 Shared name: Owner: DESKTOP-XING\1 Auto-create: Yes State: Running Last start time: 2026/3/6 20:27:10 Instance pipe name: np:\\.\pipe\LOCALDB#B8D6D6CC\tsql\query. EDR should now be able to open successfully
Running into issues with EDR database loading is indeed frustrating; the troubleshooting steps summarized by the original poster are very comprehensive! I’d like to add two situations I’ve encountered: sometimes antivirus software mistakenly blocks the operation of SQL LocalDB. It is recommended to temporarily turn off such protection software before proceeding. If errors still occur after resetting the SQL instance, you can try renaming the entire AspenTech folder as a backup, allowing the software to rebuild its configurations automatically. These actions require system permissions, so it’s advisable to take screenshots at each step in case problems arise and need to be reversed. Additionally, the official knowledge base document KB001287 also provides detailed explanations regarding this error, which can be referred to~