Red Gate forums :: View topic - Cannot use SQL Search 2 at all
Return to www.red-gate.com RSS Feed Available

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

Cannot use SQL Search 2 at all

Search in SQL Search 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
perrydrew



Joined: 02 May 2014
Posts: 1
Location: Canada

PostPosted: Fri May 02, 2014 9:52 pm    Post subject: Cannot use SQL Search 2 at all Reply with quote

I get this error every time I try to run SQL Search 2 on my SSMS of 2008R2.
I rebooted and uninstalled and reinstalled and no change. The previous version of SQL Search ran with no problems. I am running Windows 7.

Perry

Could not load file or assembly 'file:///C:\Program Files (x86)\Red Gate\Deployment Manager SSMS add-in 1\System.Data.SQLite.dll' or one of its dependencies. This assembly is built by a runtime newer than the currently loaded runtime and cannot be loaded.
Back to top
View user's profile Send private message AIM Address
David Pond
Site Admin


Joined: 06 Mar 2012
Posts: 24
Location: Cambridge, UK

PostPosted: Wed May 07, 2014 9:30 am    Post subject: Reply with quote

Hi Perry,

The DM addin and Search uses the common SSMS addin framework. You can disable the DM addin by removing it's registry key from this location:

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Red Gate\SIPFramework\Plugins

I'll raise this with the DM team too, maybe they recognise this issue.

David
Back to top
View user's profile Send private message Send e-mail
patrickortuso



Joined: 07 May 2014
Posts: 4
Location: Chicago, IL USA

PostPosted: Wed May 07, 2014 3:48 pm    Post subject: Reply with quote

Hi David,

Can you be more specific about what to remove from the registry location you mentionned?
_________________
Patrick
Back to top
View user's profile Send private message
David Pond
Site Admin


Joined: 06 Mar 2012
Posts: 24
Location: Cambridge, UK

PostPosted: Wed May 07, 2014 4:38 pm    Post subject: Reply with quote

The Deployment Manager SSMS addin adds a key called "HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Red Gate\SIPFramework\Plugins\DeploymentManagerSqlServerDbPackage". Removing this key will stop the DM addin from loading into SSMS.

I was thinking about the root cause of this problem. Presumably this happens when you click SQL Search's toolbar button? If possible please could you email me a log file from an SSMS session where the problem occurs. The log files are here:

C:\Users\<your.username>\AppData\Local\Red Gate\Logs\Ssms

My email address is david.pond@red-gate.com.

David
Back to top
View user's profile Send private message Send e-mail
EnrightMcC



Joined: 09 Nov 2009
Posts: 4
Location: Atlanta Area

PostPosted: Tue May 13, 2014 10:37 pm    Post subject: What's the status of this Reply with quote

I experienced this today when I tried to upgrade to SQL Search 2. When I click on the button I receive the error listed in the OP.

What is the status of this?
Can you provide a link to reinstall a previous version?

FYI my log info is:
15:29:37.187|Info |RedGate.SIPFramework|1 |Red Gate SSMS Ecosystem host connecting to SSMS.
15:29:37.187|Info |RedGate.SIPFramework|1 |RedGate.SIPFramework version: 1.0.1.2025
Back to top
View user's profile Send private message
patrickortuso



Joined: 07 May 2014
Posts: 4
Location: Chicago, IL USA

PostPosted: Wed May 14, 2014 7:03 am    Post subject: Reply with quote

EnrightMcC,

If you follow David's workaround (remove from registry) the SQL SEARCH 2 will work. In regedit:
1 - I exported the portion of the registry under "HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Red Gate\SIPFramework\Plugins\"
2 - I deleted "HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Red Gate\SIPFramework\Plugins\DeploymentManagerSqlServerDbPackageI deleted"
Now, if you restart SSMS and click on the SEARCH button, It should work.
You can even reimport the registry setting and it still will continue working (or at least it did for me as I was trying to reproduce the problem).

I hope this helps.
_________________
Patrick
Back to top
View user's profile Send private message
YDC



Joined: 14 May 2014
Posts: 1

PostPosted: Wed May 14, 2014 10:09 am    Post subject: Reply with quote

I also used the workaround including recreating the DeploymentManagerSqlServerDbPackage key.

It worked!

Thanks
Back to top
View user's profile Send private message
EnrightMcC



Joined: 09 Nov 2009
Posts: 4
Location: Atlanta Area

PostPosted: Thu May 15, 2014 7:50 pm    Post subject: Thanks Reply with quote

Yep, that did it. Thanks to patrickortuso and David Pond. Deleting the DM key seems to have done the job.
Back to top
View user's profile Send private message
dom.smith



Joined: 03 Jun 2010
Posts: 94
Location: Cambridge, UK

PostPosted: Fri May 16, 2014 3:18 pm    Post subject: Reply with quote

Thanks all for the feedback and I'm glad David's suggestion of deleting the Deployment Manager Add-in seems to be working for you.

Our developers are still trying to reproduce this issue, but we haven't had any luck so far, I'm afraid.

To help us, it would be really helpful if anyone who has this issue could let us know the following, please:

- Which versions of SSMS you have installed
- Which version of SSMS you are using
- The OS version
- Any other plug-ins you have installed in SSMS

Thanks,
Dom.
_________________
Dominic Smith,
Project Manager,
Red Gate Software.
Back to top
View user's profile Send private message
EnrightMcC



Joined: 09 Nov 2009
Posts: 4
Location: Atlanta Area

PostPosted: Fri May 16, 2014 3:29 pm    Post subject: Reply with quote

Only one version installed. Here is the info from SSMS Help--> About
Microsoft SQL Server Management Studio 10.50.4000.0
Microsoft Analysis Services Client Tools 10.50.4000.0
Microsoft Data Access Components (MDAC) 6.1.7601.17514
Microsoft MSXML 3.0 4.0 6.0
Microsoft Internet Explorer 9.11.9600.17041
Microsoft .NET Framework 2.0.50727.5477
Operating System 6.1.7601

Windows 7 Professional

No other plugins installed.
Back to top
View user's profile Send private message
dom.smith



Joined: 03 Jun 2010
Posts: 94
Location: Cambridge, UK

PostPosted: Tue May 20, 2014 4:59 pm    Post subject: Reply with quote

Once again, thanks for all the responses on this issue. We've managed to reproduce it and we have released a new build of SQL Search with the fix.

If you are affected, you can download the new version from http://www.red-gate.com/products/sql-development/sql-search/v2

Thanks,
Dom.
_________________
Dominic Smith,
Project Manager,
Red Gate Software.
Back to top
View user's profile Send private message
lenaheadey88



Joined: 27 May 2014
Posts: 1

PostPosted: Tue May 27, 2014 5:00 am    Post subject: Re Reply with quote

Quote:
Yep, that did it. Thanks to patrickortuso and David Pond. Deleting the DM key seems to have done the job.


I did that once before... It seemed to work for me.
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