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...

Yep.  That was what I meant - the database master key in every case of the "master key" except when I had said "service master key".

But basically, if you NEED...

My advice is to back up the master key no matter what.  Hypothetically, the server dies and needs to be rebuilt from scratch.  You install the SQL instance, restore the...

I have not seen that exact error, but my guess is that the error isn't being thrown by the SQL Server installer,but being thrown by Windows.  My GUESS is that...

That is how a firewall is designed though.  There are no "shortcuts" with security.

The ONLY other way you can set that up is to allow applications through the firewall instead...

CASE statement.  I'm not entirely sure where you are running the query, but basically do a check if SYSDATETIMEOFFSET() > Daylight savings start date AND if SYSDATETIMEOFFSET() < Daylight savings...

Did you restore the encryption keys using the SSRS configuration tool?  Without that, it won't be able to decrypt any encrypted data.

I would recommend checking out this post:

https://stackoverflow.com/questions/46876442/ssrs-migration-from-2008-to-2016/46879292#46879292

and make sure...