Hi,

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 L.

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 L
  • I also tried with the database credentials in SSRS data source but also no success L

Kindly suggest any solution in detail and kindly attach a sample or screen shot of SSRS settings if possible ASAP so that I can resolve this issue

Thanks in advance

Regards,

Nasir

Hi Nasir,

As per my understanding, when we use Windows credentials, we must supply a valid Windows account and password to use for authenticating the report server's connection to the report server database.

In SSRS, the report server passes credentials to specific data sources. For any given data source connection, the report server can get credentials in one of the following ways:
 Use Windows Authentication
 Use user name and password
 Prompt for credentials
 Use no credentials.
Reference: http://msdn.microsoft.com/en-us/library/ms160330.aspx

We can check the log file to get more detail information of this issue. It is benefit for us to do further analysis.

Hope this helps.

Regards,
Alisa Tang

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.

following is the code which I used to set credential behind report viewer

Please suggest to resolve this issue.

Thanks

Hi Alisa Tang,

Thanx for your reply, Actually i have done all the impersonation, Anonymous settings but no success so far :-(. I believe something is wrong with domain security while i am going to use Database credentials then domain is doing something wrong :-(.
Hope some one will guide me on the right tack :-(.

Alisa Tang Thanks a lot again 

Hi Alisa,

Thanks a lot for your kind response. I just looked your answer and then my question and come to know that my error is HTTP status 401: Unauthorized. I am so sorry for any inconvenience. Hope you understand the situation that how can be a person specially a developer's situation while he is scratching the head but no solution.
Waiting now for your kind response.

Thanks a lot for you patience

Regards,

Nasir