SQL Prompt Error with TextMgrP.dll Registration

Answers

• Harry Frankish Posts: 53 New member

  April 5, 2017 6:45AM

  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

  1 · Share on Twitter
• baja Posts: 1 New member

  September 18, 2019 1:09PM

  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

  0 · Share on Twitter
• vsu Posts: 1 New member

  March 16, 2023 10:51AM

  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.
  

  2 · Share on Twitter
• gflores Posts: 8 Bronze 1

  March 17, 2023 8:05PM edited March 17, 2023 8:41PM

  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

  0 · Share on Twitter
• Balkoth Posts: 8 New member

  March 22, 2023 7:08AM

  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?

  1 · Share on Twitter
• prozach99 Posts: 16 Bronze 1

  March 22, 2023 1:27PM

  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

  0 · Share on Twitter
• Gary_S Posts: 2 New member

  March 22, 2023 3:36PM

  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.
  
  

  0 · Share on Twitter
• Dinomite Posts: 1 Bronze 1

  March 22, 2023 7:28PM

  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!

  5 · Share on Twitter
• Balkoth Posts: 8 New member

  March 23, 2023 6:39AM

  @Dinomite works, thanks!

  0 · Share on Twitter
• prozach99 Posts: 16 Bronze 1

  March 23, 2023 11:48AM

  @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.

  0 · Share on Twitter
• techredraider Posts: 1 New member

  March 24, 2023 7:35PM

  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"
  

  
  

  1 · Share on Twitter
• JorritJ Posts: 1 New member

  March 28, 2023 7:02AM

  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!

  0 · Share on Twitter
• StuffAndThings Posts: 1 New member

  March 29, 2023 2:48AM

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

  1 · Share on Twitter
• TeunvdBiggelaar Posts: 12 Bronze 1

  April 6, 2023 6:32AM

  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!

  2 · Share on Twitter
• SQLkiwi Posts: 3 Bronze 2

  April 6, 2023 9:35AM

  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

  
  
  
  

  0 · Share on Twitter
• ray_22 Posts: 1 New member

  April 7, 2023 9:11AM

  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.
  

  -2 · Share on Twitter
• swvincent Posts: 1 New member

  April 11, 2023 7:13PM edited April 12, 2023 1:07PM

  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.

  1 · Share on Twitter
• Balkoth Posts: 8 New member

  April 12, 2023 6:17AM

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

  0 · Share on Twitter
• SDPmrem71 Posts: 6 Bronze 1

  April 15, 2023 7:03AM

  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
  

   :-] 

  0 · Share on Twitter
• Lord02 Posts: 2 Bronze 1

  April 19, 2023 4:25PM

  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"
  

  1 · Share on Twitter
• ATurner Redgate › Posts: 204 Silver 2

  May 1, 2023 3:09PM

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

  1 · Share on Twitter
• Lexicon Posts: 76 Bronze 3

  May 2, 2023 3:55AM

  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.

  Paul.

  0 · Share on Twitter
• pczarn2 Posts: 4 Bronze 1

  March 29, 2024 12:15PM edited March 29, 2024 12:19PM

  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. 

  2 · Share on Twitter
• ChrisBets Posts: 1 New member

  April 17, 2024 12:35PM

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

  0 · Share on Twitter