- Newest
- Most votes
- Most comments
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).
Relevant content
- asked 3 years ago
- asked 9 months ago
- Accepted Answerasked a year ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 3 months ago
- AWS OFFICIALUpdated a year ago
I am having the exact same issue.
this table shows the default and accepted values: https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.SQLServer.html#CHAP_Source.SQLServer.ConnectionAttrib
running
dms describe-endpoint-settings --engine-name sqlserver --output json
reveals the options:... { "Name": "TlogAccessMode", "Type": "enum", "EnumValues": [ "BackupOnly", "PreferBackup", "PreferTlog", "TlogOnly" ], "Sensitive": false, "Applicability": "SOURCE_ONLY" }, ...
None of these values work, via cloudformation template, or through the AWS Console.
I've been able to set the SafeguardPolicy source endpoint setting, but not TlogAccessMode.