Sounds like a call to MSFT to me....

On Wed, Jan 18, 2017 at 10:27 AM, Heaton, Joseph@Wildlife <
[email protected]> wrote:

> 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:* '[email protected]' <[email protected]>
> *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:
>
> [image: SaveOurWater_Logo] <http://saveourwater.com/>
>
> SaveOurWater.com <http://saveourwater.com/> · Drought.CA.gov
> <http://drought.ca.gov/>
>
>
>



Reply via email to