May 7, 2012 at 4:05 am
Hi,
I've been Googling, Binging, and reading just about anything I can, but can't work out if his is actually possible.
Can you use SQL Server Login account (so not AD accounts) to authenticate with SSRS? I need to be able to create some users, who don't have network access (therefore no AD accounts) and give them access to the SSRS report Manager web site. Some user need to sue Report Buidler, others just Browser access ,etc.
I thought this was going to be easy, but it's not.
My infrastructure is seperate SSRS 2008 SP1 and DB 2008 SP1 server (both W2K8). Eventually this will be in a DMZ scenario, but I need to prove you can sue SQL Logins first, before heading into the DMZ.
The DB Server is in Mixed Mode, Repport Server is Native mode. I did a File Only install of SSRS and then configured the report server.
I've tried changing the web.config (Report Server and Report Manager) and the rsreportserver.config for Basic and Forms authetnication, but nothing seems to work. I';m out of ideas so need to ask....can this be done?
Any ideas?
---- UPDATE ---------
I think the only way to do this is to have the account management done in SQL Server, assign the SQLLogin account db_datareader permissions, and then in SSRS set the DataSource to "Credentials supplied by the user running the report". This will allow them to enter a username/password to run the report. But how do I control their access to SSRS? I still need to limit them to a URL like http://reportserver/Reports/Pages/Folder.aspx?ItemPath=%2fAllowed+Reports%2fReports&ViewMode=List and prevent them from navigating around teh rest of the site.
thanks,
Dave.
May 7, 2012 at 10:57 pm
Hi All,
It looks like I've sorted this out. I downlaoded the SSRS 2008 Samples and went through the Forms Authentication sample following the instructions VERY carefully. Got most of it working but ran itno some issues. Found another forum answer (http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/eca5ac3d-43c8-458c-b652-028dba9fc1b3/) which corrected some of the steps for a 2008 instance. Mainly, adding the "RS_" prefix.
I now have a Forms absed authetncated SSRS 2008 site that allows a user to Register and Login. I can also add tehse users to Roles within SSRS.
All Sweet on the Laptop, now to try it on the servers!
If this all works, then i'll update this as the answer, but if others ahev any additional ideas then pelase contribute.
Dave
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply