Home > Enterprise >  Cannot Connect to Azure SQL Server using SQL Authenntication
Cannot Connect to Azure SQL Server using SQL Authenntication

Time:09-27

So here is my situation. I have an azure sql server that i am trying to connect to.

If i try to connect with AAD w/Universal MFA it works fine. If i try to connect with SQL authentication it fails. My ip is in the firewall exception list.

I have tried it on multiple machines, on multiple networks, even going so far as to set up an azure vm and trying it from there, but no luck.

This worked previously up until a few weeks ago, and as far as i can tell nothing was changed.

Any advice would be GREATLY appreciated!

enter image description here

Error Message ectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource1 retry) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.SqlServer.Management.SqlStudio.Explorer.ObjectExplorerService.ValidateConnection(UIConnectionInfo ci, IServerType server) at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

CodePudding user response:

The login to SQL Server is working.

A SQL login is mapped to a database user.

The problem is that the default database for "BlackbirdAdmin" is master, and the "BlackbirdAdmin" login is not mapped to a database user in master.

  • Related