Solved

Report Viewer Print Client: Local Admin Rights required for install

Posted on 2011-03-18
5
1,848 Views
Last Modified: 2012-05-11
We recently consolidated our SQL Servers. One which was Reporting Server for CRM. Earlier, we were able to install the Report Viewer Print client at the very first pop-up window and move on. However, now after the consolidation, the users receive the client install pop-up every time they choose the print icon within CRM.

Of course we don't want to give all these users admin rights (already tested Power Users but no that did not work either). The SQL Server is in Local Intranet security setting for Internet Explorer and everyone uses IE8. We enabled the ActiveX settings within custom level of Local Intranet however no success.

All workstations are running Windows 7 Pro, SQL Server is 2008 SP2, and CRM is 4.

Any help would be much appreciated.
0
Comment
Question by:llib21
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 10

Accepted Solution

by:
Jeff Wight earned 500 total points
ID: 35199044

Unfortunately, you have to install the print control the first time, and the only way I have found to do it to either log in to the PC with local admin rights or to use runas to run IE as a local admin, browse to a report url, and install the control.

I haven't tried it, but this might help:
http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/799e7c86-1d2d-445f-9b18-687c1474e0a7

From that article:

"My scenario is I'm using SQL 2008 SP2, VS2008, .NET 3.5, CRM 4.x and when I upgraded to SP2 is when I started to have this problem.  What I did was deleted all the RSClientPrint*.* files (13 rll files, 1 inf and 1 dll) from the Windows\System32 folder and installed the ReportViewer2010 Redistributable on the SQL Server.  Went back and tried to print a report and it installed and worked like a charm."

The new report viewer package is available here:
http://www.microsoft.com/downloads/en/details.aspx?displaylang=en&FamilyID=a941c6b2-64dd-4d03-9ca7-4017a0d164fd

0
 

Author Comment

by:llib21
ID: 35199371
JD,

We've been trying many different things on the client side but have not thought of the server until now. Our normal way of installing the client was have the person try to print and let the system prompt for sysadmin credentials. We jump in and put in the admin credentials and run the print control again to install the client. We only needed to do this once and it was done. However, that does not seem to be working.

We will follow your second suggestion and get back to you.


0
 
LVL 101

Expert Comment

by:mlmcc
ID: 35473639
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

On Sep 22nd 2014 Microsoft released Update Rollup 1 for Microsoft Dynamics CRM 2013 Service Pack 1 and back in July Update Rollup 3 was released.  So we now have:   Update Rollup 1Update Rollup 2Update Rollup 3Service Pack 1Update Rollup 1 for S…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

717 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question