Error loading metadata using AWS SCT against an RDS SQL Server Instance

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.