![]() Email addresses like or aren't supported as Azure AD admins.On the Azure Active Directory main page, select Save. On the Azure Active Directory form, search for and select the user or group you want to be the admin, and then select Select. On the Azure Active Directory page toolbar, select Set admin. On the server page, select Azure Active Directory in the Settings section of the left menu. In the Azure portal, on your Azure SQL database Overview page, select Server name under Essentials to navigate to the server for your database. ![]() Set up an Azure Active Directory (Azure AD) administrator for the database's SQL server.Īn Azure AD server administrator can use a single identity to sign in to the Azure portal and the SQL server and databases. Have or set up a user that can connect to the database with SQL authentication. If you don't have it, you can create a database in Azure SQL Database that has the AdventureWorks sample data.Ī user account with permissions to connect to the database and query editor. The AdventureWorksLT sample Azure SQL database. In this quickstart, you connect to an Azure SQL database in the portal and use query editor to run Transact-SQL (T-SQL) queries. Query editor (preview) is a tool to run SQL queries against Azure SQL Database in the Azure portal.
0 Comments
Leave a Reply. |