thefrozencoder

Programming and Technology blog

SQL Prompt has been disabled due to an error with the registration of a required DLL - TextMgrP.dll

When uninstalling SSMS v18 and installing the latest SSMS v19.0.2 with SQL Prompt installed you may get the following error when running SSMS for the first time.

"SQL Prompt has been disabled due to an error with the registration of a required DLL - TextMgrP.dll. To resolve the error, repair SQL Server Management Studio or Visual Studio from the Windows Control Panel."

Running a repair will not fix the issue. This is because the dll TextMgrP.dll is not located in the shared x86 location it used to be in prior to v19 as it's now a x64 assembly. To fix this error you now need to register the x86 version in a different location. The old location was in "C:\Program Files (x86)\Microsoft Shared\MSEnv"

Open a command line prompt as administrator and run the following to register

regsvr32 "C:\Program Files (x86)\Microsoft SQL Server Management Studio 19\Common7\IDE\Automation\TextMgrP.dll"

Restart SSMS and the error should be gone now.