TextMgrP.dll Registration Issue

• 
  same issue.

  arjunkrishna March 19, 2023 02:22

  - 0 +
• 
  Hi @Airn5475CAB & @arjunkrishna
  
  Thank you for reaching out on the Redgate forums regarding your SQL Prompt DLL issue.
  
  Can you please try closing SSMS and Visual Studio, then open up Command Prompt by choosing Run as Administrator and enter the following:
  

  regsvr32 "%CommonProgramFiles(x86)%\Microsoft Shared\MSEnv\TextMgrP.dll"

  
   This should re-register the dll.
   
  If that doesn't work please can you run the following from an elevated command prompt:
  regsvr32 "C:\Program Files (x86)\Microsoft SQL Server Management Studio 19\Common7\IDE\Automation\TextMgrP.dll"
  

  Jon_Kirkwood March 20, 2023 07:06

  - 0 +
• 
  @Airn5475CAB
  If the 2nd regsrv command doesn't work for you please advise.
  We have had reports of this issue occurring for users with dual installs of SSMS18 & 19 where the DLL is registered in different locations

  Jon_Kirkwood March 20, 2023 07:08

  - 0 +
• 
  Hi @Jon_Kirkwood
  That dll isn't in the directory you mentioned first, hence the reason I tried the location that I did.
  
  Your second regsrv link worked though and I was able to get SQL Prompt working! So I think we are all good to go!

  Airn5475CAB March 20, 2023 12:31

  - 0 +
• 
  I had this issue too.  The 2nd REGSVR link fixed it for me too. Thanks @Jon_Kirkwood!

  ballanda March 20, 2023 19:06

  - 0 +
• 
  Great news! glad you're both up and running.

  Jon_Kirkwood March 20, 2023 23:59

  - 0 +
• 
  I have only SSMS 19 installed. The file doesn't exist at the location of the first regsvr command and the second regsvr command didn't work for me. I get this error 
  
  SSMS: v19.0.2
  SQL Prompt: 10.13.7.360
  
  
  

  kshan May 04, 2023 18:18

  - 0 +
• 
  @Jon_Kirkwood any suggestions on this as its not working for me

  kshan May 09, 2023 18:45

  - 0 +
• 
  Hi @kshan
  
  The error 0x80070005 occurs when the system or user lacks the required files or permissions to change settings. 
  
  Can you ensure you are running the CMD prompt from an elevated/administrator command prompt.
  
  
  I found this site that has a few suggestions for getting DllRegisterServer working with that particular error code
  https://appuals.com/fix-dllregisterserver-failed-error-code-0x80070005/
  Hope this points you in the right direction to get up and running.
  
  

  Jon_Kirkwood May 10, 2023 01:27

  - 0 +
• 
  I missed the part about the elevated command prompt earlier. Running CMD as administrator and running the command worked. Thanks!!

  kshan May 10, 2023 02:08

  - 0 +
• 
  Brilliant news! 
  Glad you got up and running

  Jon_Kirkwood May 10, 2023 04:43

  - 0 +

Add comment

Please sign in to leave a comment.