Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


access to report server url


access to report server url

Author
Message
slimjen
slimjen
Grasshopper
Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)

Group: General Forum Members
Points: 16 Visits: 71
Using SQL SERVER 2008r2 Reporting Services. I accessed my report server url using my admin credentials. I used New Role to add my user and gave all permissions in folder settings. I get error " 'servername/user' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed."
Also; when I access using admin credentials; I can't run reports. Error saying admin does not have permissions. Where do I assign permissions to the reports I create and deploy.
Thank you
davoscollective
davoscollective
Mr or Mrs. 500
Mr or Mrs. 500 (595 reputation)Mr or Mrs. 500 (595 reputation)Mr or Mrs. 500 (595 reputation)Mr or Mrs. 500 (595 reputation)Mr or Mrs. 500 (595 reputation)Mr or Mrs. 500 (595 reputation)Mr or Mrs. 500 (595 reputation)Mr or Mrs. 500 (595 reputation)

Group: General Forum Members
Points: 595 Visits: 1000
It sounds like you've added permissions on the report server website appropriately, so my first thought is about the datasource connection.

When you are in visual studio (BIDS) you create a datasource. I am wondering what credentials you've used in there. Those will be uploaded to the report server along with the datasource object.

On the report server home page, if you click the 'view details' button over on the right, it reveals the default hidden folder where the datasources are uploaded to. You can then look at the settings for the datasource and see what user credentials it uses.

The ideal way to manage this is to have an AD group in your domain that has very limited database access (read access to specific views or stored procedures used in reports). If your users are part of that group you can then use windows authentication in the datasource settings, and the individual users will pass their own windows credentials through the report server and on to the database. I'm assuming your datasource is SQL Server.

If you aren't able to do (or you are scheduling reports to run unattended) then the next best option is to have a specific reportuser created. I have used DOMAIN\reportuser on certain projects. This is a very limited user where the password does not expire. This user is set up with limited access on the SQL Server database as well as in the Report Server Configuration (ReportServerConfig.exe) on the report server itself - this is required for scheduled reports.

In the datasource properties you can then set it to use this user.

The final possibility is to create a SQL Authentication user on the SQL Database and set the datasource properties to use that user. It's the least recommended way but sometimes unavoidable.

My point in all this is that the folder and report level access granted on the Report Server website is separate from the datasource access. Hope that was clear.
Steven.Howes
Steven.Howes
SSChasing Mays
SSChasing Mays (652 reputation)SSChasing Mays (652 reputation)SSChasing Mays (652 reputation)SSChasing Mays (652 reputation)SSChasing Mays (652 reputation)SSChasing Mays (652 reputation)SSChasing Mays (652 reputation)SSChasing Mays (652 reputation)

Group: General Forum Members
Points: 652 Visits: 2328
There's two places to assign report permissions. #1 is in the site settings and #2 is on the report folder hierarchy. I got caught on this on friday. It had been so long since I've set up a report server.

Then of course there's the access to the DB itself.
slimjen
slimjen
Grasshopper
Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)

Group: General Forum Members
Points: 16 Visits: 71
Thanks so much! Got it
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search