locked
SSRS Database credentials problem under domain environment RRS feed

  • Question

  • User1326246355 posted

    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:<o:p></o:p>

    Credentials stored securely in the report server (radio button is selected) and provide the database server credentials in user name and password fields.<o:p></o:p>

    "use as window credential when connecting to the data source" checkbox is unchecked because I want to use database credential instead of window credentials.<o:p></o:p>

     

    Kindly suggest any solution in detail

    Thanks 

    Saturday, January 11, 2014 8:07 AM

Answers

  • User-734925760 posted

    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

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, January 13, 2014 4:39 AM