Register all IP providers = 0 is exactly that, you only register the active IP in DNS.

Then when failover happens the old IP is removed and the new IP is...

So yeah you have done everything right then.

No issues at all.

You’re facing a limitation on ping where it found the inactive IP in DNS first as it round robins the...

You need to use the connection option “MultiSubnetFailover=True” in your apps and management studio.

By default all IPs are registered via the cluster.  That way you get quicker re connectivity on...

In a manual failover, ASYNC mode, you execute

ALTER AVAILABILITY GROUP <AGNAME> FORCE_FAILOVER_ALLOW_DATA_LOSS

In a manual failover, SYNC mode, you execute

ALTER AVAILABILITY GROUP <AGNAME> FAILOVER

So the issue is the blue question mark on the server in SSMS?

That is down to there being no WMI response when SSMS asked for the service status so it...

So the accounts are in the same domain or in different domains?

If you have DOMAIN1\MyNormalAccount and DOMAIN1\MyAdminAccount, you would need to run SSMS as your admin account.

To do this you...

I can see some rational about this in terms of User -> Role Mappings at the database level, but from a server side, given that everything is a contained database...

So pulling in a tablix should be no different to feeding the text box with a value from the dataset.

The only real difference is you have to specify the dataset...

Someone mentioned that issue on the SQL Slack community also Johan.

Unsure if that was also yourself, but if you file a feature request on http://www.DBATools.io/issues,  someone will take a look...

So yeah your trying to multiply strings.

ABC x 123 = ????????

SQL cannot multiply a string, so one or more of the columns in the multiplication parts of the query will...

So it sounds like something isn’t glued together somewhere.

can you create a tablix and make it display the dataset correctly?

is the parameter driving the dataset correctly

can you run the query...

If the values you need are in a dataset, then you can’t use the Parameters! section to pull those in.

In the text box you want the value to appear in...

It will all depend on how YOU want to support the solution.  What are you comfortable in?  PowerShell?  SSIS?  T-SQL?  C#?  VB.NET?  Python?

From a PowerShell perspective, I have already provided...

You may also wish to look at restoring the windows installer cache.

https://docs.microsoft.com/en-us/troubleshoot/sql/install/restore-missing-windows-installer-cache-files

I’d be looking at PowerShell for that sort of thing.

Couple of modules to look at DBATools primarily for the SQL pieces, connecting running queries etc.

Then PoshSSH for the SFTP stuff.

You...