You need to check in your application how you do your read connections and write connections.

If you want to offload reads you need to ensure you use two connection strings...

You must use a domain based account to register SPNs in the domain.

Once you have done that you can grant the needed permissions to the domain account so that it...

What mode do you have the AG set in SYNC or ASYNC?

If SYNC I would expect there to be some delay as your fighting with HADR_SYNC_COMMIT waits, however if it...

Are the ones you cannot connect to default instances using a non standard port?

If so you need to specify the port number in the connection.  SQL browser won’t help you...

Sounds like a double-hop problem.

Can you post the connection string obfuscated of course just to ensure

Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;

Server=myServerAddress;Database=myDataBase;Trusted_Connection=True;

If it is the double-hop issue, make sure you have the correct SPN's created...

The table is being published in an replication publication or subscription.

You need to remove the article from the publication before you can modify the PK or drop that table on...

Can you share your powershell code?

It may be a simple thing as needing to expand out the distinguisedName as that isn't an array.

get-aduser .... | select-object -expand distinguishedName

Check the SQL Server error log for 18456 errors and verify the state and severity then lookup that compared to the common 18456 errors.

Use the user ID and password in...

AD queries in SQL are quite annoying to do properly and then you get limited to the number of objects it can return before you need to then start looping...

What’s happening with ASK SSC at the moment, I keep reporting a lot of spam topics but no one is removing them.

Is that site dead now or is Redgate phasing...

SQLOLEDB does not support TLS1.2.

so you need to ensure there is a common protocol on both client and server which can be used is you must use that driver (TLS1.0).

Secondly...

Firstly, why are you using out of date technology?

You should be running supported versions of the products, to which Server 2008R2 and SQL 2008R2 are now massively out of support.

I...

Do you mean errors which are reported via DBCC CHECKDB?

If so the official line from Microsoft is to restore to your last known good backup.

You may attempt the repair_rebuild and/or...

You would have to code it into the job step using a try catch block, and inside the catch block you would send the email to say that the step...

Have you set the parameter “RegisterAllProvidersIP” to 0?

This will tell the cluster to only register the primary IP for the listener.

Either that or you must go and change your connection...