Question 225096 in Azure Question posted in
The official documentation to get you started can be found here.

Azure SQL Database connection with my MSSQL server on my pc

I cannot connect to the database in the sql server in Azure. I cannot connect in any way, regardless of mssql server or visual studio on my own computer. I get my connection information from azure and try to login as below but it doesn’t work. Does anyone have any information about the solution?

enter image description here

I have tried almost all entities related to my username. Other than that, access-related settings cannot be changed, I was not very successful.mssql login screen my azure server proporties my azure server proporties

Tags:

2

Answers


  1. 0

    enter image description here

    Make sure you add Server admin name in SSMS Login and Password which was given while creation of the SQL Server in Azure.

    Share error details which you get in Azure Portal Query Editor or SSMS to investigate further.

    Login or Signup to reply.
  2. 0

    If your SQL username contain @ in it then use the username followed by @servername.

    Example: [email protected]@<servername>

    My SQL Server admin:

    enter image description here

    Details for connection:

    enter image description here

    If you are using Active directory authentication you need to add AD user as Azure AD admin in SQL server

    enter image description here

    Successful connection:

    enter image description here

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search