Trying to connect from AWS schema conversion tool to MS SQL in AWS cloud. In the process got the below error
2023-02-15 18:15:16.742 [ 53] LOADER ERROR Error executing 'get-log-shipping' query: com.microsoft.sqlserver.jdbc.SQLServerException: The SELECT permission was denied on the object 'log_shipping_primary_databases', database 'msdb', schema 'dbo'.
I'm logging into the database using SSMS using the same admin ID created while spinning the sql server in AWS and the same ID to connect to sql server from AWS schema convertion tool too.
Where should I enable the permission for the above log shipping. Is there anyother login credential I should use to enable the above for the user id with above privileges?
Thanks
