SQL Prompt Error with TextMgrP.dll Registration

adambean

"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 SSMS 2016 with VS 2015. Just installed the RedGate tools today and this shows up when launching SSMS.

Found this: viewtopic.php?t=16536 - but that dll doesn't exist in C:\Program Files\Common Files\microsoft shared\MSEnv. The only file in that directory is VSFileHandler_64.dll.

Thanks!

Dan B

Hi adambean,

Another workaround we have used successfully in the past is below:

Can you kindly try manually re-registering the TextMgrP.dll on your machine which should hopefully resolve the error? Please:

Close SSMS and/or Visual Studio
Open a Command Prompt, running it as administrator
Run the following command regsvr32 "%CommonProgramFiles(x86)%\Microsoft Shared\MSEnv\TextMgrP.dll"
Open SSMS to test
I hope that will help but please let me know if any issues persist!

Harry Frankish

Hi adambean

That's strange. The TextMgrP.dll should be installed with SSMS 2016 and VS 2015. If repairing SSMS and VS doesn't work, try installing SQL Server Data Tools for VS 2015: https://msdn.microsoft.com/en-us/mt186501.aspx - this is how the dll gets installed for VS 2017. Hopefully that'll resolve the issue.

Cheers
Harry

baja

I stumbled across this identical issue when I've moved my license to a new laptop. Luckily manually registering TextMgrP.dll seems to have worked. Thanks

vsu

I found out that the problem appeared after updating SSMS to version 19.0.2 in the folder "c:\Program Files (x86)\Common Files\Microsoft Shared\MSEnv" the TextMgrP.dll library is not present, registering from another folder did not help. Fixing the installation didn't help either. Installing the previous version of SSMS (19.0.1) helped.

gflores

also encountered the same issue in ssms 19.0.2 on a fresh windows install.
note: after i installed visual studio and SSIS extension, it worked. this shouldn't be a requirement though

Balkoth

I observe the same as @vsu did. After upgrading to Version 19.0.2 the TextMgrP.dll can no longer be found in the "c:\Program Files (x86)\Common Files\Microsoft Shared\MSEnv" folder. Unfortunately i can not go back to a previous version as in our company software is centrally managed. So the addon is unusable for me due to this error.

What now?

prozach99

Same issue here. Downgrading corrected the problem.

I found you can get the previous version of SSMS here: https://learn.microsoft.com/en-us/sql/ssms/release-notes-ssms?view=sql-server-ver16#1901

Gary_S

I just ran into this as well. I was able to just copy that TextMgrP.dll from my old pc which had a v18 install of SSMS and had that file.  Copy the file and manually register and it works.

Dinomite

Ran into this as well after fresh install on a new laptop with the newest version of SSMS as of 3/22/2023 and visual studio 2022.  I searched my computer and found the dll in C:\Program Files (x86)\Microsoft SQL Server Management Studio 19\Common7\IDE\Automation

Run command line as administrator  and run;

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

Good to go for me!

Balkoth

@Dinomite works, thanks!

prozach99

@Dinomite thank you!! 

This seems like an issue that MS needs to fix. They obviously installed the dll with SSMS, but apparently forgot to register it.

techredraider

Registering at this location worked for me for SSMS 19.0.2:

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

JorritJ

I came here to say that upgrading from SSMS 18 to 19.0.2 I got the described error message after uninstalling 18. Installing extra tools did not work. Downgrading to 19.0.1 did the trick! Thanks!

StuffAndThings

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

TeunvdBiggelaar

Dinomite said:

Ran into this as well after fresh install on a new laptop with the newest version of SSMS as of 3/22/2023 and visual studio 2022.  I searched my computer and found the dll in C:\Program Files (x86)\Microsoft SQL Server Management Studio 19\Common7\IDE\Automation

Run command line as administrator  and run;

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

Good to go for me!

Thank you, this did the trick indeed!

SQLkiwi

SSMS 19.0.2

Registering the dll worked for me too.

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

ray_22

Hey!!!  If your system showing SQL Prompt Error with TextMgrP.dll missing file. Then don't worry you just download these missing dll files and fix your problem.

swvincent

Thanks, ran into this with a new machine and brand new install of SSMS 19.0.2 and RedGate and registering the DLL fixed it.

Edit: to be clear I used the DLL that was already on my machine in C:\Program Files (x86)\Microsoft SQL Server Management Studio 19\Common7\IDE\Automation.

Balkoth

Please don't randomly download dll files from dubious sites and put them on corporate machines. 

SDPmrem71

swvincent said:

Thanks, ran into this with a new machine and brand new install of SSMS 19.0.2 and RedGate and registering the DLL fixed it.

Edit: to be clear I used the DLL that was already on my machine in C:\Program Files (x86)\Microsoft SQL Server Management Studio 19\Common7\IDE\Automation.

Thanks 🙏 it worked

Lord02

This works 100%

Instead of using this ( Wrong file !!!!!! ) 
regsvr32 "%CommonProgramFiles(x86)%\Microsoft Shared\MSEnv\TextMgrP.dll"

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

ATurner

Hi All
There is a bug where this can show under certain circumstances on the latest version. The team are looking into a fix. 

Lexicon

Make sure to use elevated privileges when registering, otherwise you may get errors telling you with cannot register. @Lord02's solution definitely worked for me after I ran an Admin Terminal session.

pczarn2

I had just ran into the same issue with SQL Management Studio 20. This command fixed the issue for me ( I ran it As Administrator): regsvr32 "C:\Program Files (x86)\Microsoft SQL Server Management Studio 20\Common7\IDE\Automation\TextMgrP.dll"

For context, I had SQL Management Studio version 19 installed, then installed version 20. I then uninstalled 19 (I didn't notice that SQL Prompt was not working at that time in version 20). This was couple days ago. Then this morning, I found new version of SQL Prompt on red gate's site that said it supported version 20 (version 10.14.11.7894)  and installed it. Then got the TextMgrP.dll registration error. After running above command, the issue is fixed. 

BTW, the error window says to do a repair from the Windows Control Panel. Version 20 no longer has the Repair option, so that message was not helpful. 

ChrisBets

I also had the issue with SSMS 20. @pczarn2 solution worked fine for me.