Ошибка служб reporting services rsaccessdenied - Ремонт и установка крупной бытовой техники

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	ms.custom	helpviewer_keywords
rsAccessedDenied — Reporting Services Error	In this error reference, learn about ‘rsAccessedDenied’: The permissions granted to user ‘mydomainmyAccount’ are insufficient for performing this operation.	maggiesMSFT	maggies	05/22/2019	reporting-services	troubleshooting	conceptual	updatefrequency5	rsAccessDenied error

rsAccessedDenied — Reporting Services error

The [!INCLUDEssRSnoversion] error rsAccessedDenied occurs when a user does not have permission to perform an action. For example, they don’t have a role assignment that allows them to open a report, or they didn’t open their browser with the required permissions.


[!INCLUDEapplies] [!INCLUDEssRSnoversion] Native mode \| SharePoint mode

If the error occurred while accessing the report server directly through a URL, the exception is mapped to an HTTP 401 error.
If the error occurred while using the web portal, the exception is typically mapped to an HTTP 401 error, or other defined HTML error page.
If the error occurred during a scheduled operation, subscription, or delivery, the error will appear in the report server log file only.

Details

Detail	Value
Product Name	[!INCLUDEssNoVersion]
Event ID	rsAccessedDenied
Event Source	Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings
Component	[!INCLUDEssRSnoversion]
Message Text	The permissions granted to user ‘mydomainmyAccount’ are insufficient for performing this operation. (rsAccessDenied) (ReportingServicesLibrary)

User action

Permission to access report server content and operations are granted through role assignments. On a new installation, only local administrators have access to a report server. To grant access to other users, a local administrator must create a role assignment that specifies a domain user or group account, one or more roles that define the tasks the user can perform, and a scope (usually the Home folder or root node of the report server folder hierarchy). You can use the web portal to create role assignments. For more information, see Role Assignments
.

This error is also caused by local administration of the report server. For more information, see Configure a Native Mode Report Server for Local Administration (SSRS).

 public class ReportServerCredentials : IReportServerCredentials   
{
    #region  Class Members
        private string username;
        private string password;
        private string domain;
    #endregion

    #region Constructor
        public ReportServerCredentials()
        {}
        public ReportServerCredentials(string username)
        {
            this.Username = username;
        }
        public ReportServerCredentials(string username, string password)
        {
            this.Username = username;
            this.Password = password;
        }
        public ReportServerCredentials(string username, string password, string domain)
        {
            this.Username = username;
            this.Password = password;
            this.Domain = domain;
        }
    #endregion

    #region Properties
        public string Username
        {
            get { return this.username; }
            set { this.username = value; }
        }
        public string Password
        {
            get { return this.password; }
            set { this.password = value; }
        }
        public string Domain
        {
            get { return this.domain; }
            set { this.domain = value; }
        }
        public WindowsIdentity ImpersonationUser
        {
            get { return null; }
        }
        public ICredentials NetworkCredentials
        {
            get
            {
                return new NetworkCredential(Username, Password, Domain);
            }
        }
    #endregion

    bool IReportServerCredentials.GetFormsCredentials(out System.Net.Cookie authCookie, out string userName, out string password, out string authority)
    {
        authCookie = null;
        userName = password = authority = null;
        return false;
    }
}

while calling SSRS Reprots, put following piece of code

 ReportViewer rptViewer = new ReportViewer();
 string RptUserName = Convert.ToString(ConfigurationManager.AppSettings["SSRSReportUser"]);
        string RptUserPassword = Convert.ToString(ConfigurationManager.AppSettings["SSRSReportUserPassword"]);
        string RptUserDomain = Convert.ToString(ConfigurationManager.AppSettings["SSRSReportUserDomain"]);
        string SSRSReportURL = Convert.ToString(ConfigurationManager.AppSettings["SSRSReportURL"]);
        string SSRSReportFolder = Convert.ToString(ConfigurationManager.AppSettings["SSRSReportFolder"]);

        IReportServerCredentials reportCredentials = new ReportServerCredentials(RptUserName, RptUserPassword, RptUserDomain);
        rptViewer.ServerReport.ReportServerCredentials = reportCredentials;
        rptViewer.ServerReport.ReportServerUrl = new Uri(SSRSReportURL);

SSRSReportUser,SSRSReportUserPassword,SSRSReportUserDomain,SSRSReportFolder are defined in web.config files.

Источник

Remove From My Forums

Question
I am an administrator on our Reporting services 2012 server. And I assume a member of BUILTIN/Administrators in RS.

I can access the reporting service url but I cannot deploy projects or reports or data sources.

I get the message in title.

win server 2012, sql server 2012

Answers

Resolution.

I now just have to work out how to set up Data Tools to always open with elevated permissions.

Thanks to Qiuyun for pointing me in the right direction.
If you installed SQL Server Data Tools — Business Intelligence for Visual Studio 2012 on one of the operating systems listed in the first section of this topic, and you want SSDT to interact with
a local Native mode report server, you will experiences permission errors unless you open SQL Server Data Tools (SSDT) with elevated permissions or configure reporting services roles. For example, if you do not have sufficient permissions, you experience issues
similar to the following:
- When you attempt to deploy report items to the local report server, you see an error message similar to the following in the Error List window:
  
  The permissions granted to user ‘Domain<user name>’ are insufficient for performing this operation.
To run with elevated permissions each time you open SSDT:
1. From the start screen, type sql server and then right-click SQL Server Data Tools for Visual Studio. Click Run
  as administrator
  
  Or, on older operating systems:
  
  From the Start menu, click All Programs, click SQL Server 2014, right-click SQL
  Server Data Tools, and then click Run as administrator.
2. Click Continue.
3. Click Run Program.
You should now be able to deploy reports and other items to a local report server.

To configure Reporting Services role assignments so you do not need to start SSDT with elevated permissions each time:
- Edited by
  
  Friday, August 14, 2015 2:43 AM
- Marked as answer by
  ghw123
  Friday, August 14, 2015 2:43 AM

Источник

by Francis on 8/15/2010

Great, this finally fixed my problem after a few hours of searching. Pretty incredible that when you install SSRS 2008 from scratch, one has to do all of this when I installed SQL 2008 with an admin account.

by Doug on 8/15/2010

Francis,

I agree, setting up SSRS could and should be much easier… I can’t tell you how much time I’ve spent just trying to get Reporting Services to run correctly. It’s nice once it’s working for you, but getting it setup properly is a huge pain.

by Freese on 8/25/2010

Thanks. Fixed my problem.

by james on 10/13/2010

i don’t see the properties part in the report manager page. it’s all blank underneath home. how would you make it show up? i just installed it in windows 7 with SQL Server 2008

by Anonymous on 11/15/2010

@james

I think you are using Firefox.or any browser which is not related with Microsoft. Use IE it will be solved..I think it will help you..Thank you

by Mr Mostard on 1/4/2011

@james
In my case the button is called «Folder Settings» instead of «Properties» (SQL 2008R2).

@doug
Thanks, this one saves me a couple of hours!

by jack on 1/27/2011

great solution..now I can deploy my report to Report server.
thanks

by frinkfree on 2/25/2011

Awesome. Your detailed steps solved the problem. thanks

by Madhu on 6/10/2011

Really Great User Guide..!!

Thanks for your work done man..

by Jacek on 6/21/2011

Thanks. Nice, simply, precise solving.

by Kathy on 7/21/2011

Thanks a lot. It fixed the problem.

by Lenrog on 7/27/2011

Hi will this fix work if my 2008 Report server is in SharePoint Integrated mode?

by Andy on 8/29/2011

Thanks Doug..

by Sudheshna Koroth on 9/2/2011

Thank you , it worked

by Moazzam on 9/20/2011

I am using SQL treporting under sharepoint hence it is in sharepoint 2010 integrated mode, when i go to the report URL http://localhost/Reports/Pages/Folder.aspx , i get

This operation is not supported on a report server that is configured to run in SharePoint integrated mode. (rsOperationNotSupportedSharePointMode) Get Online Help

Please guide

by Mortaza on 2/8/2012

Thank you, this helped me a lot!

by Mansvi on 2/9/2012

It’s not working,giving the same error again.

I am working on Windows XP computer with SQL Server Reporting Services 2005.

Please help.

Thanks In Advance

by Austin on 2/21/2012

I tried this, but it didn’t work. Probably because, in our case, we migrated our report server from 32 bit Windows Server 2003 to 64 bit Windows 2008 r2 standard. I was very hopefull and have added all the roles for my account and still no good.

by austin on 2/21/2012

Oops, forgot to mention it also went from SQL 2005 to 2008 r2.

by rob on 3/23/2012

SQL Server 2008 R2. This is killing me. The only thing that doesn’t work for me is remote access to the report server. I’ve been looking for answers on this since yesterday. I wish I would get an error message or something, anything, any info. Just says IE cannot display the webpage. over and over and over again. I can access it on the actual server and I’ve followed every tip and instruction I can find on users/groups. I’m at a loss right now. The port is open and listening… ARRRGGHHA!!1

by daleofcourse on 4/18/2012

Thanks for that, I’d set the overall site settings but I must have created my report folder first so it only had the BUILTIN/Administrators group assigned, adding the correct group to the Folder Settings sorted this problem.

by Satty on 5/14/2012

Thnx so much ..its worth

by Ernst on 5/23/2012

Thank You! I am using SQL Server 2008 R2. The New Role Assignment was under «Folder Settings» in the Home page (as oposed to the Properties tab).

by Yousef on 6/9/2012

Great,I’ve been trying to get it fixed for 3 days and now i’ve managed to do it.Many thanks

by Rupesh on 6/17/2012

Thanks,I Had been trying the same from last 2 days..

by puneet on 6/20/2012

thanks for your article…i had a hard time figurin out why my reports are not deploying…your’s article resolved my problem…..

by Matty G on 6/28/2012

Out of all the multiple social.msdn links that show up in google for this issue, yours was the only one that worked! Thanks so much!

by Doug on 6/28/2012

@Matty G — Glad to hear this was the article that got things working for you!

by Guillaume on 7/11/2012

Thanks. This saved my ass after my boss asked me to investigate other options than Crystal reports. None of the MSDN links have a good Step-by-step tutorial like yours.

by fiylm on 7/26/2012

Many thanks for your tutorial that resolves

by Raja on 8/3/2012

Very Helpful!!!!!!!!!!!!!!!!!! Thanks for your help in posting

by Han on 8/10/2012

Hi Doug,

Thanks a lot. Very helpful user guide. It’s working.

by mahmoud on 8/11/2012

thank you a lot it was driving me crazy and now it is solved.

by Anonymous on 8/29/2012

thank you so much.. it resolved my issue.

by Manoj on 9/7/2012

Thanks a lot!!! It worked fine for me from your recommendations..

by Komala Sampathkumar on 10/17/2012

Your post was very helpful. I fixed the issue in few minutes. Thanks a lot!!

by Anonym1 on 10/18/2012

**************** If you do NOT see the «site settings» on report manager page, refer to the following link **********
http://blog.davyknuysen.be/2009/09/11/administrator-has-no-access-to-the-report-manager-sql2008-r2-and-windows7vista/

by Unknown on 10/19/2012

Thank you very much,it helps a lot.

by Tony Rodriguez on 10/30/2012

much helplful, thanks!!!

by Jolande on 11/13/2012

Thanks for the help

by link01 on 11/15/2012

Thanks! I was sick of configuring things trying to do this

by M. Scholten on 11/25/2012

Thanks a bunch; you just helped me a lot!

Grtz

by Ed on 11/29/2012

Thank you for sharing your knowledge. Many thanks and regards.

by Asad on 11/29/2012

great man !!! solved my problem

by SOMEONE on 2/1/2013

very very usefull sir thanks

by Aman Gupta on 2/6/2013

I have done all the steps mentioned by you…
But reports are running from Administrator account only not from other users…

Please help…

by sai ram on 2/14/2013

nice post

by pp on 3/6/2013

thanx

by Indrashish Saha on 3/14/2013

Thanks a ton

by trl on 3/14/2013

Many many thanks

by Adnan on 3/21/2013

Great work!!! Thank mate

by wsocha on 3/27/2013

Thank you for the step by step instructions. Installed to SQL 2012 with VS 2010. Screen shots are a bit different, but once I gained access using IE running as administrator, I was able to add my local admin account with full privileges. I can now access with Chrome.

by Ani on 4/4/2013

Thanks man….

by Nadhamuni Pedisetty on 5/2/2013

Your details explanation to solve the issue helped a lot and resolved the issue
Thanks

by Rajeev Kumar on 5/28/2013

It is very helpful article. I got resolved my issue. Thanks for the help.

by Hartmut on 6/11/2013

Thanks for the step by step instruction.

by Harish on 6/15/2013

Awesome…thanks a lot….
After 2 weeks googling , finally i am able to configure report server on my local machine or personal laptop you can say…
but this applicable for IE not for google chrome
THANKS A LOT……BIG HUG

by Simon Kingston on 6/20/2013

You sir, rock! Thanks for taking the time to post such detailed steps. btw, on step 5, I had to click Folder Settings rather than Properties.

by Lucy on 6/26/2013

you’re awesome! this resolved my issue!
thank you!!

by Gregor on 8/21/2013

you’re a life saver…

by Roji on 9/21/2013

Good, finally i was able to solve my report publishing issue

by Manolo on 10/3/2013

I followed all the steps in this tutorial (amazing, thanks), but when I go to Visual Studio-> right click, Deploy, always appear the popup window with username and password. I use the correct account name (the same as I configured in previous step), but I can’t deploy the report, always show the same error

Any idea?

Thanks,

by Prashant T on 11/19/2013

Helpful article. I got my problem fixed following he steps .
Thanks..

by Paul on 11/29/2013

Even having been through SSRS configuration a number of times, I still need to Google this stuff. Thanks for the posting, I think the key thing is that it seems to be the individual user that needs to have access. Just being a member of a group that has the role defined doesn’t necessarily seem to cut it. Either way, the steps worked for me this time…

by Doug on 1/14/2014

I agree with Paul, it does not work if you try and use a security group from your windows AD. I had to enter each person individually. This became an issue when moving SSRS from a Windows 2008 standard server to a Windows 2008 R2 64 bit server. Don’t know if it is related but that is the only difference.

by Jeff on 1/14/2014

Excellent article. Fixed me right up. For once it was nice to have to dig through a ton of documents to the answer I needed.

by Ellen on 1/30/2014

I have windows 8.1 and I can’t follow this … Please help with a fix in Windows 8.1?

by Nishant on 2/24/2014

Hello Doug,
i’ve been trying to resolve this problem for over 1 week now (more than 60 hours) and havent been able to proceed any further.

Often webpages i come across ask me to make some config changes from Report Manager web interface (which i can not open) and this tutorial/steps is the best i’ve found, but I can go so far as 2nd step only.

The browser doesn’t redirect as mentioned on the steps.

Additional Info —
BIDS for report,
SQL Server 2012

Service Account (in Configuration Manager) -> Use built in account -> ReportServer$SQLEXPRESS

Web Service URL (Virtual Dir):
ReportServer_SQLEXPRESS

Report Manager URL:
http://user-pc/Reports_SQLEXPRESS
http://localhost:80/Reports_SQLEXPRESS

by Vikas on 2/25/2014

Great Work
It solve problem

by Cloudsion on 5/14/2014

Worked Great! Now I got the next error when I try to connect. sql server express 2014 ssrs report «A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 — Could not open a connection to SQL Server)»

by Hugo on 6/10/2014

Great! after 1 day of test and error!
The problem was for localhost!!!

by Thank you on 7/26/2014

You Sir are a genius

by Ashok Kumar on 8/4/2014

Great, Very nice solution for me ,Thank you !

by Jaysys on 10/2/2014

My issue is that the SSRS is in a different domain and when I go to the reports web site, IE or any browser seems to be using my cashed credentials, so I get that error msg listed in this article, so how do you get SSRS to prompt you instead of just using my current log in? Surprise no one has brought that up in this thread… I’m logged into domain X, domain Y has my SSRS server. But every time I go to SSRS website in domain Y, it errors out and says user in X doesn’t have permission. I want it to prompt for a user name so i can use my Y domain user. Domain X and Y do not have a trust and are completely separated.

by Krishna on 1/24/2015

You are Great!That solved my problems.Thanks a lot!

by Marius on 5/12/2015

It helps me a lot. Thank you

by David on 6/24/2015

Thanks for the help.

by Stig on 7/27/2015

Still works on SQL2012 Thanks, and thanks for the comments also, those actually helped understanding also

by killi on 8/18/2015

Thank you. This helped to solve my problem.

by piccolo on 4/30/2016

This still work in SQL2014.
Thanks a lot. I have been fighting this silly issue for days…

by YJobira on 5/17/2016

Thank you very much!. After many hours of searching and frustration, I was be able to use your information to fix my issue as well as better understand why the problem was happening-not having the right permission. Thanks

by hang on 8/11/2016

Thanks.

by Guillaume on 9/15/2016

Thanks Guy!
That solved my problem after searching many hours on Microsoft Helps!

by MrBoulier on 7/15/2017

many thanks to you !!!!! But i don’t thank microsoft at all ! So many hours spent for this problem never documented by micro$oft !

by Ultra on 7/10/2018

Thank you! I have been trying to get report server working from long time..

by CITG on 8/8/2019

Thanks, excellent

by RA_T on 3/10/2022

Thanks it worked for me

by N03L on 7/21/2022

I know this is really old and if anyone is still using SharePoint 2010 with SQL(SSRS) 2008R2, I feel for you but just in case, I found that the fact that my datasource, RSDS file, not being approved was causing users with Read permission to the report and data connection library was the reason for the same error.
Approving the RSDS file solved the users issue.

by Tod on 12/21/2022

Well I am running Windows 11 and Internet Explorer is not available it is replaced by Edge. The fix above doesn’t work in Windows 11 so how to get access to Reporting Services on Windows 11 is unclear…

Источник

Remove From My Forums

Question
Hi everyone,

I installed Windows 7 ultimate and use reporting service 2008 .
i create a report when i try to deploy it i get this Reporting Services Error:

Error rsAccessDenied : The permissions granted to user ‘Toma-PCToma’ are insufficient for performing this operation.

and when i open http://localhost/Reports/Pages/Folder.aspx i found that there is no «Content» or «Properties» Tab

how can i deploy this report and why the 2 tabs not exist

plzzzzzzzzzz any one help me

fatma

fatma mohamed

Answers

Hi,

Try to run the BIDS under Administrator account. By default, Windows 7 uses adminitrator account for SQL installation and local account for running BIDS. By default, Reporting Services would grant local administrator as SQL admin, but your local account wouldn’t. So you haven’t privilege to depoly the reports.

Thanks.

Yao Jie Tang -Microsoft Online Community
- Marked as answer by
  
  Wednesday, February 3, 2010 2:37 AM
Go to All Programs -> Microsoft Sql server 2008 -> Micrsoft BIDS
Right Click and Run it as Administrator. and see if it works.

~~ Mark it as Answer if you find it correct~~
- Marked as answer by
  fatma2
  Wednesday, February 3, 2010 9:11 PM
Ok I finally found a solution

instead of accessing Report Manager with http://localhost/Reports i moved to http://[MachineName]/Reports and added this URL to trusted web sites on IE…
He always asking to fill username and password but this is working fine.

Try the same fatma2 i am sure this will be ok after that !

Stephan
- Proposed as answer by
  Stéphane Guilleminot
  Friday, January 22, 2010 4:10 PM
- Marked as answer by
  Tony Tang_YJ
  Wednesday, February 3, 2010 2:37 AM

Источник

rsAccessedDenied — Reporting Services error

Details

User action

See also

Question

Answers

Question

Answers