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(134.4, 99%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJK%3C/text%3E%3C/svg%3E)
I have a simple azure sql server database that I can no longer connect to in Azure Data Studio. When I try to connect via SQL server login, the Create a Firewall Rule screen appears. When I select either "add my client IP" or "add my subnet IP range" I get this error message:
Error: invalid_grant occurred when acquiring token. 9002313 - [2024-09-26 20:44:30Z]: AADSTS9002313: Invalid request. Request is malformed or invalid. Trace ID: 3b9e2e71-98ac-436a-970a-65a7a1835700 Correlation ID: 1a667cea-cbb0-4313-acdd-21236f26882c Timestamp: 2024-09-26 20:44:30Z - Correlation ID: 1a667cea-cbb0-4313-acdd-21236f26882c - Trace ID: 3b9e2e71-98ac-436a-970a-65a7a1835700
I am using the correct credential. I can connect to the database's IP on port 1433. My computer is on the same time zone as the server (east US).
![](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(227.2, 46%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
@John Kozempel
Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
This issue may be related to a cached token. try to delete the token from the following path on your Windows computer:
C:\Users{UserNameHere}\AppData\Roaming\azuredatastudio\Azure Accounts
and try again.
For MacOS, please find /Users/{your_username}/Library/Application Support/azuredatastudio/Azure Account and remove it.
@John Kozempel
Just checking in to see if the above answer helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
![](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(307.2, 45%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E)
Can confirm I was also seeing invalid_grant occurred when acquiring token. Cleaning up that Azure Accounts folder did the job, thanks!