What are the challenges you face when working across database platforms? Take the survey
Options

Error on Install, not finding SSDT

MadMaxMadMax Posts: 7 New member
When I install or upgrade SQL Prompt, currently on 10.7, I get a message stating "Missing SQL Server Data Tools (SSDT) Installation".  I choose to continue with the install.  This message is displayed twice.  See first image below.

Visual Studio 2019, version 16.10.3, has SSDT installed. (second image)



 



Any idea why?  SQL Prompt does not appear an the Visual Studio menu like it does in SSMS.
Tagged:

Answers

  • Options
    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. 
  • Options
    MadMaxMadMax Posts: 7 New member
    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.
  • Options
    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 
  • Options
    MadMaxMadMax Posts: 7 New member
    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.
  • Options
    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. 
  • Options
    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.
  • Options
    MadMaxMadMax Posts: 7 New member
    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., D:\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\'.
  • Options
    MadMaxMadMax Posts: 7 New member
    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., D:\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\'.
  • Options
    MadMaxMadMax Posts: 7 New member
    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., "D:\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\'.
  • Options
    Hi Max,

    There was a comment earlier about someone having the same issue but when they opened a SQL Query in VS SQL Prompt was still there and functioning. Can you check to see if that is the case for you after the installation? 
  • Options
    Ben_P said:
    Hi Max,

    There was a comment earlier about someone having the same issue but when they opened a SQL Query in VS SQL Prompt was still there and functioning. Can you check to see if that is the case for you after the installation? 
    Even though it does work in my workstation, the setup routine is still flawed and ought to be addressed (which I assume you are).
  • Options
    MadMaxMadMax Posts: 7 New member
    edited August 12, 2021 5:08AM
    Sorry for the late reply and the duplicate posts.

    SQL Prompt does appear to be working in both VS 2019 and SSMS.  Ctrl+K Ctrl+Y will format the script and suggestions do appear.
  • Options
    MadMax said:
    Sorry for the late reply and the duplicate posts.

    SQL Prompt does appear to be working in both VS 2019 and SSMS.  Ctrl+K Ctrl+Y will format the script and suggestions do appear.
    Having been in IT for 30 years, I'm often amazed any of it works at all given the extremely fluid nature of systems, software and techniques which are ever changing.  It's one of the reasons I matriculated to SQL DBA after being a programmer - it changes far less often :)
  • Options
    I'm not to sure what causing the initial error message. I have tried to replicate it using the same version of SQL Prompt and VS but it installs without issue on my machine. I will check to see if there have been any other similar issue raised for this version and get back to you.
  • Options
    Removing all SSDT checks from the installer is currently on the dev team's backlog. Once it's done we'll update this post.

    Sorry for the inconvenience.
    Kind regards

    Victoria Wiseman | Redgate Software
    Have you visited our Help Center?
  • Options
    Hi, 

    We've now removed the SSDT check from the installer (as of 10.8.4.24201), so this prompt will no longer be shown to users. 

    Thanks, 
Sign In or Register to comment.