Recent Blog ArticlesMost RecentMost LikesFCI failed to do failover because of ReAclDirectory : Failed to apply security when applying patch AG force failover to DR, then reconnect to Prod nodes. Will AG keep Prod data or DR data ? I made a test in my testing environment. Below are my test results I have 3 nodes in this Alwayson. CPS2019VM3 is DR node. I set firewall rules in VM1 and VM2 to block all network traffics fr...sp_helprotect is very useful in permission issue SQL SERVER installation failed. “Access is denied” when validating SQL Service account password Cancel " width="1054" height="693" border="0"> Patch upgrade failed. ‘Error:574 CONFIG statement cannot be used inside a user transaction.’ Creating index becomes extremely slow when all rows are in one partition Cannot find SQL instance when applying patch SQL Service failed to start because of 'Detected unsupported pre-release version of Windows' How to configure windows authentication for Microsoft JDBC in Linux How to configure windows authentication for Microsoft JDBC in Linux. (We use Squirrel to do this test) Install necessary packages sudo yum install realmd krb5-workstation sudo yum insta...DBF file name is truncated to 8 characters