November 5, 2012 at 10:58 pm
Hi,
I have created some reports and deploy on report server.I want that every user on LAN can access reports.
When I access reportserver an error occured
Reporting Services Error
The permissions granted to user 'Domainname\umashankar' are insufficient for performing this operation. (rsAccessDenied) Get Online Help
How to resolve this problem?
Thanks.......
-----------------------------------
My Blog[/url] | Articles
November 5, 2012 at 11:16 pm
which SQL SERVER r u using ? becoz
In SQL Server 2008 Reporting Services (SSRS), only the Report Server service account requires database access; in SQL Server 2005 Reporting Services (SSRS) SP2, both the Report Server Windows service account and the Report Server Web service account require database access.
Also ensure that server is running !!
November 6, 2012 at 3:11 am
Thanks for your quick reply.
I am using SQL server 2008 r2
more information:
Microsoft SQL Server Management Studio10.50.1600.1
Microsoft Analysis Services Client Tools10.50.1600.1
Microsoft Data Access Components (MDAC)6.1.7601.17514
Microsoft MSXML3.0 5.0 6.0
Microsoft Internet Explorer8.0.7601.17514
Microsoft .NET Framework2.0.50727.5420
Operating System6.1.7601
Thanks.......
-----------------------------------
My Blog[/url] | Articles
November 6, 2012 at 3:21 am
You need to ensure that you have set the correct permissions to the folders and reports for the users you want to grant access to.
SSRS is an explicit security system where you have to tell it who to give access to.
What security access have you granted to your SSRS web site?
November 6, 2012 at 3:29 am
in that case u should follow this link ..
http://msdn.microsoft.com/en-us/library/ms156468(v=sql.100).aspx
November 6, 2012 at 6:32 am
Is that certification topic?
November 6, 2012 at 10:24 pm
Its not a certification topic , it is related to troubleshooting of SQL SERVER reporting service as askesd by umashankar
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply