Revit Issue: “SQLLocalDB instance is malfunctioning.”

Issue:
Revit hangs when opening the project file. The journal file includes the following lines:

DBG_WARN: SQLLocalDB instance is malfunctioning.

  'Expect crashes when using steel functionalities in Revit.

  ' Please stop the current Revit session !

Causes:
The SQL database is corrupted or not functioning properly.

Solution:
Perform a clean reinstallation of SQL Server 2014 LocalDB Express. Follow these steps:

1. Open Control Panel:

1. • Navigate to the Control Panel on your computer.
2. Uninstall SQL Server 2014 LocalDB Express:
   • Go to "Programs and Features" in the Control Panel.
   • Find and uninstall "SQL Server 2014 LocalDB Express".
3. Clear the %temp% folder:
   • Open File Explorer.
   • Type %temp% in the address bar and press Enter.
   • Delete all files in the %temp% folder and skip deletion when there is pop up.
4. Download SQL Server 2014 Service Pack 3 (SP3) Express:
   • Download Microsoft® SQL Server® 2014 Service Pack 3 (SP3) Express from Official Microsoft Download Center
5. Select and download the "ENU\x64\SqlLocalDB.msi":
   • On the download page, select the "ENU\x64\SqlLocalDB.msi" file.
   • Click on the download button to save it to your computer.
6. Run the downloaded SQL LocalDB:
   • Navigate to the location where you downloaded the "SqlLocalDB.msi" file.
   • Double-click on the file to start the installation process.
   • Follow the prompts to complete the installation.

About the Author

Sr Technical Support Specialist<br><br> Skilled in AutoCAD, Mixed-use, Renovation, Revit, and Sustainable Design. Strong arts and design professional with a BA in Urban design focused in Architecture from University of Washington.

Follow on Linkedin More Content by Gregory Lee