.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

User does not have required permissions to view Report Manager on SQL 2008 r2

Posted By:      Posted Date: September 16, 2010    Points: 0   Category :Sql Server
Hi all, We are installing SQL Server 2008 r2 onto a server, and this installation includes Reporting Services. SSRS works, I can deploy reports, use Report Manager, Report Builder, etc., all using my admin privs. The problem is when NON-ADMIN users connect to \\server\reports.  They get the following error: User 'DOMAIN\user' does not have required permissions.  Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed. This error is resolved by giving the DOMAIN\user account local admin privs on the server. Granting admin privs is not a solution.  We have accountants and other non-technical people that will use Report Manager and Report Builder.  We can't just give every person admin privs on the production SQL server. I have done a lot of research on the web... I see a results involving earlier versions of SQL Server and Report Manager, but this is 2008 r2 - different webserver, etc. How can I resolve this issue?

View Complete Post

More Related Resource Links

SSRS 2008 Custom Authentication works when using ReportServer url but not when report manager url is

Hi, I am using SSRS 2008 with Custom security extension for authentication. The extension is developed in c#. I have placed the dll under report server bin and report manager bin directory and the logon,login pages under appropriate directory. My reports manager url is http://localhost:port/Reports and my reports server url is http://localhost:port/ReportServer. When I try to login through reports manager url, I am getting 'login failed' error message from the dll. But when I try to login using reports server url, it works. I have also set 'FullTrust' named permission set in RSMgrPolicy.config . <CodeGroup class="FirstMatchCodeGroup" version="1" PermissionSetName="FullTrust" Description="This code group grants MyComputer code Execution permission. "> < IMembershipCondition class = " ZoneMembershipCondition " version = " 1 " Zone = " MyComputer " /> Any suggestions please!   Thanks!

Create report that lists every user with permissions for each folder

I would like to have a report that will list each user with it's roles for every folder. We have a very large RS database with a lot of folders, we need some better way to keep track of permissions. I created a report that utilizes "GetPolicies" from http://localhost/reportserver/ReportService2005.asmx but I have to feed a folder name to get list of users. I can also (by using subreport) list all folders with users. However, I am not able to produce a report where I have it broken by user. any idea?

SQL 2008 External access returns wrong address for Report Manager

Hello, I have problems with the external access for report server. My report server is running in a local server on port 80, which can be accessed through http://servername/reports I have set up external access to the report server through http://servername.domain.com:8081/reports , so I set up a redirection from public port 8081 to port 80 on the local server. When I write the address http://servername.domain.com:8081/reports in a browser, I get asked for user authentication(Windows domain user), which is accepted, but after that I get an error because the URL automatically changes to http://servername.domain.com/Reports/Pages/Folder.aspx (without the port 8081) If I write http://servername.domain.com:8081/Reports/Pages/Folder.aspx , it works. I can see the report manager home page and browse through my reports. But there are some links in the page that are built improperly, since they still point to the wrong URL (without port 8081). These are e.g. the Help link, the Report Builder link, the Details view link.  So I think there is something wrong with the response the report server sends, when I write ".../Reports" and returns ".../Reports/Pages/Folders.aspx" I haven't found any configuration file or property where this response is specified, neither where the report

SSRS 2008 - report manager: System.Net.WebException: Unable to connect to the remote server

I have an instance of Reporting Services 2008 running on Windows 2003 server.  So, the webservice URL is running on port 801, and runs fine (I can browse reports from that directory, and upload / deploy new reports and overwrite existing reports. Report manager is set to use port 800 (IIS is also on that machine running port 80).  When I attempt to connect to report manager, I get the following error, with a link to "Home" in report manager (which brings me back to the existing error page):    Unable to connect to the remote server  In the logfiles for reporting services, the following error is there: " System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it.   Any ideas? Windows Firewall is NOT running on this machine.   Thanks, Chrisrjp

Report Manager Security: If a user login to Report Service than he should be able to see only a fold

Report Manager Security: If a user login to Report Service than he should be able to see only a folder for which he has role assing and rest of the folder should be hidden for him. How this security i can achive with c#

Deploying SSRS Reports from Visual Studio 2010 to Report Manager 2008


Our Report server is using Report Manager 2008. Previously I would load reports to it that I created via BIDS. Now I have to use VS 2010. I see that I can build and deploy reports there. Can I send it from VS 2010 to the REport manager 2008 on the other machine? I should add that now i have to develop on laptop only before i was on the server.

If not what are my options? I recall that vs 2005 objects were not taken in Report manager 2008.

SSRS 2008 R2 After using SSL, In Report Manager new datasource link, upload file link, subscription



I have provided my setting and environment information below. My goal is to set Report Manager and Report Server URL with SSL connection so all URLs uses HTTPS (Secure connection) all the time. and remove HTTP access .

I applied following settings for this but I am getting errors. With Current Settings that I mensioned below, I am able to login into WebService URL successfully with all links working. For Report Manager URL  I logged in successfully but for some pages I am getting HTTP links instead HTTPS. It shows HTTP links for new datasource link, upload file link, subscription links so it shows blank page

I tried to look for solution and I applied but did not worked. I did some experiment with changing urls using application and manually from RSReportServer.config file but still not succedded.

Steps taken to solve problem:

  • To force to use HTTPS only, I tried to change SecureConnectionLevel = 0 to  1,2 or 3 but when accessing to Report Manager it gives 401 Authentication error.
  • If I remove http://+:80/ReportServer and tried to visit 2nd URL with HTTPS. The Web Service URL opens successfully. but Report Manager url gives me er

Track the visitors in ssrs 2008 report manager


Can any one please let me know How to track the visitors list in the SSRS 2008 report manager and count of number of visitors to that report.

Thanks in advance.

Sql server Report manager- Need Navigation view for folder as like Left to the Folder i need a + sym


Sql server Report manager- Need Navigation view for folder as like Left to the Folder i need a + symbol and if i click okn + it should show all the folders and fils in the folder

+ Columbila

If i click the + symbol it should like below

- Columbia

      - Reports





Fine-grained User Permissions, create and view with restricted edit rights


I'm running a Sharepoint 2007 installation which is slowly being rolled out through the organisation. We have a group of calendars which are shared between 14 executive PAs. I've been asked to lock down the permissions so that whilst any of the users can add items, only the user who created the item can subsequently edit this. I thought I could handle this by creating a new permission level with create and view rights only, which does what it should, however the user can now no longer edit their own appointments either.

Is there a way that I can give the item creator specific permissions on their item by default?

SQL Server 2008 Report Manager is not fully working



On Windows server 2008 R2 Enterprise Edition, we have installed SQL server 2008 R2 Reporting services and SQL Server 2008 database with Reporting services.  Both have different instances.

Now, we can work with Report manager of SQL server 2008 R2 without any issue. i.e. assignment of new user role etc. is working fine, but when we try to do same thing with report manager of sql server 2008 then its not working. No error message is being shown by the report manager when we try to assign new user a role and press OK button it doesn't show any message.


What could be the problem?





Report Server Instance not shown in SQL 2008 R2 version for Configuration Manager



I am using Windows Server 2003. I have installed SQL Server 2005 and SQL 2008 R2 version in the machine. The sql server 2008 R2 version has the instance name as SQL2008R2

I am trying to configure "Reporting services Configuration Manager" for the SQL 2008 r2. I gave the machine name and hit the Find button, I am not able to get the Report server instance name.

But when I gave the server name, i am able to browse to the folders page in the Internet explorer. so the server is available . I gave like this in the IE, and I am able to see the page:

http://Server IP/Reports_SQL2008R2/Pages/Folder.aspx

In the eventvwr, I found the following errror "The Drive:\Program Files\Microsoft SQL Server\MSRS10_50.SQL2008R2\Reporting Services\ReportServer\RSReportServer.config file failed to load. This error may occur if the XML is not valid. "

How to get the Report server instance name in the configuration manager.

Thank you

configure to use a on change event instead of click on View Report in Report Manager


Hi all,

the report manager by default requires after a users changes a value in a dropdown filter still to go all the way to the right and clik the "View Report" button. Is there a way (config..file)to update the report based on a filter value change without click  the View report button....



How to display the currently logged in user in Report Manager


I'm setting up SSRS security for active directory groups in SSRS 2008 R2--a learning experience for me--and I'm wondering if there's some way to display the logged in user at the top of every page in the SSRS Report Manager.  Is this possible?

Not only would it help me perfect my understanding of role-based security, it seems like it would be useful for the production site, too, like just about every other site does when I'm logged in.


Trouble installing SSRS 2008 R2, XP Pro SP3, can't access Web Service or Report Manager URLs


I found a great thread by Uday titled "SQL 2008 Reporting Services Win XP SP2" and worked through it, but I am still stumped.

I am using port 8080 cause this was default.  I tried changeing to 80, but it didn't help, so changed back.  IIS is using port 80 and is currently stopped.

I see both databases in SQL Server and can query while logged in as Account that is used for the service account.  SSRS is running. 

URL reservations look good in the rsreportserver.config file.  In Native mode.

While in RS Config Manger I can test database connection and it is good.  When I click the webservice URL or the Report Manger URL in the Config Manager I get errors "Web site can not be found" and "Website can not display page"  I just upgraded to IE 8.  Can't figure out what to do next.

When I use httpcfg.exe I see a URL for http://+:8080/ReportServer/   and http://+:80/Reports/.  This could be the problem.  How can I chages seconfd to port 8080?

Any help would be appreciated.



SSRS 2008 Report Manager only accessible within the server, cannot open on a different PC


How should I configure my SQL 2008 Reporting Services so that the Report Manager can be accessed outside the server.  That is, from a different machine within the same network?  Whenever I try to access the Report Manager from another machine, a prompt will appear requesting for username/password several times before a blank page is shown.

Reporting Services Configuration Details:
Service Account: Local System
Execution Account: Tried using my own login details within the domain and tried without it

Please let me know if you need any other details.  I am running out of ideas on what I can possibly do, thanks!


Content not displayed in Report Manager 2008



I have created some reports in SSRS 2008 and after that deployed it successfully to RM. But when I log in through Repor manager URL, no content is displayed over there on Home page even if it showed report deployed successfully from VS.

To me it seems dont have sufficient privileges even if i am admin on my machine. Any idea?



ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend