Red Gate forums :: View topic - SQL Prompt Error with TextMgrP.dll Registration
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Prompt 5
SQL Prompt 5 forum

SQL Prompt Error with TextMgrP.dll Registration

Search in SQL Prompt 5 forum
Post new topic   Reply to topic
Jump to:  
Author Message
gvar369



Joined: 23 Feb 2011
Posts: 11

PostPosted: Fri Feb 22, 2013 9:10 pm    Post subject: SQL Prompt Error with TextMgrP.dll Registration Reply with quote

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
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 689
Location: Cambridge

PostPosted: Mon Feb 25, 2013 10:16 am    Post subject: Reply with quote

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:
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
Back to top
View user's profile Send private message Send e-mail
gvar369



Joined: 23 Feb 2011
Posts: 11

PostPosted: Mon Feb 25, 2013 11:07 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 689
Location: Cambridge

PostPosted: Wed Feb 27, 2013 11:12 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
CTH



Joined: 11 Feb 2014
Posts: 1

PostPosted: Tue Feb 11, 2014 10:18 pm    Post subject: Reply with quote

Worked for me as well but had to change to x86 like most of the users here.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group