THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

The Bit Bucket (Greg Low): IDisposable

Ramblings of Greg Low (SQL Server MVP, MCM and Microsoft RD) - SQL Down Under

IE9 and Report Builder 3.0 - Compatibility Mode is needed

Hi Folks,

Hope this helps someone. After upgrading to IE9 and SQL Server 2008 R2 CU7, I found that I couldn't access Report Manager anymore. I found that even though I was in the BUILTIN\Administrators group, that I had to specifically add myself to the Content Managers role in Reporting Services for the root folder of Report Manager. (I have no idea why as it used to work ok) NOTE: I had to do this with UAC turned off, otherwise, Site Settings, etc. were not visible. Remember to turn UAC back on if you did this temporarily.

But the bigger issue was that Report Builder 3.0 would not launch, even after I got the button back on the screen. The message was that I needed to install the .NET Framework 3.5, even though I already had .NET Framework 4.0 installed. Nothing I did seemed to fix the problem.

In the end, the issue is that Report Builder 3.0 will not launch from Report Manager in IE9 unless you enable Compatibility Mode (normally used for older web sites that don't render properly in IE9) for the Report Manager web site. Once I set Compatibility Mode, Report Builder 3.0 launched as expected.

Hope this helps save someone else a bunch of time.

Regards,

Greg

Published Wednesday, April 20, 2011 5:26 PM by Greg Low

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

GrumpyOldDBA said:

It does seem to me that there's a missmash of what works with what just now. For example I was somewhat upset to discover installing VS2010 removed SQL2008R2 Bids and you can't put it back, then to discover you can't write reports in VS2010 - the fix is to install vs2008. I haven't gone IE9 yet and SSRS R2 is only in early test, but I'm grateful for your post - very useful to know, thanks

April 20, 2011 4:38 AM
 

Steve said:

Had a similar issue. It all seemed to work if I ran IE as Administrator. Not ideal I know.

April 20, 2011 5:12 AM
 

Greg Low said:

Hi Steve, the problem still occurs if you run as admin.

April 20, 2011 6:34 AM
 

Sri said:

I think it should work....Go to user account control and keep the security level off or low.

April 23, 2011 7:42 PM
 

Greg Low said:

Hi Sri, yes, but you don't want to have to run with UAC off to use RS.

April 23, 2011 10:32 PM
 

sri said:

Hi Greg, after 4 to 5 hours of research i came with that soution, that one worked for me. Im using the R2 version with windows 7. How abt you?

April 25, 2011 2:42 AM
 

Greg Low said:

Hi Sri,

Yes, I can make it work with UAC off but that's not the point. Surely the team can make a version that works with UAC on. You shouldn't have to disable the security of the whole machine to make one app work.

UAC has been with us since Vista.

Regards,

Greg

April 25, 2011 3:08 AM
 

rkrk01 said:

Thank you very much Greg,it definitely helped me. in my case i was trying to launch report builder 1 and it says .net framework 2 must be installed but i already have .net 4 installed. once i turned on comptability view it worked just fine.

April 25, 2011 5:14 PM
 

Richard said:

The compatibility view hack is probably related to the new compact user-agent string in IE9 [1].

In normal IE9 mode, the UA doesn't include the installed .NET versions, so the server can't detect whether you've got .NET installed. In compatibility mode, it sends the full UA, including the .NET versions.

[1] http://blogs.msdn.com/b/ie/archive/2010/03/23/introducing-ie9-s-user-agent-string.aspx

April 26, 2011 2:42 PM
 

Andy Brown said:

See http://www.wiseowl.co.uk/blog/s186/report-builder.htm for how to do this.  For what it's worth, I was using SSRS 2008 R2 and Windows 7.  I find that running IE as an administrator does get round some security issues.

October 31, 2011 11:25 AM

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

Tags

No tags have been created or used yet.
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement