I've read through the documentation and have tried many, many things to get this to work but am still having trouble.

The AAD user is a member of a group that has been provisioned Contributor permissions via Access Control.

A Contained database User has also been created for the individual in question.

That database user is a member of both the db_datareader and db_datawriter roles.

All attempts to connect, including configuring additional connection properties in SSMS, have failed. I'm completely at a loss as to next steps.

  • Have you created a group? Create a group (i.e.test) in the main AAD and add the guest user there. Next create in SQL user (test) who is in the AAD group and connect to this DB using your guest user. If you still not able to connect post error message? – CR241 Nov 2 '18 at 20:30

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.