Primary to CAS Database replication is not happening

Question

I am working on building SCCM infrastructure, customer already had Primary site on Domain B and they wanted expand primary site with CAS. As per the design CAS will be built on different domain A, After expanding primary with CAS server noticed Primary to CAS replication (Site data)is not working but CAS to primary (global data) is showing as successfull. Replication manager shows Global data initialization status 96% for almost last 4 days.
Domain A & B has two way trust and all required firewall ports have been already opened.
CAS site installation account and computer object has administrative rights on child primary server and primary DB.
Noticed following error rcmctrl.error on CAS server and please suggest.
Have case opened with Microsoft and suggested to register SPN for the SQL service but that did not resolve the issue and they are still working on it

Error: Exception message: [Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.~~ OLE DB provider “SQLNCLI11” for linked server “XXXX” returned message “Invalid connection string attribute”

.RCMCtrl log - How To Manage Devices Community Forum - Welcome to the world of Device Management! This is community build by Device Management Admins for Device Management Admins❤️ Ask your questions!! We are here to help you! - Primary to CAS Database replication is not happening replication status - How To Manage Devices Community Forum - Welcome to the world of Device Management! This is community build by Device Management Admins for Device Management Admins❤️ Ask your questions!! We are here to help you! - Primary to CAS Database replication is not happening

in progress 0
Shamshad Kp 3 weeks 2 Answers 50 views Beginner 0

Answers ( 2 )

  1. Hi Shamshad,

    You are getting this error in RCM Control log because CAS is unable to establish a connection to Primary using a linked Server. As part of the ConfigMgr setup, it creates a linked server in CAS. If you go to Server objects in SQL Management studio of CAS, you might be able to see a linked server with the name of your Primary site SQL Server.

    Right-click on that do a test connection, it will be throwing an error for you the same one which you are getting in your RCM control. So, the default configuration for linked server is not working in your environment. Involve your AD team and SQL connectivity team from CSS to fix the issue.

  2. There could be issues with domain related port opening …. I have many posts about this issue … primary server and sql should have access to domain server A where cas is located
    And the cas should have access to Domain server B where primary server is located.

    https://www.anoopcnair.com/sccm-firewall-ports-details-and-direction-with-dc-other-servers/

Leave an answer

Sorry, you do not have a permission to answer to this question .