In the connection dialog of Management Studio, I can only choose Server name after I click Connect --> Analysis Services. The authentication type is dimmed out by default. Please gives me some more relevant links to setup properly.
After deployed my cubes and reports, the other user cannot view the reports as they can't access the SSAS database. What should I do? There're so many security setting and I don't know which one I should tune. Thanks in advance.
Hello! You do not need to be an domain adminstrator in order to access Reporting Services and Analysis Services. It is sufficient to be a local administrator on the server running these two applications.
In Reporting Services you have the option to run a report with windows authentication or an assigned account for Reporting Services access to Analysis Services.
If you run with the first option each user need to mapped to a role in Analysis Services which can be done with individual accounts or windows groups. For the second option it is only the Reporting Services(AS2005) account that needs to mapped to a role in Analysis Services.
You can do this both in BIDS, Report Manager or Management Studio.
This is true for a server where both these applications are running. If Reporting Services is on a separate server things are a little bit more complicated. In this case you will have to set up account delegation in Active Directory. The key word for this setup is 'Kerberos' .
HTH
Thomas Ivarsson
|||Can you give me some more detail on the configuration please? Are there any guides available on the web? Thanks!|||Hello! I have not found any best official practices regarding SSRS2005 and SSAS2005 integration.
My advice is based on customer cases/practises that I have used and some good writing in a reporting services book.
Regards
Thomas Ivarsson
|||http://technet.microsoft.com/en-us/library/ms175386(SQL.90).aspxThis website provides what I needed.sql
No comments:
Post a Comment