Отвечено An error occurred during printing. (0x80070057)

  • 1 мая 2012 г. 21:53
     
     

    Hi,

    In the report viewer, when I click on the print icon from my client's machine, i get this error:

    "An error occurred during printing. (0x80070057)"

    My client's machine's OS is Windows XP.

    This error only occurs in Windows XP. When I tried the same steps in my Windows 7 OS, the print dialog shows up as per normal and I am able to print.

    Server: SQL 2008 R2 (OS: Windows Server 2008 R2)

    Framework .Net 2.0.

    I have already updated both SQL server and my Application server to all the latest update via "Windows Update"

    When i check the error log from the server, here's what i found

    Throwing Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException: , Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> System.Data.SqlClient.SqlException: Cannot open database "ReportServer$XXX" requested by the login. The login failed.
    Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

    But why is it that I dont get this error when I print from a Windows 7 PC? This error only occurs on Windows XP PC.

     

Все ответы

  • 2 мая 2012 г. 7:16
     
     

    Can you check for pop-up blocker setting on the Win XP machine browser? Also, if possible try to run the cab file directly on the client machine and see if that works.

    Did you check for similar errors on forums?


    Chaitanya( Twitter | Blogs )

    Any documentation bug? Tell us about it at Connect. Please feel free to add any community comments in any of the MSDN/technet articles.
    This posting is provided "AS IS" with no warranties, and confers no rights.

  • 2 мая 2012 г. 10:08
     
     

    Hi Chaitanya,

    Thanks for your reply.

    As checked, pop-up blocker is not blocked.

    I have tried copying the cab file over and extracting it to the client PC.

    Problem still persist.

    Whats next?

  • 3 мая 2012 г. 4:46
    Модератор
     
     

    Hi Blurboy,

    Based on your scenario, I suggest that you try to give the user the write permission of the “C:\Windows\Downloaded Program Files” folder on the report server computer. For the detailed steps, please see the following KB article:
    http://support.microsoft.com/kb/308419#4

    If the issue persists and you are using SQL Server 2008 or a later version on the Windows XP operating system, I suggest that you upgrade to Report Viewer 2010. You can download the Microsoft Report Viewer 2010 Redistributable Package from:
    http://www.microsoft.com/en-us/download/details.aspx?id=6442

    Hope this helps.

    Regards,
    Mike Yin 

  • 3 мая 2012 г. 5:02
     
     

    Hello,

    Follow the thread below. It may help you.

    http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/3281a042-8a98-4f0f-834b-ee09bc54dc74

  • 3 мая 2012 г. 9:43
     
     

    Hi Blurboy,

    Based on your scenario, I suggest that you try to give the user the write permission of the “C:\Windows\Downloaded Program Files” folder on the report server computer. For the detailed steps, please see the following KB article:
    http://support.microsoft.com/kb/308419#4

    If the issue persists and you are using SQL Server 2008 or a later version on the Windows XP operating system, I suggest that you upgrade to Report Viewer 2010. You can download the Microsoft Report Viewer 2010 Redistributable Package from:
    http://www.microsoft.com/en-us/download/details.aspx?id=6442

    Hope this helps.

    Regards,
    Mike Yin 

    Hi,

    Thanks for trying to help me.

    May I how does giving user the WRITE permission of the “C:\Windows\Downloaded Program Files” folder on the report server can help in my case? Are we actually writing files in the Server Downloaded Program Files folder?

    My Client's PC (Win XP) is able to download the files after enabling ActiveX. Was prompted to install some SQL components thereafter. After installing, the error pops up. It just does not show the print dialogue to select printers to print.

    "An error occurred during printing. (0x80070057)"

    Just what is this error? Sigh

  • 3 мая 2012 г. 9:44
     
     

    Hello,

    Follow the thread below. It may help you.

    http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/3281a042-8a98-4f0f-834b-ee09bc54dc74

    Hi,

    Thanks for your reply.

    The solution in the link did not help either.

    Whats next?

  • 7 мая 2012 г. 9:27
     
     

    anyone able to help?

    still facing the same issue.. when printing from microsoft report viewer: An error occurred during printing. (0x80070057)

  • 7 мая 2012 г. 9:49
    Модератор
     
     Отвечено

    Hi Blurboy,

    Thanks for your posting.

    The RSClientPrint files, which are required when printing a report from the report mananger, are stored in the “Downloaded Program Files” folder. If you have not tried the suggestions provided by Jerry Nee in the thread http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/3281a042-8a98-4f0f-834b-ee09bc54dc74, please try the suggestions first.

    If it doesn’t work, please try to assign the write permission of the “Downloaded Program Files” folder to the specific user on the report server computer. The detailed steps are provided in the KB article: http://support.microsoft.com/kb/308419#4

    At this time, I have reorganized for you as below:

    1. Open C:\Windows, right-click on the “Downloaded Program Files” folder and click “Properties”.
    2. Switch to the “Security” tab, click “Edit”.
    3. In the “Security” window, click “Add” and add the specific user to the list.
    4. Check the “Allow” box for “Write” permission and click “OK”.

    Hope this helps.

    Regards,
    Mike Yin