Skip to main content

Configure Azure SQL Database User Access

Hands-On Lab

 

Photo of

Training Architect

Length

01:30:00

Difficulty

Intermediate

Azure SQL allows for Azure Active Directory integration. What does that mean for us? It means having a centralized identity provider for SQL database and server access. No more localized SQL logins!

In this hands-on lab, we integrate a pre-deployed SQL server with Azure AD. We use the Azure Portal to assign an Active Directory admin to the server. We then use SQL Server Data Tools in Visual Studio to assign a test user to the database. Finally, we log into the database using the test user and run a sample query.

What are Hands-On Labs?

Hands-On Labs are scenario-based learning environments where learners can practice without consequences. Don't compromise a system or waste money on expensive downloads. Practice real-world skills without the real-world risk, no assembly required.