[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


SQL Reporting Services

Posted on 2012-09-10
Medium Priority
Last Modified: 2012-09-26
I need some things to check.

Reporting services has been configured,  my collegue has access to Reporting services, i haowever do not.  but the groups i am a member of are the same as my collegue and these groups have permissions at all the correct levels.  

I just keep getting prompted for my credentials everytime i try to access the reporting server.

Any Ideas?
Question by:ProjNet
  • 3
  • 2
LVL 22

Expert Comment

by:Nico Bontenbal
ID: 38382539
Could it be some of the permissions your colleague has are assigned to him as a user directly , not through the groups he is a member of.

Author Comment

ID: 38382906
ok i have made sure our accounts are in sync, now locally we can log on however from any other machine in the network we have no joy.

it is very confusing.  the account and permissions appear to be correct.  all permissions are granted at the group level.  there are no user accounts added individually.
LVL 22

Expert Comment

by:Nico Bontenbal
ID: 38383431
Are the SSRS server and the 'any other machines' joined in the same domain?
Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

LVL 27

Expert Comment

ID: 38387236
are you using a shared connection in your report?
By using a shared connection this will help in some of the errors you get in credentials.

Author Comment

ID: 38424473
I've requested that this question be deleted for the following reason:

We found the work around,  it was to do withpermissions however we assigned all permissions and started stripping them back.  also when accessing the site from a server we needed to run IE in admin mode.

Accepted Solution

ProjNet earned 0 total points
ID: 38421405
Thanks for you assistance however i just gave eveyone admin rights and started stripping the permissions back until i had a problem.

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction: This article is aimed at report developers who are used to developing reports using relational databases and have gotten a first-time assignment to develop reports on OLAP cubes. It demonstrates how to build a report using SQL Ser…
How to use Variables  and Custom code in SSRS report and Assembly reference to use compile shared code in SSRS. Its big question for all who are working with SSRS. It is easy to create assembly and refer in SSRS report, still there are some steps…
Integration Management Part 2
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
Suggested Courses

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question