SQL Search disappeared from my SSMS

hpanchal

Hello team, 

SQL Search disappeared from my SSMS . I am using SSMS 17.9.1
I have uninstalled SQL search and Re-installed . without any success.
Could you please help me with this ? 

Do let me know , should i need to provide any more information. 

Given system details below: 

Microsoft SQL Server Management Studio 14.0.17289.0

Microsoft Analysis Services Client Tools 14.0.1016.283

Microsoft Data Access Components (MDAC) 6.1.7601.17514

Microsoft MSXML 3.0 6.0 

Microsoft Internet Explorer 9.11.9600.19356

Microsoft .NET Framework 4.0.30319.42000

Operating System 6.1.7601

Victoria W

With SSMS 2016 and 17, the SQL Search icon sometimes gets hidden and you need to expand the toolbar menu as below. Can you do a quick check to see if that might be the case?



If not, can you kindly check the extension folder C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\Extensions\SQLSearch and send across a screenshot of what's in there?

Can I also just check- when you launch SSMS 17.6, does any log file get generated in %localappdata%\Red Gate\Logs\SQLSearch 3?

Victoria W

Hi @hpanchal

Please can you try this:

1. Open Programs and Features

2. Right-click SSMS Integration Pack Framework 1 and select Repair

hpanchal

Hello Victoria , 

 Thanks a lot for this. That fixing didn't work.   I have Un-installed both of them and re-installed . But still the same issue.

Attached here list of installed programmes on my PC. 

Could you please suggest what need to be done ?

SQL Compare 10 44.21 MB 10.4.8.87 32-bit 25/01/2019 Red Gate Software Ltd http://www.red-gate.com/support/index.htm Compares and synchronizes SQL database schemas 
SQL Compare 13 90.73 MB 13.7.13.10771 32-bit 20/06/2019 Red Gate Software Ltd. http://www.red-gate.com/support/index.htm Compares and deploys SQL database schemas 
SQL Data Compare 10 40.42 MB 10.4.8.62 32-bit 25/01/2019 Red Gate Software Ltd http://www.red-gate.com/support/index.htm Compares and synchronizes SQL database contents 
SQL Data Compare 13 73.97 MB 13.6.11.8947 32-bit 04/02/2019 Red Gate Software Ltd. http://www.red-gate.com/support/index.htm Compares and deploys SQL database contents 
SQL Data Generator 3 38.26 MB 3.0.1.560 32-bit 25/01/2019 Red Gate Software Ltd http://www.red-gate.com/support/index.htm The simplest way to populate your database with test data 
SQL Data Generator 4 54.30 MB 4.1.0.1596 32-bit 04/02/2019 Red Gate Software Ltd. http://www.red-gate.com/support/index.htm Test data generator for SQL Server databases 
SQL Dependency Tracker 2 26.98 MB 2.7.4.1 32-bit 25/01/2019 Red Gate Software Ltd http://www.red-gate.com/support/index.htm Visualizes SQL Server object dependencies 
SQL Dependency Tracker 3 41.43 MB 3.1.7.1353 32-bit 20/06/2019 Red Gate Software Ltd. http://www.red-gate.com/support/index.htm Visualizes SQL Server object dependencies 
SQL Developer Bundle 599.75 MB 1.00 64-bit 25/01/2019 Red Gate   
SQL Doc 3 90.28 MB 3.0.1.908 32-bit 25/01/2019 Red Gate Software Ltd http://www.red-gate.com/support/index.htm Documents SQL Server 2005, 2008, and 2012 databases. 
SQL Doc 4 119.44 MB 4.1.0.1391 32-bit 04/02/2019 Red Gate Software Ltd. http://www.red-gate.com/support/index.htm Document SQL Server databases 
SQL Multi Script 1 10.78 MB 1.1.0.34 32-bit 25/01/2019 Red Gate Software Ltd http://www.red-gate.com/support/index.htm Single-click script execution on multiple SQL Servers 
SQL Multi Script 1 68.25 MB 1.4.14.1287 32-bit 13/06/2019 Red Gate Software Ltd. http://www.red-gate.com/support/index.htm Single-click script execution on multiple SQL Servers 
SQL Packager 7 28.13 MB 7.0.0.1484 32-bit 25/01/2019 Red Gate Software Ltd http://www.red-gate.com/support/index.htm Packages a database or a database update 
SQL Prompt 9 42.99 MB 9.5.7.10212 32-bit 20/06/2019 Red Gate Software Ltd http://www.red-gate.com/support/index.htm Write, edit, and explore SQL effortlessly 
SQL Search 3 827.79 KB 3.2.7.2379 32-bit 13/06/2019 Red Gate Software Ltd. http://www.red-gate.com/support/index.htm Search for SQL Server databases 
SQL Server Data Mining Add-Ins for Office 7.44 MB 11.0.2100.60 32-bit 21/05/2015 Microsoft Corporation  http://www.microsoft.com/sqlserver/2008/en/us/data-mining-addins.aspx  
SQL Source Control 7 77.59 MB 7.0.24.9343 32-bit 13/06/2019 Red Gate Software Ltd. http://www.red-gate.com/support/index.htm Providing source control for SQL Server database developers! 
SQL Test 3 9.79 MB 3.1.1.524 32-bit 04/02/2019 Red Gate Software Ltd. http://www.red-gate.com/support/index.htm Simple unit testing for SQL Server 
SSMS Integration Pack 2 3.89 MB 2.1.0.738 32-bit 20/06/2019 Red Gate Software Ltd. http://www.red-gate.com/support/index.htm Use SQL Compare and SQL Data Compare from SSMS 
SSMS Integration Pack Framework 1 3.15 MB 1.0.1.184 32-bit 25/01/2019 Red Gate Software Ltd http://www.red-gate.com/support/index.htm SSMS Add-in manager 

Victoria W

Hi @hpanchal

Are you on the latest version of SQL Search?  Here's the installer if not:
ftp://support.red-gate.com/patches/SQLSearch/31May2019/SQLSearch.exe

hpanchal

I had had installed Latest from SQLDeveloper bundle , but I have re-installed from the given link. But no change ..  It is still not appearing for SSMS 2017.  Surprisingly it is appearing for 2012. Not sure what's wrong.

Victoria W

With SSMS 2016 and 17, the SQL Search icon sometimes gets hidden and you need to expand the toolbar menu as below. Can you do a quick check to see if that might be the case?



If not, can you kindly check the extension folder C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\Extensions\SQLSearch and send across a screenshot of what's in there?

Can I also just check- when you launch SSMS 17.6, does any log file get generated in %localappdata%\Red Gate\Logs\SQLSearch 3?

hpanchal

Thanks a lot for this Victoria ,  I think reinstallation resolved the issue . Initially it was not hidden . Then I followed steps you suggested in another forum. That resolved Issue.

Thanks again.

hpanchal

Thanks a lot for this Victoria ,  I think reinstallation resolved the issue . Initially it was not hidden . Then I followed steps you suggested in another forum. That resolved Issue.

Thanks again.

MSchlichenmaier

Hi,

I also had the problem that my SQL Search Tool disappeared since I updated to SSMS 2019 (18.3.1).

However I tried to remove and reinstall the SQL Developer Bundle together with SQL Search.
I had SQL Search version 3.0 installed - but the uninstaller could not uninstall the tool.

When I tried to reinstall it wanted to update SQL Search 3.0 --> 3.3 but also failed.

See screenshot:

So how can I successfully install the SQL Search tool?

Maybe the error message is indeed right and you did not "activate" it for SSMS 2019, yet?

Victoria W

Hi @MSchlichenmaier

I'm going to raise a support ticket for you so that we can do some troubleshooting.