SQL Prompt Error with TextMgrP.dll Registration

Provides intelligent code completion for SQL Server editors.

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Paul Stephenson, Michelle Taylor, Mike Upton, justin.caldicott, Aaron Law

SQL Prompt Error with TextMgrP.dll Registration

Postby gvar369 » Fri Feb 22, 2013 9:10 pm

Been getting this error when i start SSMS 2008 R2 or VS 2012.
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.

Please advise,

Thanks,
Vijay
gvar369
 
Posts: 11
Joined: Wed Feb 23, 2011 5:26 pm

Postby Anu Deshpande » Mon Feb 25, 2013 10:16 am

Many thanks for your post gvar369 and apologies for inconvenience caused.

For some unknown reason, SQL Server Management Studio installations have been unravelling and deleting the interface that Prompt need to get access to the query window.

Running this from a Command Prompt as administrator should fix it:

Code: Select all
regsvr32 "%commonprogramfiles%\\microsoft shared\\msenv\\textmgrp.dll"

Kindly let us know if this fixed the problem.
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge

Postby gvar369 » Mon Feb 25, 2013 11:07 pm

Thanks Anuradha. Your solution worked. I had to make a small tweek to the command, to be able to execute on a 64-bit machine.
Instead of %commonprogramfiles% i had to specify the exact file location which was located in "program files x86" directory.


--
Vijay
gvar369
 
Posts: 11
Joined: Wed Feb 23, 2011 5:26 pm

Postby Anu Deshpande » Wed Feb 27, 2013 11:12 am

Thanks for the confirmation and I am glad that the solution worked.

I will make a note regarding the x86 folder.

Is there anything else I can help you with?
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge

Postby CTH » Tue Feb 11, 2014 10:18 pm

Worked for me as well but had to change to x86 like most of the users here.
CTH
 
Posts: 1
Joined: Tue Feb 11, 2014 10:01 pm

Re: SQL Prompt Error with TextMgrP.dll Registration

Postby tvanharp » Tue Sep 23, 2014 6:03 pm

Having the same issue, it appears that this was caused by installation of Team Foundation Services 2008.
DLL location was also not correct like others mentioned the following is the command I used.

Code: Select all
regsvr32 "C:\Program Files (x86)\Common Files\microsoft shared\MSEnv\textmgrp.dll"


Note: When launching cmd window use shift+RightClick and choose run as admiinistrator

The error I got on the first try was:
    <DLL file> was loaded but the call to DllRegisterServer failed with error code 0x80070005
tvanharp
 
Posts: 1
Joined: Tue Sep 23, 2014 5:53 pm


Return to SQL Prompt 5

Who is online

Users browsing this forum: No registered users and 1 guest