Effects: SQL Server 2005 SP2

Some of the users on our system today were unable to print from Reporting Services. After they pressed the print Icon selected a printer and then printed, the browser would just hang. It turns out the DLL that handles the client side printing RSClientPrint Class.dll fails if the SQL server has NO COUNT ON set as default.

You can check on your SQL server if this has been set by going to Server> Properties > Connections > and making sure NOCOUNT is unchecked.

If your having this problem either make sure NOCOUNT is unchecked or add  “SET NOCOUNT OFF” to the top of the Stored Procedures used by reporting services.