Lakehouse SQL endpoint broken

[S24_SimonNoer]

i somehow brok the sql endpoint

I wont load in the service
and Azure Data Studio returns this:

The tabels in the lake itself look fin.

When i try to create a report through the default semantic model it give me this:

Couldn't load the data for this visual

Login failed for user '<token-identified principal>'.. The exception was raised by the IDbConnection interface.

Please try again later or contact support. If you contact support, please provide these details.

[Anonymous]

Hi  @S24_SimonNoer ,

This error usually occurs when the user trying to login to SQL Server Management Studio is invalid. It is often related to an Azure Active Directory (AAD) user which is not added on the SQL DB that you are trying to connect to.

Here are some potential solutions:

Add the AAD user to your SQL DB: If the user is not added to the database, you might encounter this error. You can add the user to the database with the following command:

1.CREATE USER [your_username@your_domain.com] FROM EXTERNAL PROVIDER;

Replace with your actual username and domain.your_username@your_domain.com

2.Specify the database name in the connection properties: By default, it will try to connect to the master DB where this user may not exist there as AAD users are contained inside each user database. In the SSMS Connect Explorer > Options - Connection properties - Give the Database Name and in the Login Tab > Authentication as Azure AD - Universal with MFA and username is your Azure Account username.

3.Check your Azure Service Authentication: Go to Tools -> Options -> Azure Service Authentication -> Re-enter your credentials -> Use MFA.

Best regards.
Community Support Team_Caitlyn