March 11, 2014 at 3:51 am
Hi Firends,
I am just a beginner in report service. I am trying to deploy a report. But i get the messages below.
"Error1The permissions granted to user 'Domain\user' are insufficient for performing this operation".
When I tried to open the url in web browser, the same issue is coming up.
How should I grant the permission to the user?
Any suggestions would be appreciated.
Thanks,
Charmer
March 11, 2014 at 3:55 am
Make sure you run as Administrator .!you can do by right click Business intelligence Visual studio 2010 or Sql Server Data tools and run as a Administrator..thanks
March 11, 2014 at 6:27 am
Hi Nandu,
It worked in visual studio. I am able to deploy through Sql server data tools. But when i tried through web browser, it is keep on giving me this error 'The permissions granted to user 'Domain\user' are insufficient for performing this operation. (rsAccessDenied) Get Online Help '
Could you suggest me what needs to be changed in configuration manager or some where else...??
Thanks,
Charmer
March 12, 2014 at 7:14 am
did you add yourself as a user (or admin) in the site Settings? (Site Settings top right of the report manager, then hit security).
March 12, 2014 at 9:04 am
Are you the Admin on the Report Server or just a user of SSRS ?
--
SQLBuddy
March 13, 2014 at 12:02 am
sqlbuddy123 (3/12/2014)
Are you the Admin on the Report Server or just a user of SSRS ?--
SQLBuddy
yes, I am just a user not Admin.
Thanks,
Charmer
March 13, 2014 at 12:06 am
Steven.Howes (3/12/2014)
did you add yourself as a user (or admin) in the site Settings? (Site Settings top right of the report manager, then hit security).
Hi Steve, I am not getting it. How to add a user? in Reporting services configuration manager? I could not find any settings at the top right in there...
Sorry for not able to follow you. Could you tell me how to do that please?
Thanks,
Charmer
March 13, 2014 at 12:11 am
Charmer (3/11/2014)
Hi Firends,I am just a beginner in report service. I am trying to deploy a report. But i get the messages below.
"Error1The permissions granted to user 'Domain\user' are insufficient for performing this operation".
When I tried to open the url in web browser, the same issue is coming up.
How should I grant the permission to the user?
Any suggestions would be appreciated.
What's the actual issue here ? You not being to deploy the report or someone else trying to open the report deployed by you ?
--
SQLBuddy
March 13, 2014 at 7:02 am
The site settings is a link at the top right of the report manager web page. When you go to view your report what's at the top right? If you're an admin you should see Home, My Subscriptions, Site Setting and Help. If you're not an admin you may not see the site settings.
March 18, 2014 at 6:33 am
sqlbuddy123 (3/13/2014)
Charmer (3/11/2014)
Hi Firends,I am just a beginner in report service. I am trying to deploy a report. But i get the messages below.
"Error1The permissions granted to user 'Domain\user' are insufficient for performing this operation".
When I tried to open the url in web browser, the same issue is coming up.
How should I grant the permission to the user?
Any suggestions would be appreciated.
What's the actual issue here ? You not being to deploy the report or someone else trying to open the report deployed by you ?
--
SQLBuddy
No, I am not able to deploy report in web browser.
Thanks,
Charmer
March 18, 2014 at 6:35 am
Steven.Howes (3/13/2014)
The site settings is a link at the top right of the report manager web page. When you go to view your report what's at the top right? If you're an admin you should see Home, My Subscriptions, Site Setting and Help. If you're not an admin you may not see the site settings.
Steve, I don't know how to check the report manager, and more over I am not admin. So like you said, I may not be able to see those things.
Thanks,
Charmer
March 18, 2014 at 7:01 am
Are you able to log on to the report server through RDP? Who is the Admin of the server? Can you ask them to give you the rights you need? You wouldn't need admin rights of the server just "Content Manager" or "Publisher" rights on the folder where you want to publish the reports.
March 18, 2014 at 8:18 am
That's a permission issue. You need to have Admin privileges. Or at least you should one of the following : My Reports\ Publisher \ Content Manager.
Ask you SSRS admin for the access to deploy the report.
--
SQLBuddy
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply