[Data Studio] Table Designer Error

Jess Boozell 20 Reputation points
2023-05-16T13:17:58.1533333+00:00

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.

Azure Data Studio
Azure Data Studio
A cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
104 questions
0 comments No comments
{count} votes

Accepted answer
  1. Oury Ba-MSFT 17,156 Reputation points Microsoft Employee
    2023-05-16T17:54:43.73+00:00

    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


0 additional answers

Sort by: Most helpful