SQL Search Won't Install for SSMS 18

racingcow · April 25, 2019 7:30PM

SSMS 18 is out of preview, but SQL Search won't install on it. When will it be available for v18?

Image: https://us.v-cdn.net/6029854/uploads/editor/1w/aqpzvl8zkl20.png

Image: https://us.v-cdn.net/6029854/uploads/editor/ue/gip9hl8mgn8u.png

Russell D · April 29, 2019 10:34AM

Whats the full build version? This works for me.

Image: https://us.v-cdn.net/6029854/uploads/editor/2c/jgeog2b8vbl6.png

Out of interest - do you have any other version of SSMS installed?

Dan B · April 29, 2019 1:12PM

Hi RacingCow,

The 3.3 build was released in error. Could you please attempt to install the previous version 3.2.6 which you can download from ftp://support.red-gate.com/patches/SQLSearch/09Apr2019/.

racingcow · April 29, 2019 2:31PM

@Russell D ...
The file version of SSMS.exe is "2019.150.18118.0", and the product version is "15.0.18118.0". Is there some other place I should look to get the "full build version"?

Image: https://us.v-cdn.net/6029854/uploads/editor/z5/k20pw2k5yd8h.png

@Dan B - I get a similar message when attempting to install SQL Search v3.2.6 from the FTP location that you provided...

Image: https://us.v-cdn.net/6029854/uploads/editor/lw/j4bxzm6j89w3.png

Dan B · April 30, 2019 9:56AM

Hi,

The details for the EXE you have vary slightly from mine. I downloaded from the below page and got some different information to you. Did you install SSMS 18 or did you upgrade from one of the beta versions?

https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017

Image: https://us.v-cdn.net/6029854/uploads/editor/ic/nbox3phao76w.png

ccparkhill · April 30, 2019 10:53AM

@Dan B your screenshot is from the installer, not the application, as can be seen from the file names and sizes.

racingcow · April 30, 2019 8:34PM

@Dan B

I uninstalled SSMS and reinstalled from the link you provided, then tried to reinstall SQL Search from the FTP link, but got the same behavior.

I think the issue is that another version (reported as 3.1.8.2156 in Control Panel) is "stuck" on my computer and preventing the installation of 3.2. The install for 3.2 doesn't detect that 3.3 is installed, and fails with the SSMS Required message from the screenshot above, but if you look at Control Panel, another version is still there and can't be uninstalled.

Uninstall of the old version results in the behavior shown in the screenshots below.

Is there a way for me to manually remove the other version?

Image: https://us.v-cdn.net/6029854/uploads/editor/wz/tl13s7sitqbe.png

Image: https://us.v-cdn.net/6029854/uploads/editor/fw/pss7uyyiyubb.png

Dan B · May 2, 2019 1:40PM

Hi,

Can you try running either the microsoft uninstall tool from https://support.microsoft.com/en-gb/help/17588/windows-fix-problems-that-block-programs-being-installed-or-removed or the revo uninstaller from https://www.revouninstaller.com/revo_uninstaller_free_download.html to see if this removes the rogue 3.1 version?

chuck · May 6, 2019 5:44AM

Dan B said:

Hi RacingCow,

The 3.3 build was released in error. Could you please attempt to install the previous version 3.2.6 which you can download from ftp://support.red-gate.com/patches/SQLSearch/09Apr2019/.

Tried to install 3.2.6 and now the sql search was shown in menu now.

and the sha-256 of the ssms.exe is b5dec677563868067912322a97acc968de0bc07ceb3ca68f6320f9ba1d2b9840

SQL Search Won't Install for SSMS 18

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk