Anyone have any ideas? Still no progress on my side. And it seems to be a really unique issue, as I'm not finding any real info on the internet, either.
From: Heaton, Joseph@Wildlife Sent: Tuesday, January 17, 2017 11:17 AM To: 'mssms@lists.myitforum.com' <mssms@lists.myitforum.com> Subject: Issue with database replication SCCM 1606 Server 2012R2 SQL 2012 RTM Something happened Sunday morning at around 1:00AM. Suddenly, all of my database replication links are broken. Running the Replication Link Analyzer, I get the following error: Checking connectivity at site "Primary site name" to the SQL Server "Secondary site name\CONFIGMGRSEC" Connection failure detected between "Primary site" and the SQL Server "Secondary site\CONFIGMGRSEC". Check network and firewall settings between these computers. Blah, blah. Connection failure message: Failed to get SQL connection to "Secondary site\CONFIGMGRSEC" Things I've tried: 1) Check Windows Firewall settings to make sure nothing changed 2) Spoke with Network team, to make sure nothing changed on their side 3) Checked disk space on secondary 4) Reboot both Primary and Secondary servers. 5) Verify SQL services running 6) telnet from primary to secondary on port 1433, to verify that SQL traffic isn't being blocked. 7) Combed through Application and System logs on both ends, finding nothing. 8) From SQL Management Studio on primary, connected to secondary site successfully, I can see the CM_ database. So, I'm not finding any logs that are telling me what the issue is, but I have 15 secondary sites with broken database replication. (that is all of my secondary sites) I've done some Googling, with no real luck, either. Any tips, advice, etc. that you guys can offer would be greatly appreciated. Thanks, Joe Heaton Information Technology Operations Branch Data and Technology Division CA Department of Fish and Wildlife 1700 9th Street, 3rd Floor Sacramento, CA 95811 Desk: (916) 323-1284 Every Californian should conserve water. Find out how at: [SaveOurWater_Logo]<http://saveourwater.com/> SaveOurWater.com<http://saveourwater.com/> * Drought.CA.gov<http://drought.ca.gov/>
