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?
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.
14 People are following this question.
