This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 24%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJP%3C/text%3E%3C/svg%3E)
We have set up an Azure SQL Server database. We're trying to use an Access database as the front end, using Azure Active Directory authentication.
We've got one user connecting without any issues (the one that created the SQL Server database and Access database). We can't add a second user.
The second user has been added as an owner of the SQL Server database in Azure dashboard. I've tried to add her to the master database in SQL Server, but I'm not sure if I've done that right.
When we try to connect using Access, we get an SQL Server 18456 error, with " Login failed for user '<token-identified principal>' "
How can we give this user, and others, access to the SQL Server database?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(208, 31%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
Is the user trying to access the SQL Server DB directly from a personal client PC? Or from another machine in Azure?
@Jen Phillips Thank you for reaching out.
My understanding is that you are trying to connect to Azure SQL Database from your access using a local computer. Please let me know if my understanding is not correct.
How are you trying to connect. could you please share the steps.?
Are you connecting using Access or SSMS?
I wanted to check in and see if you had any other questions or if you were able to resolve this issue?
If you have any other questions, please let me know. Thank you for your time and patience throughout this issue.
If the information helped address your question, please Accept the answer. This will help us and also improve searchability for others in the community who might be researching similar information.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 79%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERR%3C/text%3E%3C/svg%3E)
Hi,
Thanks for sharing error message.
Error: Login failed for user '<token-identified principal>', it means the user is invalid, usually related to a AAD user that does not have user created on SQL DB that you are trying to connect (User DB or Master DB) or that the user is not the AAD Server Admin.
Please check below blog for more details and about mitigation steps