CODEWITHSUNDEEP
reporting-servicesssrs-2017
Ramesh
Ramesh

Reputation: 21

SSRS visual studio asking credentials while Deploying reports

I have built SSRS reports in visual studio on Azure VM and configured webportal url in the project properties but when I am trying to deploy my reports SSRS visual studio getting a Reporting Services login prompt to enter username and password while Deploying reports. I Have entered VM admin credentials, DB credentials but nothing is working. Please help I am not able to deploy any changes to the report since few days.

Upvotes: 0

Views: 1420

Answers (2)

Rik Bradley
Rik Bradley

Reputation: 61

This can happen if your report is deploying to a sub-folder. You have to put the sub-folder path at the front of the TargetReportFolder value, instead of appending it to the TargetServerURL value. Note that Visual Studio will default the TargetReportFolder value to the name of the project. For example do this in the project properties:

TargetReportFolder: Retail/Sales Reports
TargetServerURL: http://myServer/ReportServer

and not this:

TargetReportFolder: Sales Reports
TargetServerURL: http://myServer/ReportServer/Retail

Upvotes: 0

Ramesh
Ramesh

Reputation: 21

If this is the first time you have published a report to a report server since set you set the deployment property TargetServerURL for a project, verify that the server name includes server and not reports. For example, https://localhost/reportserver, and not https://localhost/reports. Specifying the reports directory on the local server instead of the reportserver directory indirectly causes this dialog box to open.

Upvotes: 0

Related Questions