Unable to connect to Azure SQL database from SSMS

Question

Hi all, I connect to Azure DB using SQL management studio with MFA autentication with my user, it's working fine (i add my IP to the firewall) Then, I change and i try to connect using SQL user and password (SQL autentication), but it's not connecting. With Power Bi, I try to connect with the SQL autentication and it's working. I think it could be due to the new "Microsft Entra ID". Thanks Best David PD. it's similar to this other post. https://learn.microsoft.com/en-us/answers/questions/720929/unable-to-connect-to-azure-sql-database-from-ssms

Answer 1

Hi, @DAVID SANCHEZ RODRIGUEZ
Welcome to Microsoft Q&A thanks for posting your question.

Great to hear that your issue is resolved! and thank you for posting your solution so that others experiencing the same thing can easily reference this! Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others ", I'll repost your solution in case you'd like to "Accept " the answer.

Issue: Having trouble connecting to an Azure SQL database from SQL Management Studio using SQL authentication. you have already successfully connected using MFA authentication and SQL authentication with Power BI. you suspect that the issue may be related to the new "Microsoft Entra ID."

Solution: As you mentioned Yes, when connecting to an Azure SQL database using SQL authentication, you need to specify the name of the database you want to connect to. By default, SQL Management Studio will try to connect to the "master" database. To connect to a specific database, you can either specify the database name in the connection string or select the database from the drop-down list in SQL Management Studio after connecting to the SQL Server instance.

If you have any other questions or are still running into more issues, please let us know.

Regards Geetha