Richards blog

My first attempt to resolve this issue (see  this  post), I was able to get past the first barrier. However, for some reason, my SSO credentials were not working. My account was configured as the system administrator account, but I could not authenticate. Then I remember that my user password was different AT THE TIME THE SQL SERVER INSTANCE WAS CREATED. I was successfully able to connect using SQL Authentication with my username and the OLD PASSWORD.

While creating an Azure POC, I create a new SQL Database and tried to connect via the online tools. I then received the following message: Fortunately, the resolution is very simple. Open the database and navigate to the Firewall Settings at the top of the Overview blade. Select 'Add client IP' to resolve the problem.