Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

deploy report - permissions are insufficient Expand / Collapse
Author
Message
Posted Wednesday, December 9, 2009 1:58 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, July 23, 2012 7:54 AM
Points: 59, Visits: 236
We hired a new person and he's been assigned a couple of reports to work on. Normally I do this, but we're spreading some work around. He is able to open the .sln file from the network file location, edit .rld files, and save them. He is able to view and run reports in the web interface. When he tries to deploy his reports frim BIDS to the server, he gets the error "Error 7 The permissions granted to user 'DOMAIN\user' are insufficient for performing this operation. \\dir\dir\dir\report.rdl.

I verified that he has modify rights to the file system location of the .rdl and project files.

I have added him as Content Manager in Properties -> Security in the Report Manager.

I have even added him as System Administrator temporarily in the System Role Assignments, but still he can't deploy the report.

I even tried elevating his permissions on the SQL Server instance that is hosting the ReportServer database.

I can deploy reports and my other coworkers in my group can deploy reports, but he can't. I know that the rest of us are members of a specific active directory group that has elevated permissions all over the place and he is not. We don't want to add him to that group yet (not my call), but we do want him to be able to deploy reports.

Can anyone suggest other places that I might need to elevate his permissions in order to allow him to deploy?
Post #831821
Posted Thursday, December 10, 2009 7:55 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, November 13, 2014 2:52 PM
Points: 3,428, Visits: 14,451
If the user is not seeing Report Manager then the person may not have enough permissions, you could ask the person to go into IE and add the Report Manager url or IP address to LAN settings. In SQL Server the person needs at least DBO permissions to the datasource database and in ReportServerDB and ReportServerTempDB. And I know in a company network you can give the person publisher to deploy the reports.


Kind regards,
Gift Peddie
Post #832243
Posted Thursday, December 10, 2009 10:17 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, July 23, 2012 7:54 AM
Points: 59, Visits: 236
Thanks for the reply.

The user can see and execute reports in Report Manager. So I need to elevate the users permissions on the ReportServer, and ReportServerTempDB databases?
Post #832401
Posted Thursday, December 10, 2009 10:42 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, November 13, 2014 2:52 PM
Points: 3,428, Visits: 14,451
Jay_Noob (12/10/2009)
Thanks for the reply.

The user can see and execute reports in Report Manager. So I need to elevate the users permissions on the ReportServer, and ReportServerTempDB databases?


I think you do because I have used DBO permissions to create and deploy reports, the other deployment option is to copy all the files associated with the reports including solution file to Report Manager.


Kind regards,
Gift Peddie
Post #832419
Posted Thursday, December 10, 2009 11:58 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, July 23, 2012 7:54 AM
Points: 59, Visits: 236
Thanks Gift Peddie, giving him permissions on reportserver AND reportservertempdb was exactly what I was missing.
Post #832485
Posted Thursday, December 10, 2009 12:31 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, November 13, 2014 2:52 PM
Points: 3,428, Visits: 14,451
Jay_Noob (12/10/2009)
Thanks Gift Peddie, giving him permissions on reportserver AND reportservertempdb was exactly what I was missing.


I am glad I could help.



Kind regards,
Gift Peddie
Post #832507
Posted Friday, October 4, 2013 4:32 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, October 5, 2013 12:23 AM
Points: 3, Visits: 3
Hi,

I have similar problem but I cannot solve it yet :P

In this post I also have requested help. http://www.sqlservercentral.com/Forums/Topic1313683-357-1.aspx?Update=1

I connect to my database server and go to Security-> Logins -> Left click on my user and properties.
On user assignments or roles (I don't have english installation), I have assigned:

Database: master user: my user default schema: my user
Database: msdb user: my user default schema: My user
Database: ReportServer User: dbo default schema: dbo
Database: ReportServerTempDB user: dbo default schema:dbo

I also have adde my user as Browser, Content Manager, My Reports, Publisher, Report Builder on my Report server configuration. And I also have my user as: System Administrator, System User on Configuration Manager.

I've followed this todo: http://www.gotknowhow.com/articles/reportserver-permissions-granted-are-insufficient-for-performing-this-operation-rsaccessdenied

But I cannot deploy the report yet.

Any Idea?

Thanks in advance for your help.
Post #1501514
Posted Friday, October 4, 2013 10:01 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, November 13, 2014 2:52 PM
Points: 3,428, Visits: 14,451
Reporting Services permissions are not related to the Master DB or MSDB, but you need to give dbo permissions in the datasource db, ReportServerDB and ReportServerTempDB. If security will not allow that tell the DBA the deployment will not work.

Kind regards,
Gift Peddie
Post #1501662
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse