Error on Install, not finding SSDT

Hi Max,

Thank you for your post. Can I ask you to try uninstalling SQL Prompt first, then modify VS and remove SSDT. Then re-add SSDT and try to reinstall SQL Prompt and let me know if you hit the same error.

Ben_P August 04, 2021 08:53

0

Hi Ben,
Thanks for your response.
I have tried you suggestion and on the re-install of SQL Prompt I get the same error message.

MadMax August 05, 2021 01:42

0

That is odd and not a behavior I have seen with 10.7 before. On the off chance it helps, there was a more recent release of SQL Prompt, 10.7.1:

https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.7.1.22264.exe

Can I ask you to uninstall SQL Prompt once more and then use the Microsoft troubleshooter to install the newer version of SQL Prompt above?

Link to the troubleshooter::

https://support.microsoft.com/en-us/topic/fix-problems-that-block-programs-from-being-installed-or-removed-cca7d1b6-65a9-3d98-426b-e9f927e1eb4d

Ben_P August 05, 2021 09:43

0

Sorry Ben,
Still no luck.
The Microsoft program didn't detect any issues. It doesn't detect the application unless it is already installed and the only option that it gave then was to uninstall the application.

MadMax August 06, 2021 04:49

0

It would be good to try installing via the msi file instead as the msi should bypass the SSDT check.

To do so please se below:

Launch the SQL Prompt installer by running it as administrator:
Once it loads, click on the Redgate icon at the top left of the installer and choose "Open temporary file folder"
Open the SQL Prompt folder and locate the SQLPrompt_10.7.1.22264_x86 msi file
Open a command prompt running as administrator and then run the following (making sure to change the temporary path and logfile location as needed): <br>msiexec.exe /i "c:\path\to\files\SQLPrompt_10.7.1.22264_x86.msi" ALLUSERS=1 ADDLOCAL=ALL /norestart /L*V "c:\logfile.log"
If it installs without error, please open VS to confirm if SQL Prompt loads

Here is a download to the latest SQL Prompt installer:

https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.7.1.22264.exe

Please also note that with VS SQL Prompt doesn't have a menu item like with SSMS. Instead when you open a SQL File in VS, the SQL Prompt tool will appear in the Extensions menu.

Ben_P August 06, 2021 13:44

0

I'm having this exact same issue, even on the newest 10.7.1 version. However, despite the error -- SQL Prompt appears to be working within Visual Studio 2019 Professional.

SocialExodus August 09, 2021 21:21

0

Still no luck.

There does appear to be a few issues with folder locations written to the log file. Some of the folders listed do not exist on my drive. e.g.,

\Common7, could this have anything to do with it? See excerpt below.

MSI (c) (F0:78) [12:26:40:270]: Note: 1: 2205 2: 3: MsiAssembly

MSI (c) (F0:78) [12:26:40:270]: Note: 1: 2205 2: 3: Class

MSI (c) (F0:78) [12:26:40:270]: Note: 1: 2205 2: 3: Extension

MSI (c) (F0:78) [12:26:40:270]: Note: 1: 2205 2: 3: TypeLib

Action ended 12:26:40: FileCost. Return value 1.

MSI (c) (F0:78) [12:26:40:270]: Doing action: CostFinalize

MSI (c) (F0:78) [12:26:40:270]: Note: 1: 2205 2: 3: ActionText

Action 12:26:40: CostFinalize. Computing space requirements

Action start 12:26:40: CostFinalize.

MSI (c) (F0:78) [12:26:40:270]: PROPERTY CHANGE: Adding OutOfDiskSpace property. Its value is '0'.

MSI (c) (F0:78) [12:26:40:270]: PROPERTY CHANGE: Adding OutOfNoRbDiskSpace property. Its value is '0'.

MSI (c) (F0:78) [12:26:40:270]: PROPERTY CHANGE: Adding PrimaryVolumeSpaceAvailable property. Its value is '0'.

MSI (c) (F0:78) [12:26:40:270]: PROPERTY CHANGE: Adding PrimaryVolumeSpaceRequired property. Its value is '0'.

MSI (c) (F0:78) [12:26:40:270]: PROPERTY CHANGE: Adding PrimaryVolumeSpaceRemaining property. Its value is '0'.

MSI (c) (F0:78) [12:26:40:270]: Note: 1: 2205 2: 3: Patch

MSI (c) (F0:78) [12:26:40:270]: Note: 1: 2205 2: 3: Condition

MSI (c) (F0:78) [12:26:40:270]: PROPERTY CHANGE: Adding TARGETDIR property. Its value is 'D:\'.

MSI (c) (F0:78) [12:26:40:270]: PROPERTY CHANGE: Adding RGTEMP property. Its value is 'D:\RGTEMP\'.

MSI (c) (F0:78) [12:26:40:270]: PROPERTY CHANGE: Adding RGFOLDER property. Its value is 'C:\Program Files (x86)\Common Files\Red Gate\'.

MSI (c) (F0:78) [12:26:40:270]: PROPERTY CHANGE: Adding RgClientFolder property. Its value is 'C:\Program Files (x86)\Common Files\Red Gate\Shared Client\'.

MSI (c) (F0:78) [12:26:40:270]: PROPERTY CHANGE: Adding CFRGFOLDER property. Its value is 'C:\Program Files (x86)\Common Files\Red Gate\'.

MSI (c) (F0:78) [12:26:40:270]: PROPERTY CHANGE: Adding SQLITEFOLDER property. Its value is 'C:\Program Files (x86)\Common Files\Red Gate\SQLite\'.

MSI (c) (F0:78) [12:26:40:270]: PROPERTY CHANGE: Adding SQLiteDir32 property. Its value is 'C:\Program Files (x86)\Common Files\Red Gate\SQLite\x86\'.

MSI (c) (F0:78) [12:26:40:270]: PROPERTY CHANGE: Adding SQLiteDir64 property. Its value is 'C:\Program Files (x86)\Common Files\Red Gate\SQLite\x64\'.

MSI (c) (F0:78) [12:26:40:270]: PROPERTY CHANGE: Adding VS2019_COMMUNITY_INSTALLDIR property. Its value is 'D:\'.

MSI (c) (F0:78) [12:26:40:270]: PROPERTY CHANGE: Adding VS2019_COMMUNITY_Common7 property. Its value is 'D:\Common7\'.

MSI (c) (F0:78) [12:26:40:270]: PROPERTY CHANGE: Adding VS2019_COMMUNITY_IDE property. Its value is 'D:\Common7\IDE\'.

MSI (c) (F0:78) [12:26:40:270]: PROPERTY CHANGE: Adding VS2019_COMMUNITY_EXTENSIONS property. Its value is 'D:\Common7\IDE\Extensions\'.

MSI (c) (F0:78) [12:26:40:270]: PROPERTY CHANGE: Adding VS2019_COMMUNITY_EXTENSION_DIR property. Its value is 'D:\Common7\IDE\Extensions\SQLPrompt\'.

MSI (c) (F0:78) [12:26:40:270]: PROPERTY CHANGE: Adding VS2019_PRO_INSTALLDIR property. Its value is 'D:\'.

MSI (c) (F0:78) [12:26:40:270]: PROPERTY CHANGE: Adding VS2019_PRO_Common7 property. Its value is 'D:\Common7\'.

MSI (c) (F0:78) [12:26:40:270]: PROPERTY CHANGE: Adding VS2019_PRO_IDE property. Its value is 'D:\Common7\IDE\'.

MSI (c) (F0:78) [12:26:40:270]: PROPERTY CHANGE: Adding VS2019_PRO_EXTENSIONS property. Its value is 'D:\Common7\IDE\Extensions\'.

MSI (c) (F0:78) [12:26:40:270]: PROPERTY CHANGE: Adding VS2019_PRO_EXTENSION_DIR property. Its value is 'D:\Common7\IDE\Extensions\SQLPrompt\'.

MSI (c) (F0:78) [12:26:40:270]: PROPERTY CHANGE: Modifying VS2019_ENTERPRISE_INSTALLDIR property. Its current value is 'D:\Program Files (x86)\Microsoft Visual Studio\2019\Enterprise'. Its new value: 'D:\Program Files (x86)\Microsoft Visual Studio\2019\Enterprise\'.

MSI (c) (F0:78) [12:26:40:270]: PROPERTY CHANGE: Adding VS2019_ENTERPRISE_Common7 property. Its value is 'D:\Program Files (x86)\Microsoft Visual Studio\2019\Enterprise\Common7\'.

MSI (c) (F0:78) [12:26:40:270]: PROPERTY CHANGE: Adding VS2019_ENTERPRISE_IDE property. Its value is 'D:\Program Files (x86)\Microsoft Visual Studio\2019\Enterprise\Common7\IDE\'.

MSI (c) (F0:78) [12:26:40:270]: PROPERTY CHANGE: Adding VS2019_ENTERPRISE_EXTENSIONS property. Its value is 'D:\Program Files (x86)\Microsoft Visual Studio\2019\Enterprise\Common7\IDE\Extensions\'.

MSI (c) (F0:78) [12:26:40:270]: PROPERTY CHANGE: Adding VS2019_ENTERPRISE_EXTENSION_DIR property. Its value is 'D:\Program Files (x86)\Microsoft Visual Studio\2019\Enterprise\Common7\IDE\Extensions\SQLPrompt\'.

MSI (c) (F0:78) [12:26:40:270]: PROPERTY CHANGE: Adding VS2017_COMMUNITY_INSTALLDIR property. Its value is 'D:\'.

MSI (c) (F0:78) [12:26:40:270]: PROPERTY CHANGE: Adding VS2017_COMMUNITY_Common7 property. Its value is 'D:\Common7\'.

MSI (c) (F0:78) [12:26:40:270]: PROPERTY CHANGE: Adding VS2017_COMMUNITY_IDE property. Its value is 'D:\Common7\IDE\'.

MSI (c) (F0:78) [12:26:40:270]: PROPERTY CHANGE: Adding VS2017_COMMUNITY_EXTENSIONS property. Its value is 'D:\Common7\IDE\Extensions\'.

MSI (c) (F0:78) [12:26:40:270]: PROPERTY CHANGE: Adding VS2017_COMMUNITY_EXTENSION_DIR property. Its value is 'D:\Common7\IDE\Extensions\SQLPrompt\'.

MSI (c) (F0:78) [12:26:40:270]: PROPERTY CHANGE: Adding VS2017_PRO_INSTALLDIR property. Its value is 'D:\'.

MSI (c) (F0:78) [12:26:40:270]: PROPERTY CHANGE: Adding VS2017_PRO_Common7 property. Its value is 'D:\Common7\'.

MSI (c) (F0:78) [12:26:40:270]: PROPERTY CHANGE: Adding VS2017_PRO_IDE property. Its value is 'D:\Common7\IDE\'.

MSI (c) (F0:78) [12:26:40:270]: PROPERTY CHANGE: Adding VS2017_PRO_EXTENSIONS property. Its value is 'D:\Common7\IDE\Extensions\'.

MSI (c) (F0:78) [12:26:40:270]: PROPERTY CHANGE: Adding VS2017_PRO_EXTENSION_DIR property. Its value is 'D:\Common7\IDE\Extensions\SQLPrompt\'.

MadMax August 10, 2021 09:03

0

Still no luck.

There does appear to be a few issues with folder locations written to the log file. Some of the folders listed do not exist on my drive. e.g.,