Red Gate forums :: View topic - Startup errors in SSMS
Return to www.red-gate.com RSS Feed Available

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

Startup errors in SSMS

Search in SQL Prompt 5 EAP forum
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.
Jump to:  
Author Message
broughtie



Joined: 07 Jun 2006
Posts: 25

PostPosted: Wed Aug 25, 2010 6:29 pm    Post subject: Startup errors in SSMS Reply with quote

I uninstalled SQL Prompt 4 as directed before installing SQL Prompt 5, but know when I start up SSMS, I get an error that SQL Refactor 1.5 can't be loaded and it doesn't work. I also still see SQL Prompt 4 in the menus, but its disabled.
Back to top
View user's profile Send private message
anildas



Joined: 25 Feb 2008
Posts: 7
Location: San Diego, California, USA

PostPosted: Wed Aug 25, 2010 6:32 pm    Post subject: Reply with quote

I also uninstalled SQL Prompt 4 before installing SQL Prompt 5. I also saw the error regarding SQL Refactor 1.5. I also see SQL Prompt 5 in the SSMS menu, disabled.
Back to top
View user's profile Send private message Send e-mail
LanceAndrewes



Joined: 25 Aug 2010
Posts: 2

PostPosted: Wed Aug 25, 2010 10:22 pm    Post subject: Reply with quote

And me too. SSMS 2008 SP1 on Windows XP SP3 x86. Uninstalled version 4 prior to installing 5.0.0.224. When I run SQL Management Studio I get:

+++++++++++
The Add-in 'SQL Prompt 5.0' failed to load or caused an exception. Would you like to remove this add-in? If you choose yes, you will need to reinstall the Add-in to use it again.

Error message: <Unknown error>
Error number: 80131509
+++++++++++
Back to top
View user's profile Send private message
LanceAndrewes



Joined: 25 Aug 2010
Posts: 2

PostPosted: Wed Aug 25, 2010 11:15 pm    Post subject: Reply with quote

Okay. I chose "Yes" on the error prompt and when SSMS opened the "SQL Prompt 4" menu was gone and "SQL Prompt 5" had appeared. On restarting SSMS I don't get the error message. SQL Prompt 5 is now working.

So, to install the beta - not only must you uninstall SQL Prompt 4 via Control Panel, but you must say "Yes" to the error prompt that appears when you run SSMS.
Back to top
View user's profile Send private message
weswinkler



Joined: 11 Nov 2008
Posts: 32

PostPosted: Thu Aug 26, 2010 1:22 am    Post subject: Similar experience Reply with quote

I'm using SSMS 2008 R2 on Windows Server 2003 R2.

I uninstalled SQL Prompt 4.x and installed SQL Prompt 5.x.

SSMS reported the same error as LanceAndrewes received:

The Add-in 'SQL Prompt 5.0' failed to load or caused an exception. Would you like to remove this add-in? If you choose yes, you will need to reinstall the Add-in to use it again.

Error message: <Unknown error>
Error number: 80131509

I also chose "Yes" and proceeded.

------------------------
SQL Prompt 5.0 apparently loaded successfully -- at least into Visual Studio Team System 2008 (Version 9.0.30729.4462 QFE). The SQL Prompt 5.0 menu item is active, but the SQL Prompt 4.0 menu item, though disabled, still appears. Shouldn't this have been removed when I uninstalled SQL Prompt 4.0?
-------------------------
SQL Prompt 5.0 initially did NOT appear at all in SSMS. My old SQL Prompt 4.0 menu item was active, but none of its available actions would complete.

But, after rebooting and repairing the SQL Prompt 5.0 installation, I was able to proceed.

I then also received the error message about SQL Refactor.

Microsoft SQL Server Management Studio
---------------------------
The Add-in 'SQL Refactor 1.5' failed to load or caused an exception.
Would you like to remove this Add-in?
If you choose yes, you will need to reinstall the Add-in to use it again.

Error Message: Invalid pointer

Error number: 80004003
-------------------------------

I answered "Yes" and proceeded. Both SQL Prompt 5.0 and SQL Refactor 1.5 are available and working now in SSMS.
Back to top
View user's profile Send private message
emoreau



Joined: 23 May 2006
Posts: 38

PostPosted: Thu Aug 26, 2010 12:37 pm    Post subject: Reply with quote

Same here with SQL Server 2005.

Uninstalled SQL Prompt 4 + install SQL Prompt 5 + start SSMS + click yes to exception message + SQL Prompt 4 still in the menus of SSMS + SQL Prompt 5 NOT in the menus of SSMS
Back to top
View user's profile Send private message
rtonerii



Joined: 16 Jun 2006
Posts: 10

PostPosted: Fri Aug 27, 2010 12:32 am    Post subject: Reply with quote

I am running SQL 2008 R2 Developer Edition. I uninstalle Prompt 4 before installing Prompt 5. I am running SLQ Refactor 1.6, since it is the onl one that runs with SQL 2008 R2. Anything else you want to know?
_________________
Rick Toner
MCP, MCSD
http://www.TonerTrail.com
Back to top
View user's profile Send private message
rtonerii



Joined: 16 Jun 2006
Posts: 10

PostPosted: Fri Aug 27, 2010 12:53 am    Post subject: Re: Reply with quote

rtonerii wrote:
I am running SQL 2008 R2 Developer Edition. I uninstalle Prompt 4 before installing Prompt 5. I am running SLQ Refactor 1.6, since it is the onl one that runs with SQL 2008 R2. Anything else you want to know?


Before anyone asks, it is 1.5. I was mistaken.
_________________
Rick Toner
MCP, MCSD
http://www.TonerTrail.com
Back to top
View user's profile Send private message
Paul Stephenson



Joined: 23 Jul 2010
Posts: 107
Location: Cambridge, UK

PostPosted: Fri Aug 27, 2010 4:30 pm    Post subject: Reply with quote

Thanks for the feedback everyone! We've realised that some configurations do not support side-by-side installations of SQL Prompt 5 and SQL Refactor.

To try out SQL Prompt 5, please uninstall SQL Refactor first. You may need to uninstall and re-install SQL Prompt 5 too.

Note that every feature in SQL Refactor will eventually become part of SQL Prompt 5 Pro. Smart Rename, Split Table and Format SQL are already included.

Paul Stephenson
SQL Prompt Project Manager
Red Gate Software
Back to top
View user's profile Send private message Send e-mail
broughtie



Joined: 07 Jun 2006
Posts: 25

PostPosted: Wed Sep 08, 2010 9:56 pm    Post subject: Reply with quote

Okay, so now my SQL Refactor is broken and I can't get it back. I uninstalled every Red-Gate product on my computer and then reinstalled the latest SQL Toolbelt, with various reboots involved, and I STILL get the "The addin 'SQL Refactor 1.3' failed to load or caused an exception...." error. My menus in SSMS correctly show just SQL Refactor and SQL Prompt 4. SQL Prompt works fine. Very frustrating for the EAP to break a different product to this level. Where do I turn for help?
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 661
Location: Cambridge

PostPosted: Thu Sep 09, 2010 1:36 pm    Post subject: Reply with quote

Apologies for that broughtie!

I have dropped you a message kindly check that and let me know if that helped.
_________________
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
Display posts from previous:   
This topic is locked: you cannot edit posts or make replies. 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