Last post Sep 12, 2017 08:05 AM by Jean Sun
Sep 09, 2017 05:38 AM|Meenu M.P|LINK
I have created an application in visual studio 2013(MVC Project) which include an rdlc report too. It works fine in the local machine. But after publishing it on IIS Server , the report page asks for username and password. If we provide the system username
and password the popup will get disappeared but not getting the report ( report displays as blank). Can anyone help me to solve this issue. please ...
Sep 11, 2017 02:42 AM|Jean Sun|LINK
Hi Meenu M.P,
Please check if you have set the authentication for the reports folder under IIS. If so, please enable the anonymous authentication and disable other authentication types.
About the IIS authentication :
What kind of authentication do you use to connect to the SQL Server Database?
If you are using the Windows Authentication, please check if the Application Pool Identity can connect to database.
About how to add the ApplicationPoolIdentity to a SQL Server Login :
Sep 11, 2017 03:32 AM|DA924|LINK
On top of what has been posted, this could have been exposed the issue by deploying the web application to local IIS on your development machine, the real one, through Visual Studio, and stopped using IIS Express that is not the real IIS.
Sep 11, 2017 07:35 AM|Meenu M.P|LINK
Still the alert box is coming. Authentication Required.
I am using Sql Server Authentication in sql server . Is there anything else to do?
Sep 12, 2017 08:05 AM|Jean Sun|LINK
Please try the following fixes:
1) Remove RSWindowsNegotiate and ensure RSWindowsNTLM is specified in the file rsreportserver.config
2) Change the report server service account to Network Service
3) Configure a specific hostheader for SSRS, configure your DNS server to understand that hostheader, and configure your domain controller to have an SPN for the hostheader and the report server service account.
Clearly #1 is the easiest but not necessarily the right change. The rest of this post attempts to explain the cause and the merits of each solution.
The above content is picked from :