SQL Prompt Error with TextMgrP.dll Registration

gvar369gvar369 Posts: 20
edited September 23, 2014 1:03PM in SQL Prompt Previous Versions
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

Comments

  • 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:
    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: [email protected]
  • 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
  • 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: [email protected]
  • Worked for me as well but had to change to x86 like most of the users here.
  • 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.
    regsvr32 "C:Program Files (x86)Common Filesmicrosoft sharedMSEnv	extmgrp.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
Sign In or Register to comment.