Authentication issues after Azure Synapse database restoration

Dawid Taciak 6 Reputation points
2021-08-02T19:11:45.177+00:00

Following accidental deletion of Azure resources our Azure SQL server (hosting Synapse SQL Pool database) has been successfully restored. So far, so good. We got back all data and security objects (users, roles, permissions), however some users experience issues with access to database and getting 18456 (login failed for user '

Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
19,672 questions
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Dawid Taciak 6 Reputation points
    2021-08-03T20:58:27.463+00:00

    An update: The issue was solved when we paused and resumed the SQL Pool / DW. It seems that there was some desynchronization of tokens.

    1 person found this answer helpful.
  2. Tony Small 5 Reputation points
    2023-01-20T09:50:06.3833333+00:00

    In my case, using a new session, instead of one from the previous day, solved my issue

    I copied the code I was attempting to a new SSMS windows and it ran without error

    Tony

    1 person found this answer helpful.
  3. Cristian SPIRIDON 4,471 Reputation points
    2021-08-03T05:16:31.583+00:00

    Do you need the database resource in order to assign the admin privileges?

    Maybe previous account was tied to the old resource.

    0 comments