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 tried with the database credentials in report viewer directly but also no success
I also tried with the database credentials in SSRS data source but also no success
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 uncheckedbecause I want to usedatabase
credentialinstead of window credentials.
According to your description and the error message, the Report Service requires credentials in order for you to access the
service.
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:
None
0 Points
1 Post
SSRS Database credentials problem under domain environment
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
Thanks
All-Star
18232 Points
2199 Posts
Re: SSRS Database credentials problem under domain environment
Jan 13, 2014 04:39 AM|Michelle Ge - MSFT|LINK
Hi,
According to your description and the error message, the Report Service requires credentials in order for you to access the
service.
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:
http://www.rodcerrada.com/post/2011/02/28/Setting-Up-Credentials-for-SQL-Server-Reporting-Services.aspx
Hope it's useful for you.
Best Regards,
Michelle Ge