Using DBATools to migrate data from SQL Server 2016 to RDS SQL Server

[cormacrichardson]

Hi

I am trying to use Copy-DbaDbTableData to move data between a SQL Server 2016 database to a new RDS SQL Server.

By using username/password credentials I can connect to both databases via powershell in the same script with System.Data.SqlClient.SqlConnection and can traverse through the same table on both databases.

But when I use Copy-DbaDbTableData I get the following error:

WARNING: [14:08:20][Copy-DbaDbTableData] Failure | Login failed. The login is from an untrusted domain and cannot be used with Integrated authentication.

I then check the RDS SQL Server logs and get the following message:

SSPI handshake failed with error code 0x8009030c, state 14 while establishing a connection with integrated security; the connection has been closed. Reason: AcceptSecurityContext failed. The operating system error code indicates the cause of failure. The logon attempt failed

I have trying having Integrated Security=False; in the connection etc but still does not work, any help anyone can give would be great

Thanks

Cormac