Hi and Thanks for reaching out on the Redgate forums.
Regarding your query around Azure Synapse Serverless db's.
Yes, it should certainly be possible to connect to these instances and have SQL Prompt register them to provide functionality.
To test this; I connected to my Azure instance and spun up a new sample DB on a serverless compute instance and connected it to my local SMSS instance to access SQL Prompt functionality.
Have you tried connecting to an instance and are experiencing any issues in getting our tools to work?
If so please provide some further details so we can assist further
Looking at the log files it does show an issue connecting to the Azure instance which may be the major cause of this issue. Are you connecting via AD or SQL Server Authentication?
Is connecting via AD are you able to test a connection using SQL Server Auth and see if this issue persists.
I did notice that you are potentially using SQL Server 2014. This is not supported past SQL Prompt v10.3 and may also be a contributing factor to this issue.
End of support for SSMS 2012 & 2014
Are you able to confirm the version of SSMS you are using, and if possible replicate this on a newer installation to confirm if the issue persists?
Finally, if possible are you able to provide the full log file so we can look for any other angles of failure.
The link below has been generated if you are not wanting to share logs over a public forum. The link is unique to this inquiry and expires after a fortnight
Regarding this item; I note there have been a few releases for SQL Prompt which have targeted issues with Azure environments.
Can you please advise if you have updated your Prompt install in January?
The latest version (10.10.4) is available here for download - https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.10.4.26165.exe
Release note info is available here:
Releases 10.10.0 & 10.10.2 have potential connections to your code suggestions not appearing
Tips and how-to guides for Redgate products
Ask, discuss, and solve questions about Redgate's tools
Meet us at an event, get sponsored, and join our Friends of Redgate
In-depth articles and opinion from Redgate's technical journal