SSRS report keeps asking for username and password for the datasource

Question

0.00/5 (No votes)

See more:

Hi all,
i have developed a SSRS report and have deployed the same on my local machine.The report is working fine.The only problem i have is that it keeps showing the message Specify the username and password for the data source datasource1.After which i have to supply my sql server credentials an d it works fine. How can i stop that message from displaying and showing the data to the user??
Thanks in advance,
Gourav Sharma

Posted 19-Jul-13 0:09am

Gourav Sharma from Jammu

Updated 9-Oct-17 4:40am

Add a Solution

Comments

ZurdoDev 19-Jul-13 10:46am

I haven't done SSRS in a long time but I'm pretty sure there is a property on the datasource to save the credentials. Just look.

Mxolisi Zondi 25-Mar-15 5:58am

Hey , if you have found a solution to this, please help, i'm also having the same problem, also asked on stackoverflow>> http://stackoverflow.com/questions/29251489/ssrs-report-running-on-website-keeps-on-asking-for-credentials
solutions below did't work for me, thanks

5 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Anh Nguyen Trong · Answer 1 · 2013-08-18T23:15:00

Solution 3

You need to go to the properties of the datasource of the report and look at the credentials.
You can change the information (user, pass) you will not see this.

Posted 18-Aug-13 23:15pm

Anh Nguyen Trong

Mubin M. Shaikh · Answer 2 · 2013-09-05T00:38:00

Solution 4

Hi,

You need to change way of your security setting specified in your data source, instead of using prompt method you can specify credential which will be stay stored in that data source, for accessing the data.

then it will not ask for credential whenever you access the report.

Regards
Mubin M.Shaikh

Posted 5-Sep-13 0:38am

Mubin M. Shaikh

Comments

Mxolisi Zondi 25-Mar-15 6:09am

I tried all that, still doesn't work, similar question on stackoverflow >
http://stackoverflow.com/questions/29251489/ssrs-report-running-on-website-keeps-on-asking-for-credentials

mesree · Answer 3 · 2017-01-03T19:38:00

Open your project/Solution in SSRS tool. Select the report properties (Right click on report project and select properties). Update 'Overwrite dataset' and 'Overwrite datasource' as True. Then go to your shared Datasource properties and select 'credentials' section. There you can select 'Use this username and password' option and set appropriate SQL Server credentials. Click OK .Now no more Prompting for credentials from frond end :)

Manu V M · Answer 4 · 2013-07-29T03:33:00

Solution 2

http://blogs.technet.com/b/microsoft_in_education/archive/2013/01/31/ssrs-101-creating-a-shared-data-source.aspx

Posted 29-Jul-13 3:33am

Manu V M

carlitosd19 · Answer 5 · 2024-03-12T08:54:00

Solution 7

OK, I find a way to fix this:
1-Set you connection string inside the Data Source in the General Tab (include your username and password)
2-On the Credentials Tab, set "Do not use credentials"
3-Save the report and reopen and run it.

that's all :)

Posted 12-Mar-24 8:54am

carlitosd19