We use gMSAs quite a bit in my environment. While they are good for generic SQL Server stuff, I wish the MS Docs documentation was a little more clear on...

Jrb2971, my testing has shown that they cannot be used as data sources, neither defined in the report or shared. I also could not get them to work as SQL...

You know you can provide a comma separated list to the -computername parameter, right?

Type the NETBIOS name, IP address, or fully qualified domain name of one or more computers in...

Is the application hosted on machines on different subnets than the AG nodes? I ask because I had an issue in our environment where app servers would lose communication for...

How many rows in your tables? That cross join is most likely killing you, as it is multiplying every row in the first table with every row in the second...

Do you have any security software doing on access scanning? If SQL db files are not excluded I could see this type of issue popping up, especially after a system...

Why would you not want Kerberos connections? If I were you I would suggest either setting SQL on the instances to use either virtual accounts or if you want a...

Looks like you can set how SQL listens on TCP/IP using mssql-conf.

https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-configure-mssql-conf?view=sql-server-2017#tcpport

Did you ever figure this out? Looks like the errors are coming from the loopback address. Curious, did shared memory get turned off as a connection protocol?

Short of removing the dll from servers I think your options might be limited. You could try e-mailing DISA STIG support. If you have to have the dll in place...

Glad to see your problem is fixed.

I hate that dll.

FYI if  it is on other servers you might get similar symptoms with other actions, like setting/resetting...

Would this server happen to be in a government environment? I have had the same experience due to a bug in the EnPasFltV2x64.dll/EnPasFltV2.dll password policy libraries. Thing is if this...

The master key you are seeing that is showing as being encrypted by the server key, is that on the BanditDEMO database? If so it would appear that key is...

You posted the SPNs, but what about delegation? With Kerberos double-hop issues it is both SPNs and the delegation to those SPNs that you have to look into. In your...