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.
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
.NET forums are moving to a new home on Microsoft Q&A, we encourage you to go to Microsoft Q&A for .NET for posting new questions and get involved today.
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.
.NET forums are moving to a new home on Microsoft Q&A, we encourage you to go to Microsoft Q&A for .NET for posting new questions and get involved today.
Member
28 Points
115 Posts
how to avoid to Specify a username and password for datasource in SSRS?
Dec 25, 2018 01:52 PM|zjm_zjm|LINK
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.
Member
28 Points
115 Posts
Re: how to avoid to Specify a username and password for datasource in SSRS?
Dec 25, 2018 01:59 PM|zjm_zjm|LINK
and how to show print button in reportserver
Star
9831 Points
3120 Posts
Re: how to avoid to Specify a username and password for datasource in SSRS?
Dec 26, 2018 03:13 AM|Brando ZWZ|LINK
Hi zjm_zjm,
According to your description, I suggest you could try below steps to aviod show prompt for credentials.
The default option for data sources is to prompt for credentials, so this is expected behavior unless you change it.
Best Regards,
Brando
Member
28 Points
115 Posts
Re: how to avoid to Specify a username and password for datasource in SSRS?
Dec 26, 2018 05:18 AM|zjm_zjm|LINK
i changed flow step by step but it does not remove user and pass on report.
Star
9831 Points
3120 Posts
Re: how to avoid to Specify a username and password for datasource in SSRS?
Dec 28, 2018 03:07 AM|Brando ZWZ|LINK
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