I am using a DMS task to migrate data from on-premise to the cloud in AWS.
I have resolved several issues involving permissions.
Now, I am encountering the following error that I am unable to resolve which is causing my DMS script to fail. Can anyone shed light on this error and how to fix it?
Last Error Fatal error has occurred Task error notification received from subtask 0, thread 0 [reptask/replicationtask.c:2822]  RetCode: SQL_ERROR SqlState: 08004 NativeError: 911 Message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Database ‘rdsadmin’ does not exist. Make sure that the name is entered correctly. Line: 1 Column: -1; RetCode: SQL_ERROR SqlState: 42000 NativeError: 21089 Message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Only members of the sysadmin fixed server role can perform this operation. Line: 1 Column: -1; Failed while preparing stream component ‘st_0_3ZJW7ULRLAL2T5LICGL5JFYRUF3SDGNTCZZNKJA’.; Cannot initialize subtask; Stream component ‘st_0_3ZJW7ULRLAL2T5LICGL5JFYRUF3SDGNTCZZNKJA’ terminated [reptask/replicationtask.c:2829]  Stop Reason FATAL_ERROR Error Level FATAL