Sorry folks, but we are not able to repro this issue (either using SSMS 17.9.1 or SSMS 18 Preview 7).
Since multiple people out there are reporting this issue, it is obvious that we are missing something that is specific to your environment or configuration.
Could you help us out and try to describe a little better your subscription/environment/account/permissions?
For example, does the following mainstream scenario works for you all:
1) Connect to Azure Portal
2) Create SQL server+database
3) Go to SSMS and connect to
4) Add firewall rule
If it does, then can you identify what is different between the case where it works and the case where it does not?
An error occurred while saving the commentDemian Marty commented
Just updated to V18.4 and still having the issue.
I think it has to do with the default directory of my logged in account. The default directory must be the directory that’s associated with the subscription where the Azure SQL DB server is created though.Demian Marty supported this idea ·