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”
.
Answers ( 2 )
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.
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/