---
title: "Adding AzureAD user to SQL Server"
canonical: "https://servicedesk.maxgeo.com/space/MAXGEO/166035458/Adding%20AzureAD%20user%20to%20SQL%20Server"
format: markdown
---
AzureAD users cannot be seen in the list of users when adding users to SQLServer logins 

## Solution



1. Identify the users full username through the windows users in control panel
2. In SSMS run the following query against the database,
3. Replace the `FirstLast`with the actual username
4. Once run this will create the user in the SQL logins


> ⚠️ DB Modification
> ⚠️ 
> ⚠️ Before any change is made to a user database (or system), maxgeo recommends competent staff should follow all standard database change management practices and never make untested changes to a production database.  
> ⚠️ Change, test and document all modifications on a test copy of your database to ensure results are as expected before implementing them on your live database. Always ensure a full backup is available in case rollback is required and follow all company change management procedures and practices.

## Related articles



> Macro (contentbylabel)

> Macro (details)
> 
> | Related issues |  |
> | --- | --- |