Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Reporting services Access/ Requirements Expand / Collapse
Author
Message
Posted Friday, February 22, 2013 3:36 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, August 13, 2014 10:34 AM
Points: 113, Visits: 408
Hi All

I am going to introduce SSRS to develop reports , now I need to know what are the prerequisites / Requirements and access required to make simple SSRS report developed, running and make it available by end user?

If I start from scratch, according to me, I need access to SSRS reporting services, Report manager and Report server URL , and reporting services configuration tool to achieve the above? Is there any thing else I need to have or am missing , please input your comments.
Post #1422963
Posted Tuesday, March 5, 2013 5:10 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, August 12, 2014 10:57 PM
Points: 458, Visits: 857
[url=http://msdn.microsoft.com/en-us/library/ms143736(v=sql.90).aspx][/url]
meghna.bhargav (2/22/2013)
Hi All

I am going to introduce SSRS to develop reports , now I need to know what are the prerequisites / Requirements and access required to make simple SSRS report developed, running and make it available by end user?

If I start from scratch, according to me, I need access to SSRS reporting services, Report manager and Report server URL , and reporting services configuration tool to achieve the above? Is there any thing else I need to have or am missing , please input your comments.


I recommend carefully reading the install instructions for SSRS. You should only need to run the configuration tool once initially when you are setting up your environment.


Creating another special domain user, e.g. "reportuser" is also helpful because in the report server configuration tool you can set this user to be used for running unattended reports.

Helpful tips:
Having a good Active Directory setup with all your users in appropriate groups will make your life easier when defining access to reports. Using windows authentication is the recommended way to provide access, but not on an individual level if you can avoid it because that is a maintenance headache. Defining security groups will allow you to grant access for those groups at the folder level in report manager. Individual report access can be defined too but I recommend sticking to folder level because it's easier to maintain. Domain security groups are also good for sharepoint access, user policies and even .NET application security and provides consitency across your environment.

Reporting services uses datasource connection objects that are stored in report manager which can contain embedded credentials. The worst thing I have seen is people using sQL Server's sa user in these connection objects just because it's easy to do. The ideal here is to use windows authentication again and users will pass through their credetials to the datasource. Again the ideal is if you have the appropriate groups set up on your SQL server with the right roles, then you don't need to manage access at the individual user level. It makes your enterprise IT policy simple if in order to grant access to reports that all you need to do is add someone to a group in Active directory - of course these map to the groups you have predefined access for on report manager. If you can't do that for whatever reason then the second best option is to use the reportusers@domain.com as embedded credentials I mentioned above. The next best option is to use sql authentication, but you really should avoid that.

Post #1427087
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse