I built an application. It has a logging facility. After logged in into that application when I tried to access the report the apps again ask me for the username and password. The reports are built in SQL Server Reporting Services 2005.If anybody have an
idea regarding this issue please reply me -
When the user already logged into the application then why it is asking again for the authentication while accessing the Report ?
The application you wrote will be probably need to connect to RS while impersonating a specific user. For example , if it's a ASP.NET web application , it might have to impersonate DOMAIN\User1 , and DOMAIN\User1 will need to have access to the Reporting
Services instance. Where you set up which user your application impersonates depends on the type of application it is, but if it's a ASP.NET web application , you would normally do it in the web.config file.
SSRS reports from the SSRS server uses server authentication. If you are using a Web control to access the reports you'll have to go into SSRS and allow
servername\IUSR_servername browser role permissions for the report folder.
Please mark the post(s) that have helped you as "Answer"
I'm better at brewing beer than crafting code but I have to do the latter to do the former. Will code for malt.
I built an application. It has a logging facility. After logged in into that application when I tried to access the report the apps again ask me for the username and password. The reports are built in SQL Server Reporting Services 2005.If anybody have an
idea regarding this issue please reply me -
When the user already logged into the application then why it is asking again for the authentication while accessing the Report ?
Actually i want to eliminate the user authentication when client wants to see the report after logging into the application. If you could clearly mention what changes i have to do to remove the authentication ? .If user once logged into
the application then when he/she tries to access the report then application should not ask for logging authentication again.
Actually i want to eliminate the user authentication when client wants to see the report after logging into the application. If you could clearly mention what changes i have to do to remove the authentication ? .If user once logged into the application then
when he/she tries to access the report then application should not ask for logging authentication again.
Could you clarify if this is a Web application or otherwise?
Please mark the post(s) that have helped you as "Answer"
I'm better at brewing beer than crafting code but I have to do the latter to do the former. Will code for malt.
Yes it is a web application built on ASP.Net 2.0 technology and SSRS 2005.Actually when i try to access the report link from that web app then a pop up appears with username and password. Actually my website contains 5 reports built on SSRS 2005.when i
click on any one report for the first time it asking for username and password, after giving the right authentication if i try to access the other reports then it shows the report without asking for authentication. I mean to say for once it asks for authentication
not for the second time. If i close the application and again start it then if try to access the reports it will ask again for username and password for first time. Now i want to stop from asking that username ad password while trying to access those report
of my website. I hope you have understood my problem. If you need more clarification regarding this issue feels free to ask me.
Actually my application contains login facility if user wants to access my website he/she should have access rights. But once it supplies the proper credentials’ then user will able to see the reports link. Now problem arise when user tries to access that
link, it asks for username and password again to the logged in user that is what i want to stop it from asking username and password to the logged in user.
"SSRS reports from the SSRS server uses server authentication. If you are using a Web control to access the reports you'll have to go into SSRS and allow
servername\IUSR_servername browser role permissions for the report folder."
I was having a similar problem and this solved it.
Please mark the post(s) that have helped you as "Answer"
I'm better at brewing beer than crafting code but I have to do the latter to do the former. Will code for malt.
Could you elaborate your answer more briefly? I mean to say how could I get into the servername\IUSR_servername for the Report folder? Please explain me more precisely if you can.
Ayan_Biswas_...
Member
16 Points
73 Posts
Reporting Services Authentication
Sep 08, 2008 02:03 PM|LINK
I built an application. It has a logging facility. After logged in into that application when I tried to access the report the apps again ask me for the username and password. The reports are built in SQL Server Reporting Services 2005.If anybody have an idea regarding this issue please reply me -
When the user already logged into the application then why it is asking again for the authentication while accessing the Report ?
Thavash
Member
80 Points
10 Posts
Re: Reporting Services Authentication
Sep 09, 2008 02:33 PM|LINK
The application you wrote will be probably need to connect to RS while impersonating a specific user. For example , if it's a ASP.NET web application , it might have to impersonate DOMAIN\User1 , and DOMAIN\User1 will need to have access to the Reporting Services instance. Where you set up which user your application impersonates depends on the type of application it is, but if it's a ASP.NET web application , you would normally do it in the web.config file.
Check out my reporting services blog at Live.com Spaces
newsomer
Member
587 Points
216 Posts
Re: Reporting Services Authentication
Sep 09, 2008 02:52 PM|LINK
SSRS reports from the SSRS server uses server authentication. If you are using a Web control to access the reports you'll have to go into SSRS and allow servername\IUSR_servername browser role permissions for the report folder.
I'm better at brewing beer than crafting code but I have to do the latter to do the former. Will code for malt.
cioina
Contributor
3728 Points
878 Posts
Re: Reporting Services Authentication
Sep 09, 2008 04:27 PM|LINK
Hi,
I use a method from http://community.discountasp.net/default.aspx?f=16&m=17808
Alexei Cioina.
http://www.californiadreamhomesandland.com/Pages/ReportExplorer.aspx?ItmPath_25B7ED104E83=/English/Web%20Master/Web%20Site%20Statistics
Ayan_Biswas_...
Member
16 Points
73 Posts
Re: Reporting Services Authentication
Sep 10, 2008 10:18 AM|LINK
Actually i want to eliminate the user authentication when client wants to see the report after logging into the application. If you could clearly mention what changes i have to do to remove the authentication ? .If user once logged into the application then when he/she tries to access the report then application should not ask for logging authentication again.
newsomer
Member
587 Points
216 Posts
Re: Reporting Services Authentication
Sep 10, 2008 09:19 PM|LINK
I'm better at brewing beer than crafting code but I have to do the latter to do the former. Will code for malt.
Ayan_Biswas_...
Member
16 Points
73 Posts
Re: Reporting Services Authentication
Sep 11, 2008 06:49 AM|LINK
Yes it is a web application built on ASP.Net 2.0 technology and SSRS 2005.Actually when i try to access the report link from that web app then a pop up appears with username and password. Actually my website contains 5 reports built on SSRS 2005.when i click on any one report for the first time it asking for username and password, after giving the right authentication if i try to access the other reports then it shows the report without asking for authentication. I mean to say for once it asks for authentication not for the second time. If i close the application and again start it then if try to access the reports it will ask again for username and password for first time. Now i want to stop from asking that username ad password while trying to access those report of my website. I hope you have understood my problem. If you need more clarification regarding this issue feels free to ask me.
Thanks
Ayan
Ayan_Biswas_...
Member
16 Points
73 Posts
Re: Reporting Services Authentication
Sep 11, 2008 07:00 AM|LINK
Actually my application contains login facility if user wants to access my website he/she should have access rights. But once it supplies the proper credentials’ then user will able to see the reports link. Now problem arise when user tries to access that link, it asks for username and password again to the logged in user that is what i want to stop it from asking username and password to the logged in user.
Thanks,
Ayan
newsomer
Member
587 Points
216 Posts
Re: Reporting Services Authentication
Sep 11, 2008 02:35 PM|LINK
Then all I can provide is my original answer:
I was having a similar problem and this solved it.
I'm better at brewing beer than crafting code but I have to do the latter to do the former. Will code for malt.
Ayan_Biswas_...
Member
16 Points
73 Posts
Re: Reporting Services Authentication
Sep 12, 2008 09:23 AM|LINK
Could you elaborate your answer more briefly? I mean to say how could I get into the servername\IUSR_servername for the Report folder? Please explain me more precisely if you can.