Hi, @sql dev Thanks for posting your question in the Microsoft Q&A forum.
This error is usually related to a AAD user that does not have a user created on SQL DB or is not the Server Admin
create the user in the DB please follow this document here
Regards
Geetha