[Data Studio] Table Designer Error

Question

I am currently using Azure Data Studio to design my database. Every hour, i receive a message that reads:

Table Designer Error:

An error occurred while generating preview report: Validation failed with the following errors. . Error 1: The target database schema could not be retrieved. Login failed for user '<token-identified principal>'. Token is expired., Line: 0 Column: 0.

It seems that my credentials / token times out after one hour. I have tried troubleshooting to no avail. Can someone guide me to where I can resolve this issue? The goal is to not time out every hour.

Answer 1

Hi Jess Boozell Thank you for reaching out.

Sorry to hear that you are facing a time out issue with Azure Data Studio.

This issue will be addressed in the coming release. In the meantime, could you please enable this setting manually "mssql:enableSqlAuthenticationProvider" in ADS v1.43 or use ADS insiders build for best experience!

https://learn.microsoft.com/en-us/sql/azure-data-studio/release-notes-azure-data-studio?view=sql-server-ver16#whats-new-in-1420

Introduced a new setting, Mssql Enable Sql Authentication Provider to allow connections to be maintained without the concern of losing access token lifetime or getting dropped by server. Access tokens will be refreshed internally by the SqlClient driver whenever they are found to be expired. This option is disabled by default.

Detailed documentation will be published on release day when this is enabled by default.

Please do not forgot to mark as accept answer if the reply was helpful.

Regards,

Oury