Problem deploying a project from Visual Studio

  • SQLFanatic

    SSCommitted

    Points: 1640

    Hi,

    I am getting this error when I try to deploy a report project from visual studio.SSRS-2008 environment.

    The permissions granted to user 'Domain\username' are insufficient for performing this operation.

    I have modify/write permissions to the Reporting Services folder inside SQL server folder.

    The url http://servername/reports%5B/url%5D shows up report manager with just home folder. This is what I have set in Project properties.

    Also, I don't see home folder on report server through SSMS. Reporting services are running under local system account.

    Any ideas?? I am literally bamboozled here surfing google from quite a few hours.

    Help is Greatly appreciated. Thanks.

    ________________________________________________________________
    "The greatest ignorance is being proud of your learning"

  • Gift Peddie

    SSC Guru

    Points: 73570

    sql.techo (1/13/2010)


    Hi,

    I am getting this error when I try to deploy a report project from visual studio.SSRS-2008 environment.

    The permissions granted to user 'Domain\username' are insufficient for performing this operation.

    I have modify/write permissions to the Reporting Services folder inside SQL server folder.

    The url http://servername/reports%5B/url%5D shows up report manager with just home folder. This is what I have set in Project properties.

    Also, I don't see home folder on report server through SSMS. Reporting services are running under local system account.

    Any ideas?? I am literally bamboozled here surfing google from quite a few hours.

    Help is Greatly appreciated. Thanks.

    You need DBO permissions in ReportServerDB and ReportServerTempDB I have covered the details in the thread below.

    http://www.sqlservercentral.com/Forums/Topic831821-162-1.aspx

    Kind regards,
    Gift Peddie

  • SQLFanatic

    SSCommitted

    Points: 1640

    I do have dbo permissions on those databases. In-fact, I have sysadmin permission assigned since I installed the server.

    Initially SQL, SSRS, SSIS and SQL Agent were running under my username and then I changed all the services to run under local system account.

    I also deleted all encryted keys and backed-up the recreated ones.I can open Report Manager using IE and had my username added there with system administrator role as well.

    Still, I'm not able to deploy the reports. keep getting the freaking insufficient permission error.

    Kind Regards.

    ________________________________________________________________
    "The greatest ignorance is being proud of your learning"

  • Gift Peddie

    SSC Guru

    Points: 73570

    sql.techo (1/13/2010)


    I do have dbo permissions on those databases. In-fact, I have sysadmin permission assigned since I installed the server.

    Initially SQL, SSRS, SSIS and SQL Agent were running under my username and then I changed all the services to run under local system account.

    I also deleted all encryted keys and backed-up the recreated ones.I can open Report Manager using IE and had my username added there with system administrator role as well.

    Still, I'm not able to deploy the reports. keep getting the freaking insufficient permission error.

    Kind Regards.

    If you are running Vista you need to disable UAC and the other option is to copy your RDL and all associated solution files manually to ReportServer. You also need to find out the account used to run VS2008.

    Kind regards,
    Gift Peddie

  • SQLFanatic

    SSCommitted

    Points: 1640

    I appreciate you help truly !

    This is how my Login name properties look like.user dbo is mapped to myusername(my login)

    This is W.Server 2008. And it does have User Account Control on. VS2008 is running under Local system account.

    In the error it mentions username(same as below) to have insufficient permissions.

    Name user defaultschema

    Database1 dbo dbo

    database2 myusername dbo

    master myusername myusername

    model myusername dbo

    msdb myusername myusername

    ReportServer dbo dbo

    ReportServerTempDb dbo dbo

    tempdb myusername dbo

    Thanks,

    ________________________________________________________________
    "The greatest ignorance is being proud of your learning"

  • Gift Peddie

    SSC Guru

    Points: 73570

    sql.techo (1/13/2010)


    I appreciate you help truly !

    This is how my Login name properties look like.user dbo is mapped to myusername(my login)

    This is W.Server 2008. And it does have User Account Control on. VS2008 is running under Local system account.

    In the error it mentions username(same as below) to have insufficient permissions.

    Name user defaultschema

    Database1 dbo dbo

    database2 myusername dbo

    master myusername myusername

    model myusername dbo

    msdb myusername myusername

    ReportServer dbo dbo

    ReportServerTempDb dbo dbo

    tempdb myusername dbo

    Thanks,

    Disable UAC or the only other option is to manually deploy by doing what I posted in my previous reply.

    Kind regards,
    Gift Peddie

  • SQLFanatic

    SSCommitted

    Points: 1640

    Disable UAC or the only other option is to manually deploy by doing what I posted in my previous reply.

    I just (not so willingly) remotely restarted the server. Bingo !! it worked.

    and I'm happy as opposed to other users who have been kicked out. ! 😎

    Cheers to you.

    One more doubt. Is it normal not see home folder and reports through dropdown in SSMS unser report server? All I see is

    Jobs

    Security

    Shared Schedules

    Great Thanks @ Gift

    ________________________________________________________________
    "The greatest ignorance is being proud of your learning"

  • Gift Peddie

    SSC Guru

    Points: 73570

    sql.techo (1/13/2010)


    Disable UAC or the only other option is to manually deploy by doing what I posted in my previous reply.

    I just (not so willingly) remotely restarted the server. Bingo !! it worked.

    and I'm happy as opposed to other users who have been kicked out. ! 😎

    Cheers to you.

    One more doubt. Is it normal not see home folder and reports through dropdown in SSMS unser report server? All I see is

    Jobs

    Security

    Shared Schedules

    Great Thanks @ Gift

    That may be related to file system deployment which I don't use because I also run SSRS 2005 which requires IIS. If I find out more I will post again.

    Kind regards,
    Gift Peddie

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply