CODEWITHSUNDEEP
sql-serverreporting-services
Bruce
Bruce

Reputation: 2203

reporting services (ssrs) prompts with username/password

I am using reporting services 2010 and get the following prompt when trying to access the reports:

enter image description here

In the reports definition, I have specified the database username/password.

Is there any way to bypass this?

Upvotes: 12

Views: 117078

Answers (6)

Rodrigo Grillo
Rodrigo Grillo

Reputation: 31

The previous select solution could not work for someone (It didn't for me), so I will show you how can you bypass it. SSRS used internet explorer to run those requests in the background (even if you use other browsers), so the solution will be adding a different type of Authentication to IE. Go to:

Open Internet Explore -> Internet Options -> Custom -> user authentication select "Automatic logon with current user name and password"

enter image description here

Upvotes: 1

Jas
Jas

Reputation: 1

go to your web portal url->site setting->security->add user or group, do it to all the items you want to upload as well.

Upvotes: 0

Saravanan Sachi
Saravanan Sachi

Reputation: 2612

If you just want to by pass the login prompt, you can modify the 'TargetServerURL' as it includes 'reportserver'. (It is like suffixing Controller with controller name in MVC)

Environment: Visual Studio 2008, Sql Server 2008

For me, it prompted when I set the 'TargetServerURL' to localhost/finreport. As mentioned in the below article, changing the 'TargetServerURL' to localhost/reportserver bypassed the login prompt.

For more info: https://learn.microsoft.com/en-us/sql/reporting-services/tools/reporting-services-login-dialog-box-ssrs

Upvotes: 2

Sreejesh Madhavan
Sreejesh Madhavan

Reputation: 37

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 and no more Prompting for credentials from frond end :)

Upvotes: 2

Irawan Soetomo
Irawan Soetomo

Reputation: 1325

My case was because I was using ReportViewer version 10 for accessing a Report Server 2014. Upgrading the ReportViewer to version 11 eliminates this problem.

Check your Web.config for \configuration\system.webServer\handlers\add[type].

Upvotes: 1

JonH
JonH

Reputation: 33143

There are actually two logins you deal with when it comes to reporting services.

  1. The login to the database is to capture the data, it has nothing to do with the actual report itself. That login you used is sent to the database as the user / credentials being used to pull the report data.

  2. This prompt you have a screen shot of, is the authentication to the report server, by default rs uses windows authentication so enter your domain\username with password.

If you do not like this default behavior you can change it, this guide should get you started: http://msdn.microsoft.com/en-us/library/cc281253.aspx

See this as well: http://msdn.microsoft.com/en-us/library/bb283249.aspx

Upvotes: 7

Related Questions