This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 96%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAH%3C/text%3E%3C/svg%3E)
Hi there,
I'm not sure if anyone has experienced this issue before, but it's surely a strange one!
Our organisation suffered network issues last week with our DR site and since then we are having problems with SharePoint permissions. Some users have been removed from SharePoint groups automatically and previously deleted users have appeared automatically into SharePoint groups again. This has effected all of our SharePoint farms.
The only thing in common that these SharePoint farms have is they share a SQL server that's a member of a failover cluster. This group contains two SQL servers that are configured for manual failover. I don't believe this is a SQL issue as there appears to be no data loss, plus database replication is reported to be healthy on the SQL side of things. Plus other non SharePoint SQL instances are not reporting any issues with data loss / permissions.
I've checked SharePoint audit logs, SQL logs, server logs but I can't seem to see anything wrong! I'm pulling my hair out! Has anyone experienced permissions issues such as this before? And if so, how was it resolved? Am I looking in the right places?
Thanks,
Aled.
A family of Microsoft on-premises document management and storage systems.
Additional SQL Server features and topics not covered by specific categories
SharePoint doesn't remove users from groups/sites or restore users to sites/groups automatically as it has no mechanism to do this in code.
What may have happened is that you're working with an older copy of the Content Database(s) that weren't replicating properly. What form of SQL replication was in place?
Hi, we use SQL failover clustering in a active / passive mode. I really don't think our SharePoint farms were connecting to the secondary node. We have no reported data loss. Sync yn SQL is reporting healthy.
Thanks,
Aled.
Well, it certainly does sound like a data issue unless someone is manually making these changes within SharePoint.
Do you have a recent backup prior to the failover that you could check in a non-production environment?
Hi Aled,
I'm a DBA, been part of part in supporting sharepoint deployment.
I have also seen the some situation the sharepoint upgrads which removes the Farm account access sometimes.
Where we have manually added recreated.
In your case, as its SQL WFC, the access will be same in each node where ever it runs. So please check if that something similar.
I would suggest to have conversation in Sharepoint Blog side as this is not really a person from SQL side can help.
And next time when you run just ran a trace or audit to the farm accounts alone for the access changes will help to identify the cause.