?
Solved

Report Viewer not working on remote site

Posted on 2011-10-20
1
Medium Priority
?
283 Views
Last Modified: 2012-05-12
Hi experts,

I have created a web site with Visual Studio 2010 using the ReportWebsite template for C#. I have then added a server report (a report that resides in an SSRS 2008 reporting server that I have access to) to the default Report Viewer element on the main page.

This works fine when I test on my machine (I can see the report on the browser, embeded in the web page).

However, after I copy the website to my hosting provider, I stop weeing the report. The error message is the following:
 
"The permissions granted to user 'SKNETMASTER\SKNET148$' are insufficient for performing this operation. (rsAccessDenied) "

Anyone knows where I need to set the permissions?

Thanks in advance and regards.
0
Comment
Question by:robespierre_2010
1 Comment
 
LVL 29

Accepted Solution

by:
sammySeltzer earned 2000 total points
ID: 37006021
This is got to be permissions issue. Usually when I build the report, I use the connection strings I set in web.config.

This way, before deploying, I compile my app and it will have the correct connection strings.

Try these links:

http://stackoverflow.com/questions/132812/the-permissions-granted-to-user-are-insufficient-for-performing-this-operation

http://www.developmentnow.com/g/115_2004_9_0_0_451379/rsAccessDenied-for-every-non-local-admin.htm

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=86285


0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …

850 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