November 22, 2012 at 4:03 am
Hi,
I have installed SQL Server 2008 R2 Express with Advanced Tools to gain access to SSRS. I have also installed IIS 7.5 as I will deploying some web applications from the same server (within an internal network).
However I hope to use windows authentication to pass through the user details without a login box to SSRS (which will eventually be embedded within my application).
How can i set this up? Do I need to create another site in IIS (although I know SSRS 2008 doesn't use IIS)?
I have tried to find the reportserver.config file and simply can't find it anywhere..can anyone advise to it's location.
November 22, 2012 at 4:32 am
This was removed by the editor as SPAM
November 22, 2012 at 4:34 am
Stewart "Arturius" Campbell (11/22/2012)
You will need to configure Reporting Services using the Reporting Services Configuration Tool
Thanks for that - any more specific advice?
I have already configured the site and I have added a few users - I can browse to these from their logins fine..however I am still struggling to get it working using reportviewer and from embedded code in my application
November 22, 2012 at 5:35 am
This was removed by the editor as SPAM
November 22, 2012 at 5:40 am
Thanks, I have already done that..it works when browsing to the pages directly from the users I have setup.
However how do I set it up so I can browse the pages via my web application (aspx)...
I have tried the following:
- creating a network service user using the method above
- I have also created a sql user for my appool.
- I also tried adding < impersonate = true... to the web.configs of the report server and report manager
- created a local group on the server, added the domain users and added this user using the method you mentioned - no success either..(same as adding users directly i guess)
I guess my issue is being caused by the fact the windows authentication provided for application via IIS is not being granted the access I need on the reportserver......
November 22, 2012 at 5:54 am
You will also need to back up the encryption keys for DR purposes
http://technet.microsoft.com/en-us/library/ms157275.aspx
_________________________________________________________________________
SSC Guide to Posting and Best Practices
November 22, 2012 at 6:03 am
ok thanks...
I have solved my own problem by hard coding in credentials for a user with access only to the reportserver...using this forum post:
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply