Thanks for posting back especially including the solution.

Good luck with the disasters.  Hopefully you do not have too many.

MAY have a solution to that:

https://bindujanga.blogspot.com/2016/03/sql-server-connectivity-issue.html

It isn't specific to SQL 2017, but may be something to look into.

To quote the article:

Windows server Event Log has many SChannel errors as below:

The...

I am thinking you are using the -o parameter and not the -i one (or possibly both), right?  -i is for an input file, -o is for output file.  Well,...

When you say multi-subnet, I am thinking that is a multi-VLAN setup, correct?

Communication across VLANs may require additional configuration to allow the communication.

If it is really multi-subnet, I am assuming...

My advice - try it and find out.

Having the site not secure when accessing it locally is likely because you are connecting to "https://localhost/reports_ssrs", right?  Connecting by server name should...

You can use a SSL certificate and HTTPS (ie port 443) with SSRS no problem.  SSC actually has a good tutorial on this:

https://www.sqlservercentral.com/articles/configure-ssrs-with-an-ssl-certificate

In that tutorial it explains how to use...

Glad to hear you got it sorted out.

Thanks for reporting back!

Thanks scdecate!  That is a bit more elegant of a solution than what I was proposing.

Seems to have a bug though - it returns the week of the 27th through...

if you haven't configured anything special, then port 80 is used for HTTP traffic.

If you want a SHORT TERM test, you can turn off the firewall on the server and...

Then it is likely a firewall issue.  Do you have port 80 open on the server to allow for HTTP traffic (or port 443 for https, or whatever port you...

Just to get a bit more info with this - you want to give a date range, and you want SQL to figure out how to break that up into...

Quick guess (as I don't have SSRS open in front of me), could you do something like add the Commission column to be calculated on the SQL side and then...

Could be DNS or could be firewall.

From your machine, can you PING the remote server by name?  If not, can you ping it by IP?

Yep.  That will work.  When you add encryption by service master key, it will overwrite the previous one.

I've had to do this when doing some restores from live to test...

My opinion, if it is a sequence or an identity really depends on a lot more than we can accurately guess from what was posted.  It might be that each...