Hi, Thank you for reaching out. Looking at the error from the log: its throwing a SQL Server exception listed here: https://docs.microsoft.com/en-us/sql/relational-databases/errors-events/database-engine-events-and-errors?view=sql-server-ver15 This script "load-script-object-ext-properties” could be getting invoked by SCT menu "Refresh from Database”.
You can try to connect to SCT through master user of the SQL Server database and see if you are able to see the schemas of any database. In addition, if you have not already granted the permission required, please do so by repeating the grant for each database as mentioned here: https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/CHAP_Source.SQLServer.html#CHAP_Source.SQLServer.Permissions
If the above does not help, as a test, please try to create a sample database and a table with master user of your RDS SQL Server instance and check if you are able to view the schemas then.
In order to further help you with this issue, we require details (such as complete log) that are non-public information. Please open a support case with AWS using the following [https://console.aws.amazon.com/support/home#/case/create.]
Sometimes, a simple fix by DISCONNECTING from the SOURCE-database and creating a new SOURCE-Connection will fix such problems within SCT.
Is it possible to use AWS RDS SQL Server as an AAG target from on premise primary?asked a year ago
Migrate SQL Server DB (outside of AWS) to Aurora DB in AWSAccepted Answer
How to migrate DB on premise Oracle to Microsoft SQL Server DB in AWS. We see SCT will not allow MS SQL Server as Target when source is Oracle. Looking for tools like SCT to move Schema from Oracle.asked 5 months ago
SQL Server RDS migration to EC2 SQL ServerAccepted Answerasked 4 months ago
AWS Schema Conversion Tool - Troubleshooting a Connection Error?
Error loading metadata using AWS SCT against an RDS SQL Server Instanceasked 9 months ago
DMS to migrate SQL Server from RDS to EC2asked 3 years ago
Sizing RDS SQL Server for existing SQL Server running on Windows ServerAccepted Answerasked 3 days ago
Error while connecting to SQL Server Express Edition from SCTasked a year ago
On AWS RDS for Oracle how to install Oracle Database Gateway for SQL Serverasked a month ago