Set error for DMS source endpoint attribute tlogAccessMode

Hello there,

I understand that while trying to set SQL Server source endpoint attribute: tlogAccessMode="PreferTlog". You are facing below error.

-- ERROR --
Getting: "SYSTEM ERROR MESSAGE:Invalid value provided for MicrosoftSQLServerSettings source field tlogAccessMode"

As you must be aware, Endpoint settings define additional endpoint-specific connection attributes for AWS DMS. In order to use endpoint settings you need to use the DescribeEndpointSettings IAM permission which grants permission to return the possible endpoint settings available when you create an endpoint for a specific database engine.

Kindly refer the below documentation for the same:- [+] DescribeEndpointSettings:- https://docs.aws.amazon.com/dms/latest/APIReference/API_DescribeEndpointSettings.html

Further, default value of TlogAccessMode is PreferTlog and valid values are BackupOnly, PreferBackup, PreferTlog, TlogOnly

Kindly refer below documentation for the same:- [+] Endpoint settings when using SQL Server as a source for AWS DMS:- https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.SQLServer.html#CHAP_Source.SQLServer.ConnectionAttrib

I sincerely hope above information is helpful for you. Have a great rest of your week!

I opened a support ticket with my company's cloud advisor, and they suggested that TLogAccessMode was only available in AWS DMS versions 3.4.2 and possibly prior (not sure where they found that information). I guess it's not an option anymore in my version of DMS (3.4.7).