question

Mircea avatar image
Mircea asked

Error printing from Report Viewer

Hello,

We have a report server configured in Sharepoint integrated mode (SQL Server 2008). I designed a report that can be viewed using Microsoft Report Viewer 2008 (SP1). Works fine. The problem appears when we try to print and Preview the report.

  1. For some reason once I click on 'Preview' button I am asked to enter credentials. My LAN ID does not work but some other account seems to be ok. This is weird as my understanding is that it does not ask for an authentication on the domain but for some server (SQL Server box) authentication??

  2. Once I enter the credentials using a service account and I print, I get the following error: An error occurred during printing (0x8007F303) but the report is printed anyways. I did a lot of search about this error but nothing worked so far.

Additional information: Windows Server 2003 SP2 (64 bit), Sharepoint 2007 SP2 (64 bit), SQL Server 2008 SP1 (64 bit), Report Viewer 2008 SP1, .NET Framework 3.5 SP1

Any help will be greatly appreciated, M. Rusu

sql-server-2008ssrsreport-viewer
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

3 Answers

·
Mircea avatar image
Mircea answered

Thanks everyone for taking the time to answer my question.

I didn't try these solutions yet as we found the following: It is a client browser setting: Internet Options -> Privacy -> set it to 'Low" and the issue goes away!

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

sp_lock avatar image
sp_lock answered

You may need to try and reinstall .net 3.0 sp1 (or latest SP).

Had a similar issue and the post below pointed me in the right direction.

http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=307315

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Michael Villegas avatar image
Michael Villegas answered

It happened to me once but with SSRS2005 and all I needed to do was add the accounts which had that problem to the report manager in the security option of the folder that contained my reports, and that was it.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.