question

DCSS avatar image
DCSS asked

Deploying a report in SQL Server 2008r2 not enough permissions

I cannot deploy a report nor the project because I keep getting the error The permission granted to user 'KCDCSS-SQL\EContacts' are insufficient for performing this operation. The Report Server is on the same server as SQL Server 2008r2 EContacts is a user on the server as an Administrator EContacts is a user on the SQL Sever with SysAdmin rights and a user for the ReportServer and ReportServerTempDB tables with the recommended permissions. EContacts is also set up in the Report Server Site Settings as a System Administrator Using Report Services on this server with this version of SQL Server is new. I do have an SQL Server 2005 Reporting Services on another server that works with no problem. I have tried those settings on this 2008r2 server with no luck. I have read lots of postings on various forums and tried everything I find with no luck. I am stumped. Can anyone provide any advise which will be very much appreciated?
sql-server-2008reporting-services
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Can you connect to reporting services using SSMS? How are your permissions set up (right click on reporting services instance in SSMS and select "Properties")?
0 Likes 0 ·

1 Answer

·
DCSS avatar image
DCSS answered
Thanx KenJ I went through all my permissions on Friday and found that I had not set permission on the Folders on the Report Server. I had set them on the site and thought that would do it. First time setting up Reporting Services. Once I set the permission for EContact in the Folder Security settings I was able to deploy the report. I then went back and revisited all the security and permission settings in SSMS, Reporting Services and Windows to pull back some of the admin settings I had given EContacts. I have a better understanding of all of this. Thanx again for your response.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.