Azure SQL login for Guest user

ronis 1 Reputation point
2022-02-25T12:43:36.813+00:00

Hi,

Is it possible to get Azure AD Guest-user to log on to the Azure SQL database using SSMS?

Currently member accounts works but guest accounts do not..

Thanks!

Azure SQL Database
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ronis 1 Reputation point
    2022-02-25T14:03:25.307+00:00

    Problem solved:

    • added them as users to the SQL database where they are referenced as "name_<client>.com#EXT#@<my account>.onmicrosoft.com"
    • with the login to the desktop interface, they are able to use the format name@Evan ! .com