Request a topic or
Contact an Arke consultant
404-812-3123
SQL Server 2005 Reporting Services on Vista x64

Arke Systems Blog

Useful technical and business information straight from Arke.

About the author

Author Name is someone.
E-mail me Send mail

Recent comments

Disclaimer

The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.

© Copyright 2009

SQL Server 2005 Reporting Services on Vista x64

Recently I was working on a project that called for Reporting services, and I ran into a couple of annoying issues with using it on Vista (x64, not sure if it behaves similarly on x86 versions). 

 

The first issue I ran into was setting up the Reporting Services server with SQL Server Express 2005 Advanced and IIS 7.

 

Basically if you're trying to set up the Reporting server with Integrated security, don't.  It doesn't work.

You need to install SQL Server 2005 in mixed mode.  You'll need to create a SQL User for logging into the reporting services databases.  And when you configure reporting services for IIS 7, use this user for your SQL connection.   You can leave your .config files for the web site as user Impersonate, as long as that user has access to the reporting services directories.

 

 

The Second issue is with using the Report Viewer with Visual Studio 2008.  I don't know if this is an issue with other configurations, but I ran into it when I was using forms authentication.

 

You need to include a security exclusion for the ReportViewer, else VS 2008 will CRASH when trying to run a report.

 

Here is the Security config line I used.  Modify as needed.

<location path="Reserved.ReportViewerWebControl.axd">
    <system.web>
        <authorization>
            <allow users="*"/>
        </authorization>
    </system.web>
</location>

 

kick it on DotNetKicks.com

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Posted by trenton adams on Sunday, January 27, 2008 6:38 PM
Permalink | Comments (3) | Post RSSRSS comment feed

Related posts

Comments

Busby SEO Test us

Monday, January 19, 2009 6:18 AM

Wow just found out about this

cute panda webkinz us

Monday, February 02, 2009 1:59 AM

Yeah, me too.

panda webkinz us

Wednesday, February 04, 2009 4:05 AM

Thanks for sharing.

ricky us

Saturday, May 09, 2009 7:04 PM

thank you

robert us

Wednesday, June 10, 2009 11:07 PM

thanks for shared

Add comment


 

  Country flag

[b][/b] - [i][/i] - [u][/u]- [quote][/quote]



Live preview

Friday, July 03, 2009 9:12 PM