Red Gate forums :: View topic - SQL Prompt has been disabled due to an error TextMgrP.dll
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 has been disabled due to an error TextMgrP.dll

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



Joined: 08 Jul 2013
Posts: 3
Location: United States

PostPosted: Mon Jul 08, 2013 9:46 pm    Post subject: SQL Prompt has been disabled due to an error TextMgrP.dll Reply with quote

After installing a new local instance of SQL 2012 on my machine, I am receiving the following error using SQL Prompt 5 Trial edition. I am only a week into my trial period.

[i]"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."[/i]

I did attempt to re-register the TextMgrP.dll file as suggested in another post on this subject, but received the following error:

[i]"The module "TextMgrP.dll" was loaded but the call to DllRegisterServer failed with error code 0x80070005."[/i]

Removing and reinstalling the SQL Prompt 5 provided no help.

My work machine has several versions of SQL Server on it. When I originally installed the trial, I did not have a local instance of SQL installed on my machine, but I did have SQL Server 2012 Management Studio installed.

Any help would be appreciated.
Back to top
View user's profile Send private message AIM Address
kjkkpsi



Joined: 08 Jul 2013
Posts: 3
Location: United States

PostPosted: Tue Jul 09, 2013 1:30 pm    Post subject: Reply with quote

I went as far as to remove and reinstall all versions of SQL off of my machine this morning. Unfortunately though, I am still getting the same error trying to open SSMS 2012 with SQL Prompt 5 installed.
Back to top
View user's profile Send private message AIM Address
Manfred.Castro



Joined: 23 Apr 2012
Posts: 205

PostPosted: Tue Jul 09, 2013 10:29 pm    Post subject: Reply with quote

0x80070005 indicates permission issue.
Check the security on the file TextMgrP.dll (Right-click the file in Explorer, choose the Security tab and ensure the user has appropriate permissions).
Click the Start Button, then in the "Start Search" box type CMD but DO NOT press Enter yet.
In the list above, under "Programs" right-click on CMD that appears above and choose "Run as Administrator" and click "Continue".
In the black command line window, use the command “REGSVR32” to register the file again.


http://social.technet.microsoft.com/Forums/windows/en-US/71037d62-d842-44a3-86df-6ed74df6fc39/0x80070005-error-trying-to-register-dll
_________________
Manfred Castro
Product Support
Red Gate Software
Back to top
View user's profile Send private message
kjkkpsi



Joined: 08 Jul 2013
Posts: 3
Location: United States

PostPosted: Fri Jul 12, 2013 3:56 pm    Post subject: Reply with quote

Thanks Manfred.Castro,

I came to the same solution shortly after posting my last reply.
Back to top
View user's profile Send private message AIM Address
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