Is this a physical server or a VM? If a VM is there anything on the VM host layer going on during that timeframe (VM snapshots, vMotions, storage migrations, etc.)?

What log are you looking at? You mentioned that your production SSRS is scaled out and sitting behind a load balancer. Have you looked at the report server logs of...

Is it just that report on the server not showing charts or any report on the SSRS server not showing charts? If possible I would try restarting the SSRS service...

Uh, why would an in-place upgrade not be possible from 2012 to 2016? It seems totally supported to me.

February 12, 2017 at 10:54 am

#1928001

Interesting. I remember there being problems with older versions of SSRS and IE 11, but that was fixed with updates to SQL.

I did a quick search and came...

Go into Reporting Services Configuration Manager > Report Manager. Click Advanced and then Edit. Click the radio button for Host Header Name and add the URL you want people to...

Is there a staging environment where they could run tests on first for validation before running on a production system?

Also, I am a big fan of explicit transactions...

Are sql1, sql3 and sqlFC in the same subnet, different subnets?

What example from MSDN? Can you provide the link?

I think you are referencing two different things. For TDE there needs to be a database master key in the master database of the instance. Your query is looking for...

Cool. Glad you got your issue resolved. And thanks for updating the thread to let others know the fix.

Sounds good. It is good to know that it is being looked at. I would hate for people to be turned off from the site because of bad forum threads.

Yep, that sounds right. If you delete the AG it should delete the AG configuration from all replicas. You are correct that you will have to remove the database on...

Do a search on Microsoft's and your virtualization vendor's site for best practices for hosting a SQL Server. For migrating a database itself, there is nothing special. SQL sees a...

If this is a brand new AG it is probably best to just delete the AG and restoring db on the secondary and start over from scratch.

What do...