Upgrade to 10.0.9.13574 crashes SSMS 17.9 and 18.4 and Azure SQL DB
rpaquette25555
Posts: 1 New member
in SQL Prompt
Just upgraded SQL Prompt to 10.0.9.13574 from 10.0.8 something, running against Azure SQL DB. I have two SQL Server authentication accounts, one has access to master and one does not. In 10.0.8, I could connect with the account that did not have access to master using SSMS 17.9 or 18.4 and SQL Prompt would pop up a little notification in the background that master could not be accessed, or something like that, but otherwise worked fine. After the upgrade to 10.0.9 it hangs after connecting to the db and then SSMS shuts down, with no error, and restarts with all of my open tabs gone. The other account with access to master works fine.
I need both accounts due to roles and security rules. I have master in the disregard database list, but it looks like it tries to connect to master regardless. I will roll back to 10.0.8, but please fix so that it does not crash SSMS if it can't connect to master, or unable to read something, or whatever.
I need both accounts due to roles and security rules. I have master in the disregard database list, but it looks like it tries to connect to master regardless. I will roll back to 10.0.8, but please fix so that it does not crash SSMS if it can't connect to master, or unable to read something, or whatever.
Tagged:
Answers
Thank you for reporting this and sorry for the inconvenience caused.
We've got a fix for this issue and we'll be shipping it out shortly.
Tom
Team Prompt
Redgate Software