TextMgrP.dll Registration Issue
Airn5475CAB
Posts: 2 New member
in SQL Prompt
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:
What else do I need to try? Very frustrated!
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!
Tagged:
Best Answer
-
Jon_Kirkwood Posts: 437 Gold 1Hi @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 | Technical Support Engineer | Redgate Software
Answers
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
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!
SSMS: v19.0.2
SQL Prompt: 10.13.7.360
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.
Glad you got up and running