March 4, 2012 at 5:22 am
Hi I'm just starting to investigate SSRS 2008 .
Report Manager iURL
http://myserver/Reports/Pages/
Web Service URL is
The web Service URL just comes up as file listing:
02 March 2012 22:20 <dir> TSTREPORTS
02 March 2012 22:20 <dir> Data Sources
02 March 2012 22:20 <dir> Datasets
28 February 2012 22:21 <dir> Users Folders
<dir> My Reports
--------------------------------------------------------------------------------
Microsoft SQL Server Reporting Services Version 10.50.1617.0
I would like to use the default web page for now so users can view reports.
I was expecting the WEB Service web page to have a nice GUI like Report manager, so I've misunderstood what its used for. I thought this is what you directed users to.
Once in production should I direct my users (internal only) to the RS Manager site?
I GUESS if I tweak with permissions I can not let them see datasets, Data Sources
folders there will be no access to report builder. Difficult to do on my local machine.
Am I on the right track?
Thanks
March 7, 2012 at 3:18 am
Hi terryshamir,
I would point the users to the http://yourserver/Reports url.
The only time I have used the 'ReportServer' url is when deploying reports or creating an asp.net website to access the webservice :
"http://yourserver/reportserver/reportservice2005.asmx";
I think a lot of companies create their own reports site to hide the users from this 'reports site'.
Another alternative might be to publish your reports to Sharepoint.
Hope this helps. Goodluck.
Mark
March 7, 2012 at 3:33 am
one thing I would say is create AD security groups before you start doing anything with permissions, it makes life a lot easier.
then grant the group the access it needs, that way say, you end up having 100 folders and you want to add one user to the folders you dont have to manually add them in 1 by 1 (as your talking about modifing parent security with limiting folder visability etc), instead you just add the user into the AD group which is 1 place and it filters the access down through SSRS saving you the hassle of modifing security on 100 folders and the reports.
March 7, 2012 at 6:20 am
Thanks Mark, I would like another website but I'm not a web developer.
Anthony I will be using the AD stuff as it will sit on our Network. I hope I will be able to add groups of users e.g. we have a Domain\CustSvcs group of users I hope I can add those as a role.
One thing that does concern me is I'm using windows authentication to log into Report services amanger and via Enterprise manager. I can see one day having to physically move the DB to another server and have had problems with this before.
I'm confused about authentication I came across pages/froms which are .Net terms. I presume they would need to login in to site, but where is this stuff stored e.g. SQL Authentication stuff is stored in a master db, so I know what I have to migrate.
Sorry guys I'm very much new to this SSRS (just worked out what that stands for)
March 7, 2012 at 6:46 am
if you do need to one day move the SSRS database from one server to another, you will need the ssrs encryption keys.
when you configure SSRS, the last step should be to backup/restore the keys, so generally a good option to back them up and stick them in a secure environment.
the windows accounts used to login to the web page are stored at the SSRS server level so these dont need migrating
then its all down to the data sources and how they are configured to access the database backend if your moving them to another server too, this can be done with Windows or SQL authentication, its entirely your preference, just need to port them over to the new server and restore the encryption keys.
March 7, 2012 at 6:58 am
Hi Antony,
Moving the database should not be a problem if you are using AD, this link might help :
http://msdn.microsoft.com/en-us/library/ms156421.aspx
Do you mean 'forms based authentication' when you refer to 'page/froms' or am I off track ?
I always use AD when setting up reporting services
but 'forms based authentication' in .NET is normally setup in a database on its own.
Mark
March 7, 2012 at 7:01 am
Previous post meant for terryshamir.
March 7, 2012 at 9:16 am
Thank you v.much
Its these little bits of info that always scupper you when you come to it.
March 7, 2012 at 9:20 am
mark - you are 100% on track.
I know remember this .net stuff has an extra DB I had to create the tables for someone once.
So if you were going to do this manually you'd have to write screens/pages to manage users.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply