TextMgrP.dll Registration Issue

Airn5475CAB

Hello,
I am trying to install SQL Prompt (v10)  into SQL Server Management Studio (v19.0.2).
I am on a new machine running Windows 11.
I repaired SSMS which did not help.
I tried registering the dll as I saw other posts mentioned.  I had to register it from a different location though:

regsvr32 "%CommonProgramFiles%\Microsoft Shared\MSEnv\TextMgrP.dll"

I have Visual Studio 2022 Installed with Data Tools Component installed.



What else do I need to try? Very frustrated!

Jon_Kirkwood

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"

arjunkrishna

same issue.

Jon_Kirkwood

@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

Airn5475CAB

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!

ballanda

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

Jon_Kirkwood

Great news! glad you're both up and running.

kshan

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

@Jon_Kirkwood any suggestions on this as its not working for me

Jon_Kirkwood

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.

kshan

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

Jon_Kirkwood

Brilliant news! 
Glad you got up and running