Azure SQL DB: The specified failover group name is already in use

File this in the category of error messages that don't really mean what you think. When configuring a failover group using Azure SQL DB, you need to provide a "name" for the failover group. However, the name really becomes the FQDN of the failover group, but that's not directly obvious. The implication of that is … Continue reading Azure SQL DB: The specified failover group name is already in use

Creating an Azure SQL DB Firewall Rule from SSMS 2016 and Error 401

When connecting to an Azure SQL DB endpoint (somename.database.windows.net), your IP must be listed in that endpoint's (server's) firewall: If you're connecting to your Azure SQL DB from SQL Server Management Studio 2016 and your IP address is not in the list, SSMS will offer to add it: You'll need to sign in with a … Continue reading Creating an Azure SQL DB Firewall Rule from SSMS 2016 and Error 401