SQL Server Performance

Can not deploy my report

Discussion in 'SQL Server 2005 Reporting Services' started by georgej, May 15, 2007.

  1. georgej New Member

    Hi,

    I create a report by using Visual Studio.
    When I tried to "deploy report", I got the error:
    "Deploying tohttp://server01/ReportServer
    Error rsAccessDenied : The permissions granted to user 'server01IUSR_server01' are insufficient
    for performing this operation."

    Are there any recommendation or suggestions to help me to fix this error?

    Thanks for your help!
  2. satya Moderator

    As per the error message the first thing to check is privileges for IIS user on the SQL server.

    In Books Online, there's a topic called "Configuring Security Through Role Assignments" that should explain the vaious pemermissons and what they're useful for.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Share This Page