When trying to open database diagrams on an AZURE SQL database I am getting this error The server principal "dbo." is not able to access the database "database_name" under the current security context. (.Net SqlClient Data Provider)
I am connected via SA and the database was created by the portal, other databases are ok so I am not sure why I am getting this error. Any ideas?