Last post Jan 13, 2014 04:39 AM by Michelle Ge - MSFT
Jan 11, 2014 08:07 AM|shoaibnazir|LINK
I have developed an ASP.Net application and used report viewer for SSRS and deployed on the client site. Earlier I used windows credentials for under domain environment but the client changes the windows password in every month. So after a month I have to
change the credentials in application web.config. It means that I have to use some database credentials so I tried the database credentials for SSRS under domain environment but no success.
The client is using windows server 2008 32 bit under domain environment.
As I mentioned that with windows credentials under domain the reports are working fine but with database credentials under domain are showing error 404 while trying to load the reports in ASP.Net report viewer.
I have choose the following option in data source:
Credentials stored securely in the report server (radio button is selected) and provide the database server credentials in user name and password fields.
"use as window credential when connecting to the data source" checkbox is unchecked because I want to use database
credential instead of window credentials.
Kindly suggest any solution in detail
Jan 13, 2014 04:39 AM|Michelle Ge - MSFT|LINK
According to your description and the error message, the Report Service requires credentials in order for you to access the
As default BUILTIN\Administrators group is given administrative access to SSRS thats the reason why it does not prompts you for username and password when you access using Report Manager.
For more information and the solution, please refer to the link below:
Hope it's useful for you.