SQL Prompt has been disabled due to an error TextMgrP.dll

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 has been disabled due to an error TextMgrP.dll

Postby kjkkpsi » Mon Jul 08, 2013 9:46 pm

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.
kjkkpsi
 
Posts: 3
Joined: Mon Jul 08, 2013 9:37 pm
Location: United States

Postby kjkkpsi » Tue Jul 09, 2013 1:30 pm

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.
kjkkpsi
 
Posts: 3
Joined: Mon Jul 08, 2013 9:37 pm
Location: United States

Postby Manfred.Castro » Tue Jul 09, 2013 10:29 pm

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/For ... gister-dll
Manfred Castro
Product Support
Red Gate Software
Manfred.Castro
 
Posts: 209
Joined: Mon Apr 23, 2012 2:49 pm

Postby kjkkpsi » Fri Jul 12, 2013 3:56 pm

Thanks Manfred.Castro,

I came to the same solution shortly after posting my last reply.
kjkkpsi
 
Posts: 3
Joined: Mon Jul 08, 2013 9:37 pm
Location: United States


Return to SQL Prompt 5

Who is online

Users browsing this forum: No registered users and 1 guest