January 13, 2010 at 8:23 pm
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"
January 13, 2010 at 9:22 pm
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
January 13, 2010 at 9:49 pm
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"
January 13, 2010 at 10:01 pm
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
January 13, 2010 at 10:12 pm
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.
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"
January 13, 2010 at 10:16 pm
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 defaultschemaDatabase1 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
January 13, 2010 at 10:43 pm
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"
January 13, 2010 at 11:07 pm
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 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply