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

x
?
Solved

SQL Reporting Services

Posted on 2012-09-10
9
Medium Priority
?
432 Views
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?
0
Comment
Question by:ProjNet
  • 3
  • 2
6 Comments
 
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.
0
 

Author Comment

by:ProjNet
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.
0
 
LVL 22

Expert Comment

by:Nico Bontenbal
ID: 38383431
Are the SSRS server and the 'any other machines' joined in the same domain?
0
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

by:planocz
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.
0
 

Author Comment

by:ProjNet
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.
0
 

Accepted Solution

by:
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.
0

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