SQLprompt not working with SSMS 19. All other tools in sqltoolbelt working
gopal
Posts: 2 New member
in SQL Prompt
The SQLPrompt not working in SSMS 19.x onwards. I use other software in SQLToolbelt and works fine. The log shows its already installed but I have verified the RedGate install directory and add or remove programs, the prompt is not available. Tried installing using SQLtoolbet exe as well as standalone SQL prompt exe. Any help is appreciated. we do not have active support or upgrade license to contac support. Thanks!
2024-03-09 17:09:08.311 +05:30 [INF] 3/9/2024 5:09:08 PM [25] INFO MsiProgressReporter - Updating description: Searching for related applications Found application: [1]
2024-03-09 17:09:08.311 +05:30 [INF] 3/9/2024 5:09:08 PM [25] INFO MsiProgressReporter - Updating description: Computing space requirements
2024-03-09 17:09:11.591 +05:30 [INF] 3/9/2024 5:09:11 PM [25] INFO MsiProgressReporter - Updating description: Computing space requirements
2024-03-09 17:09:11.591 +05:30 [INF] 3/9/2024 5:09:11 PM [25] INFO MsiProgressReporter - Updating description: Computing space requirements
2024-03-09 17:09:11.654 +05:30 [INF] 3/9/2024 5:09:11 PM [25] INFO MsiProgressReporter - Updating description: Validating install
2024-03-09 17:09:11.824 +05:30 [INF] 3/9/2024 5:09:11 PM [25] INFO MsiProgressReporter - Updating description: Removing applications Application: [1], Command line: [2]
2024-03-09 17:09:12.062 +05:30 [INF] 3/9/2024 5:09:12 PM [25] ERROR MsiUiHandler - MSI reported an error: The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 2343.
2024-03-09 17:09:12.188 +05:30 [INF] 3/9/2024 5:09:12 PM [25] INFO MsiInstallerAdapter - --- end of MSI log ---
2024-03-09 17:09:12.188 +05:30 [INF] 3/9/2024 5:09:12 PM [25] INFO MsiInstallerAdapter - Finished SQL Prompt\SQL Prompt_10.13.15.3135_x86.msi
2024-03-09 17:09:12.339 +05:30 [INF] 3/9/2024 5:09:12 PM [22] INFO ProductsInstalledPayloadFactory -
available:
Product: SQL Prompt 10.13
Version: 10.13.15.3135
Requirements:
Is met? : True
Type : LaterVersionAlreadyInstalled
Description: A later version of this product is already installed.
Is met? : True
Type : CannotInstall
Description:
can be installed:
can be upgraded:
already installed:
Product: SQL Prompt 10.13
Version: 10.13.15.3135
Requirements:
Is met? : True
Type : LaterVersionAlreadyInstalled
Description: A later version of this product is already installed.
Is met? : True
Type : CannotInstall
Description:
cannot be installed:
selected to install:
Product: SQL Prompt 10.13
Version: 10.13.15.3135
Requirements:
Is met? : True
Type : LaterVersionAlreadyInstalled
Description: A later version of this product is already installed.
Is met? : True
Type : CannotInstall
Description:
2024-03-09 17:09:12.340 +05:30 [INF] 3/9/2024 5:09:12 PM [22] INFO ProductsInstalledPayloadFactory - {
2024-03-09 17:09:12.341 +05:30 [INF] 3/9/2024 5:09:12 PM [22] INFO ProductsInstalledPayloadFactory - 'canBeInstalled': 'System.Collections.Generic.List`1[System.Collections.Generic.IDictionary`2[System.String,System.Object]]';
2024-03-09 17:09:12.341 +05:30 [INF] 3/9/2024 5:09:12 PM [22] INFO ProductsInstalledPayloadFactory - 'canBeUpgraded': 'System.Collections.Generic.List`1[System.Collections.Generic.IDictionary`2[System.String,System.Object]]';
2024-03-09 17:09:12.341 +05:30 [INF] 3/9/2024 5:09:12 PM [22] INFO ProductsInstalledPayloadFactory - 'alreadyInstalled': 'System.Collections.Generic.List`1[System.Collections.Generic.IDictionary`2[System.String,System.Object]]';
2024-03-09 17:09:12.341 +05:30 [INF] 3/9/2024 5:09:12 PM [22] INFO ProductsInstalledPayloadFactory - 'cannotBeInstalled': 'System.Collections.Generic.List`1[System.Collections.Generic.IDictionary`2[System.String,System.Object]]';
2024-03-09 17:09:12.341 +05:30 [INF] 3/9/2024 5:09:12 PM [22] INFO ProductsInstalledPayloadFactory - 'selectedByUser': 'System.Collections.Generic.List`1[System.Collections.Generic.IDictionary`2[System.String,System.Object]]';
2024-03-09 17:09:12.341 +05:30 [INF] 3/9/2024 5:09:12 PM [22] INFO ProductsInstalledPayloadFactory - }
Tagged:
Answers
The error code 2343 is usually related to the installation path that is commonly found in the temp directory under the following location:
It's likely that the error is the installation path being emptied/deleted by an external source (virus protection, malware scan or access rights to the folder)
- Then to find out more, would you please be able to send through your installation log file?
You should be able to right-click the top part of the installer to access the installer logs as shown below:After the installer has finished and if it errors out you can find the folder here:
There are 2 TXT files in the installation folder, please attach those and send them across.
Victoria Wiseman | Redgate Software
Have you visited our Help Center?
I have already sent the log files to your team via email (gopal.xxx@wipro). Please check and let me know.
Thanks and appreciate the help.
I have a few things you can try.
Please can you repair your .NET framework https://quickbooks.intuit.com/community/Getting-Started/Repair-or-reinstall-Microsoft-NET-Framework/td-p/203709
Then use this Microsoft uninstaller to remove your Redgate tools altogether along with any rogue registry keys:
https://www.tenforums.com/tutorials/86975-program-install-uninstall-troubleshooter-windows.html
Then perform fresh installs:
https://download.red-gate.com/checkforupdates/SQLCompare/SQLCompare_14.10.9.22680.exe
https://download.red-gate.com/checkforupdates/SQLDataCompare/SQLDataCompare_14.10.9.22680.exe
https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.14.9.7331.exe
https://download.red-gate.com/checkforupdates/SQLMultiScript/SQLMultiScript_1.5.22.2664.exe
There's also some troubleshooting steps in this article:
MSI returned failure code 1603: Fatal error during installation
Victoria Wiseman | Redgate Software
Have you visited our Help Center?