How to access the database

Question

I can't log into the database. I don't remember ever needing a separate login to access this section. please seescreenshot.

Answer 1

Hello Amir Watynski

Based on our discussion, you're interested in connecting to the Azure SQL database using a specific user account. I suggested creating the login to ensure that you can establish the connection successfully with the chosen user.

Kindly please refer the below document for better understanding,
https://techcommunity.microsoft.com/blog/azuredbsupport/create-sql-login-and-sql-user-on-your-azure-sql-db/368813
https://learn.microsoft.com/en-us/azure/azure-sql/database/connect-query-portal?view=azuresql

Additionally, for comprehensive information about server-level roles, please refer to the detailed descriptions provided in this document.
https://learn.microsoft.com/en-us/sql/relational-databases/security/authentication-access/server-level-roles?view=sql-server-ver16
https://learn.microsoft.com/en-us/sql/relational-databases/security/authentication-access/database-level-roles?view=sql-server-ver16

I hope this has been helpful!Your feedback is important so please take a moment to accept answers. If you still have questions, please let us know what is needed in the comments so the question can be answered. Thank you for helping to improve Microsoft Q&A!

If this answers your query, do click Accept Answer and Upvote for was this answer helpful.