Activity overview
Latest activity by Christian Perez
Hi Justin, Thanks for following up, you will need to update to the latest version of Prompt since you are using Entra MFA, there was a fix put out in that version for Synapse Dedicated Pools and Entra MFA authentication. Keep in mind you will be prompted to accept permissions when you initially connect after updating Prompt that you will need to do, this may require an admin to approve. You can find the download link here: https://download.red-gate.com/checkforupdates/SQLPrompt/ / comments
Hi Justin, Thanks for following up, you will need to update to the latest version of Prompt since you are using Entra MFA, there was a fix put out in that version for Synapse Dedicated Pools and En...
Hi @... , we are aware of an issue with Synapse Dedicated Pools that use Entra MFA authentication still experiencing issues, however, the test build that I troubleshot this morning was successful in remediating that issue, so once the next release of Prompt goes out with this Private build I expect any remaining Synapse Dedicated Issues to abate for most users. Please be on the lookout for the next Prompt release on this page: https://download.red-gate.com/checkforupdates/SQLPrompt/ / comments
Hi @... , we are aware of an issue with Synapse Dedicated Pools that use Entra MFA authentication still experiencing issues, however, the test build that I troubleshot this morning was successful i...
With respect to toggling intellisense, if you click on SQL Prompt and then click on refresh suggestions or ‘Enable Suggestions’ that should force a reconnect to be attempted by Prompt to load suggestions. Are you using Entra MFA authentication with this dedicated pool by chance? / comments
With respect to toggling intellisense, if you click on SQL Prompt and then click on refresh suggestions or ‘Enable Suggestions’ that should force a reconnect to be attempted by Prompt to load sugge...
File Request You can submit the logs here for review. Please visit the following URL to send us files: https://files.red-gate.com/requests/UQm85OngUpGVd7TgPkZqX3 This link expires: Friday, 27 June. / comments
File Request You can submit the logs here for review. Please visit the following URL to send us files: https://files.red-gate.com/requests/UQm85OngUpGVd7TgPkZqX3 This link expires: Friday, 27 June.
Hi Paul, Sorry to hear you are also being impacted by the Prompt defect where it does not appear in SSMS 21, in my troubleshooting with other customers we have found that when the Prompt menu was not appearing for them, we deleted SSMS 21 and SQL Prompt along with Prompts AppData Directory (Users/christian.perez/appdata/local/Red Gate/SQL Prompt), after that we installed SSMS 21 first on the default C drive, after that we installed SQL Prompt 11.0.2 on the default C Drive (for testing) and it was at this point that we were able to see the SQL History button appear in SSMS 21 and then we were able to see both SQL Prompt options appear in the Extensions Costumization dropdown. If you try the above steps are you still not seeing the menu dropdown? / comments
Hi Paul,Sorry to hear you are also being impacted by the Prompt defect where it does not appear in SSMS 21, in my troubleshooting with other customers we have found that when the Prompt menu was no...
To piggy back off of Walter, once we installed SQL Prompt and SSMS on the C Drive and confirmed we could see it in the context menu of SSMS, we were able to then uninstall, move the Prompt installation location back to the D drive, and then reinstall Prompt and the Context Menu remained. We are investigated why the initialization does not appear to be working nominally when not installed on the C drive or when SSMS and Prompt are installed initially on different drives. / comments
To piggy back off of Walter, once we installed SQL Prompt and SSMS on the C Drive and confirmed we could see it in the context menu of SSMS, we were able to then uninstall, move the Prompt installa...
Thanks Walter, I have this behavior escalated with the Prompt team to fix the installer issues when SSMS 20 and 21 are side by side or installed on a different drive than one another, have you already tried the steps mentioned by Curtis to get Prompt to appear in the toolbar again?
Extensions | Customize Menus…
Uncheck both SQL Prompt boxes
Close SSMS
Open SSMS | Extensions | Customize Menus
Check second SQL Prompt box
Restart SSMS
If I am understanding you correctly, in your case, you do not have any SQL prompt boxes to check off when you click the Extensions Customize Menu? As Curtis mentioned SSMS 21 switches from a 32 bit to a 64bit architecture and as a result, should be much improved and faster to use once these teething issues are resolved. / comments
Thanks Walter,I have this behavior escalated with the Prompt team to fix the installer issues when SSMS 20 and 21 are side by side or installed on a different drive than one another, have you alrea...
Good Morning Dan, Thanks for your patience here, I do believe that we have some remediation steps ready for this behavior. We released version 11.0.2 of Prompt this morning and I was able to test this private build yesterday and it worked for me. The steps in this case would be to install the new version of Prompt and then afterwards to grant the login user connecting the Synapse Dedicated Pool db_datareader permissions. In my instance I used the following stored procedure to make the change. https://download.red-gate.com/checkforupdates/SQLPrompt/ EXEC sp_addrolemember 'db_datareader', '<login_name>';
GO After elevating the permission for your login user, close SSMS, reopen and reconnect and observe if you are still having the issue. Let me know if you would like me to elaborate on any of the instrucitons listed here or if you are still seeing the same behavior after performing the steps. / comments
Good Morning Dan, Thanks for your patience here, I do believe that we have some remediation steps ready for this behavior. We released version 11.0.2 of Prompt this morning and I was able to test t...
Hi, Walter, What is the behavior that you are now running into when you are installing? Apologies for making you repeat yourself but this thread now carries a few issues and so I am not sure what issue is impacting you. / comments
Hi, Walter,What is the behavior that you are now running into when you are installing? Apologies for making you repeat yourself but this thread now carries a few issues and so I am not sure what is...
Hi Justin, Thanks for reaching out to Redgate Support, sorry to hear you are having some trouble with intellisense in SQL Prompt 11. We have had a few users who have had some issues Dedicated Pools after updating, could I trouble you for your SQL Prompt Log files so I can review them and confirm you are not also being impacted? (SQL Prompt > Help > Locate Log Files) Alternatively, I have heard a few users have success toggling intellisense on and off to get things going again. / comments
Official comment
Hi Justin, Thanks for reaching out to Redgate Support, sorry to hear you are having some trouble with intellisense in SQL Prompt 11. We have had a few users who have had some issues Dedicated Pools...