DMS Error Starting New Replication Task in STAGE
0
Greetings, an error has been encountered that has not been seen before. I could not find anything on google so I am hoping someone here can help. This happens when we start a new DMS task.
Source Endpoint: on-prem SQL Server Instance Target Endpoint: RDS SQL Server Instances
2024-04-29T18:26:57 [SOURCE_CAPTURE ]E: Failure in approving stored functions presence [1020101] (sqlserver_endpoint_capture.c:372)
질문됨 한 달 전166회 조회
1개 답변
- 최신
- 최다 투표
- 가장 많은 댓글
0
this message it is unable to identify if the source sql server node is primary or secondary read replica. if your database is not part of alwaysonavailability group then you can ignore this message else check if endpoint login/user has permissions to query following system objects.
sys.availability_groups_cluster sys.dm_hadr_availability_replica_cluster_states sys.dm_hadr_availability_replica_states sys.availability_replicas sys.dm_hadr_availability_group_states
답변함 한 달 전
