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

Sam

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. Kindly suggest what should i do to get rid of my problem.

Sam

Yes this can be fixed.. You should

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

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

From Dev

How to specify username password for ftp

From Dev

How to specify username and password in ftp command?

From Dev

Phantom Scala Cassandra connector: how to specify port, username, password of nodes

From Dev

Phantom Scala Cassandra connector: how to specify port, username, password of nodes

From Dev

Gradle new publish plugin: repository hosting and how to specify username and password?

From Dev

How to specify DataSource in JdbcTemplate?

From Dev

Username or password is incorrect: why not specify which?

From Dev

Flask - Avoid putting full username and password in config

From Dev

In pg_restore, how can you use a postgres connection string to specify the host/database/username/password?

From Dev

How to hard code credentials in a PHP process to avoid the user from getting prompts for username/password when they are forwarded

From Dev

How do I avoid giving username and password to git push/pull/fetch on my local machine?

From Dev

How to dynamically specify the file name for a datasource

From Dev

How to save username and password in Git?

From Dev

How to Get CouchDB Username and Password

From Java

How to secure MongoDB with username and password

From Dev

How to change USERNAME And PASSWORD of MySQL?

From Dev

How to protect a PDF with a username and password?

From Dev

How to protect password and username in Sqoop?

From Dev

How to set username/password mosquitto?

From Dev

How to protect a PDF with a username and password?

From Dev

How to recover lost username and password?

From Dev

Firefox: how to autocomplete password but not username

From Dev

How to save username and password in Git?

From Dev

How to protect password and username in Sqoop?

From Dev

How to connect LDAP With username and password?

From Dev

How to specify password in ssh command

From Dev

How to avoid username while doing git commit

From Java

Access Websphere datasource from standalone java application without specifying username/password

From Dev

How to run openconnect with username and password in a line in the terminal?

Related Related

  1. 1

    How to specify username password for ftp

  2. 2

    How to specify username and password in ftp command?

  3. 3

    Phantom Scala Cassandra connector: how to specify port, username, password of nodes

  4. 4

    Phantom Scala Cassandra connector: how to specify port, username, password of nodes

  5. 5

    Gradle new publish plugin: repository hosting and how to specify username and password?

  6. 6

    How to specify DataSource in JdbcTemplate?

  7. 7

    Username or password is incorrect: why not specify which?

  8. 8

    Flask - Avoid putting full username and password in config

  9. 9

    In pg_restore, how can you use a postgres connection string to specify the host/database/username/password?

  10. 10

    How to hard code credentials in a PHP process to avoid the user from getting prompts for username/password when they are forwarded

  11. 11

    How do I avoid giving username and password to git push/pull/fetch on my local machine?

  12. 12

    How to dynamically specify the file name for a datasource

  13. 13

    How to save username and password in Git?

  14. 14

    How to Get CouchDB Username and Password

  15. 15

    How to secure MongoDB with username and password

  16. 16

    How to change USERNAME And PASSWORD of MySQL?

  17. 17

    How to protect a PDF with a username and password?

  18. 18

    How to protect password and username in Sqoop?

  19. 19

    How to set username/password mosquitto?

  20. 20

    How to protect a PDF with a username and password?

  21. 21

    How to recover lost username and password?

  22. 22

    Firefox: how to autocomplete password but not username

  23. 23

    How to save username and password in Git?

  24. 24

    How to protect password and username in Sqoop?

  25. 25

    How to connect LDAP With username and password?

  26. 26

    How to specify password in ssh command

  27. 27

    How to avoid username while doing git commit

  28. 28

    Access Websphere datasource from standalone java application without specifying username/password

  29. 29

    How to run openconnect with username and password in a line in the terminal?

HotTag

Archive