locked
how to avoid to Specify a username and password for datasource in SSRS? RRS feed

  • Question

  • User-19694853 posted

    I am using SSRS as a part of my project for displaying reports. It accesses data from SQL data source.Here my problem is that each time I view my report on the browser, it asks me like this

    "Specify a user name and password for data source"

    I need to avoid this prompt while seeing my report on the browser. 

    Tuesday, December 25, 2018 1:52 PM

Answers

  • User283571144 posted

    Hi zjm_zjm,

    I am using SSRS as a part of my project for displaying reports. It accesses data from SQL data source.Here my problem is that each time I view my report on the browser, it asks me like this

    "Specify a user name and password for data source"

    I need to avoid this prompt while seeing my report on the browser. 

    According to your description, I suggest you could try below steps to aviod show prompt for credentials.

    • Go into your DataSource properties
    • Select Credentials
    • Select "Use this user name and password"
    • Enter the credentials that you want to use with the report
    • Save the report (or DataSource if it's a shared DataSource)

    The default option for data sources is to prompt for credentials, so this is expected behavior unless you change it.

    Best Regards,

    Brando

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, December 26, 2018 3:13 AM
  • User283571144 posted

    Hi zjm_zjm,

    According to your description, I suggest you could check you have use the right username and password and enable  Credentials stored securely in the report server.

    More details, you could refer to below article:

    https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2005/ms159736(v=sql.90)#to-specify-stored-credentials-for-a-report-specific-data-source

    Best Regards,

    Brando

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, December 28, 2018 3:07 AM

All replies

  • User-19694853 posted

    and  how  to show print button in reportserver

    Tuesday, December 25, 2018 1:59 PM
  • User283571144 posted

    Hi zjm_zjm,

    I am using SSRS as a part of my project for displaying reports. It accesses data from SQL data source.Here my problem is that each time I view my report on the browser, it asks me like this

    "Specify a user name and password for data source"

    I need to avoid this prompt while seeing my report on the browser. 

    According to your description, I suggest you could try below steps to aviod show prompt for credentials.

    • Go into your DataSource properties
    • Select Credentials
    • Select "Use this user name and password"
    • Enter the credentials that you want to use with the report
    • Save the report (or DataSource if it's a shared DataSource)

    The default option for data sources is to prompt for credentials, so this is expected behavior unless you change it.

    Best Regards,

    Brando

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, December 26, 2018 3:13 AM
  • User-19694853 posted

    i changed flow step by step but it does not  remove user and pass on report.

    Wednesday, December 26, 2018 5:18 AM
  • User283571144 posted

    Hi zjm_zjm,

    According to your description, I suggest you could check you have use the right username and password and enable  Credentials stored securely in the report server.

    More details, you could refer to below article:

    https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2005/ms159736(v=sql.90)#to-specify-stored-credentials-for-a-report-specific-data-source

    Best Regards,

    Brando

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, December 28, 2018 3:07 AM