SQL Reporting Services

Posted on 2012-09-10
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
    LVL 22

    Expert Comment

    by:Nico Bontenbal
    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

    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
    Are the SSRS server and the 'any other machines' joined in the same domain?
    LVL 27

    Expert Comment

    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

    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

    Thanks for you assistance however i just gave eveyone admin rights and started stripping the permissions back until i had a problem.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Have you ever had to extract data from a Microsoft SQL Server database and export it to an Excel file, but did not want to use a DTS package? The concept in this article is not new, but it is the answer and will also work on 64-bit SQL boxes.   …
    A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    730 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now