SSRS Report stucks at loading IE 11

Question

We are running SQL Server 2008 R2. All these reports were working fine until we upgraded IE from 10 to 11. Every time we run a report, it will just stuck at loading forever.

Tried changing the document mode to other versions.

Maurilia

Anything in the server event log? Javascript console of the browser? – Trapezohedron

Does it load under compatibility mode? – Trapezohedron

Set your browser to backward compatible see what happen then ?? – Profession

It works when I add the site to Compatibility View. – Maurilia

I'm experiencing the same issue, and found a more detailed question and potential answer: https://mcmap.net/q/341233/-reportviewer-ie-11/419956 – Bellini

Answer 1

Per the OP, add the site to Compatibility View.

It's also possible that the browser detection needs to be updated on the server side for .Net per this blog article. Basically, there's a hotfix for ASP.Net 4.0 and one for ASP.Net 3.5sp1 and ASP.net 2.0 that you need to apply. Alternatively, you can update to ASP.Net 4.5 which will also fix the 4.0 issue.

Trapezohedron

@Maurilia Did the additional information about that browser detection issue help at all? (You'll need to remove that site from the compatibility list to see if it really worked.) – Trapezohedron

I installed this patch and it seemed to fix the issue, but then next day it was broken again :| – Longheaded

Answer 2

You might need to upgrade to your SQL server to Service Pack 2. There are several issues compatibility issues with ie10+ and SQL Server 2008R2 RTM.

ReportViewer's Print Button Incompatible with IE 10?

The following table lists the major releases of SQL Server 2008 R2.
Release Product version
SQL Server 2008 R2 Service Pack 2   10.50.4000.0
SQL Server 2008 R2 Service Pack 1   10.50.2500.0
SQL Server 2008 R2 RTM  10.50.1600.1

Microsoft Article on Server Version

Connect to the instance of SQL Server, and then run the following query:

Select @@version

Uncrowned

Answer 3

Sometimes just restarting the reporting services (Services) might also help, just like in my case ;)

Freestanding