Something is in the way of your machine and the SQLServer.

Best thing would be to work with your Network Admins & DBA's to ensure your workstation can connect over the...

Not you're local firewall, could be the firewall on the SQL Server, could be a network level firewall too, there's multiple places a firewall could be.

I missed the -Port keyword,...

Log shipping would be your friend here, use the previous full and log backups to make your new copy on the new server then setup LS to do the usual...

Have you verified that there is no firewall issue in the way?

Is SSMS installed on the SSRS server where you tested it successfully or is it on another machine?

Can the...

The error message is saying otherwise.

Please provide screenshots of your SSMS window so we can actually see what is happening, as in my SQL2022 setups, I only get the error...

That error is pretty self explanatory.

You may have disabled the audit, but you haven't disabled the audit specification.

Ensure you disable the right thing, and then it will let you modify...

When you installed SQL there would have been an option to set the auth mode, did you select Mixed or Windows only?

If it was mixed, what password did you give...

No there’s no differences between the patches

2016 is a dead product now, only time it will get an update is if there is a CVE that needs fixing.

You’ve got less than 2 years to get off...

You would actually be surprised how many people get others to setup SQL and they setup SA account and just toss the password away, leaving the DBAs up poop creek.

So...

Well there is a lot to be desired by the question, so Johan's answer is technically right.

We don't know anything about the setup only that you have been given local...

Use powershell and Test-NetConnection to the right TCP ports for the SQL instance and hadr_endpoint ports.

So if you have Host A, B, C

on A do

TNC ServerB 1433

TNC ServerB 5022

TNC ServerC...

So you want to do a

CREATE LOGIN

CREATE USER

ALTER ROLE

Create the login first at the server level if that is needed.

Create the user at the database level for that login

Alter the...

Then you will need to change your approach.

You'll need to store the output of the select into an object, then open another connection back to ABC - DB and do...

So you want to loop around 5 servers, pull the backup information, then store that data in ABC server in database DB?