SQL Server reporting services

  • 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

  • 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 !!

  • 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

  • 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?

  • in that case u should follow this link ..

    http://msdn.microsoft.com/en-us/library/ms156468(v=sql.100).aspx

  • Is that certification topic?

  • 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