Azure Data Studio Database Project Failure When Applying Schema Compare
0
votes
0
answers
370
views
I'm using Azure Data Studio. I created a brand new project and updated it from the database. Made a very small change, and attempted to apply back to the database. I receive the error "The source login in not a member of the 'loginmanager' role. The comparison will be restricted to database scoped elements."
I tried granting loginmanager to my user account.
I tried turning off every object type except stored procedures (what I'm changing), as others have suggested turning off the security objects (for example, here: https://github.com/microsoft/azuredatastudio/issues/21773) .
The full error was:
>Apply schema compare changes: Error SQL0: Performing publish is not possible for this comparison result.\
System.AggregateException: One or more errors occurred. (The source login in not a member of the 'loginmanager' role. The comparison will be restricted to database scoped elements.) (Cannot generate deployment plan due to an internal error.)\
---> System.Exception: The source login in not a member of the 'loginmanager' role. The comparison will be restricted to database scoped elements.\
--- End of inner exception stack trace ---\
---> (Inner Exception #1) System.Exception: Cannot generate deployment plan due to an internal error.
>Error SQL0: Performing publish is not possible for this comparison result.
System.AggregateException: One or more errors occurred. (The source login in not a member of the 'loginmanager' role. The comparison will be restricted to database scoped elements.) (Cannot generate deployment plan due to an internal error.)\
---> System.Exception: The source login in not a member of the 'loginmanager' role. The comparison will be restricted to database scoped elements.\
--- End of inner exception stack trace ---\
---> (Inner Exception #1) System.Exception: Cannot generate deployment plan due to an internal error.<---
Asked by Sean
(1 rep)
Jan 10, 2024, 09:50 PM
Last activity: Jan 16, 2024, 09:09 PM
Last activity: Jan 16, 2024, 09:09 PM