Cannot deploy SSRS 2014 from Visual Studio 2012

Question

Cannot deploy SSRS 2014 from Visual Studio 2012

JimReeves71

Default port

Points: 1410
More actions
April 28, 2015 at 11:01 am

#303377

I am having problems deploying a SSRS report in Visual Studio 2012. I know that the Report Server URL is correctly set because when I click on the following link: http://chris-pc/ReportsServer
Then I get taken to the home page for SSRS.
However when I create a project and point the URL to http://chris-pc/ReportsServer and try to deploy the report, I get the following error message:
'The specified report server URL http://chris-pc/ReportsServer could not be found. Verify the syntax of the URL and that the report server exists.
But it does!
I also checked my site settings and I have a role as System Adminstrator and System User.
The property pages for my SSRS project are set ups as follows:
Overwrite Data Sources: True
Target Dataset Folder: Datasets
Target Data Source Folder: Data Sources
Target Report Folder: Report Project 1
Target Report Part Folder: Report Parts
Target Server URL: http://chris-pc/ReportsServer

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Andrew P SSCarpal Tunnel Points: 4649 More actions · Answer 1

If you haven't changed this from the default, it should be pointing to http://chris-pc/ReportServer not http://chris-pc/Report%5Bb%5Ds%5B/b%5DServer - did you change this?

If deploying to http://chris-pc/ReportServer doesn't work, what do you get when you use a browser to go to "http://chris-pc/ReportServer" and "http://chris-pc/ReportsServer" - a report list or a "Not Found" error page?

JimReeves71 Default port Points: 1410 More actions · Answer 2

sqlservercentral.com 32358 (4/28/2015)
If you haven't changed this from the default, it should be pointing to http://chris-pc/ReportServer not http://chris-pc/Report%5Bb%5Ds%5B/b%5DServer - did you change this?
If deploying to http://chris-pc/ReportServer doesn't work, what do you get when you use a browser to go to "http://chris-pc/ReportServer" and "http://chris-pc/ReportsServer" - a report list or a "Not Found" error page?

Ok from Reporting Services Configuratation Manager, I changed the URL in Report Manager URL to be

http://CHRIS-PC:80/ReportServer

I re-built the project and then tried to deploy but the same error message:

The specified report URL http://chris-pc/ReportServer could not be found . Verify the

syntax of the URL and that the report server exists.

Andrew P SSCarpal Tunnel Points: 4649 More actions · Answer 3

Does the ReportServer page show when viewed in a browser (as below)?

JimReeves71 Default port Points: 1410 More actions · Answer 4

When I open a browser and then type in the URL http://chris-pc/ReportServer into the URL box,

I don't get that screen.

I get a browser window with the standard SQL Server Reporting Services window and the options

shown but with the URL http://chris-pc/ReportServer/Pages/Folder.aspx

The options shown are 'New Folder', 'New Data Source', 'Folder Settings', 'Upload File'

The URL in the internet explorer bar then changes to : http://chris-pc/ReportServer/Pages/Folder.aspx

as you can see in the screenshot. NB When I opened Internet Explorer.. I did not open it as Administrator.

http://chris-pc/ReportsServer

Andrew P SSCarpal Tunnel Points: 4649 More actions · Answer 5

In Reporting Services Configuration Manager, go to the Web Service URL tab, and click the hyperlink beside URLs: under Report Server Web Service URLs. This should bring up a page similar to the one in the screenshot. If it does, put that address into Visual Studio as your target server. Does the report then deploy?

JimReeves71 Default port Points: 1410 More actions · Answer 6

Andrew Pirie (4/29/2015)
In Reporting Services Configuration Manager, go to the Web Service URL tab, and click the hyperlink beside URLs: under Report Server Web Service URLs. This should bring up a page similar to the one in the screenshot. If it does, put that address into Visual Studio as your target server. Does the report then deploy?

Ok in summary:

1) I go to the Web Service URL tab in Reporting Services Configuration Manger.

2) Click on the URL under Report Server Web Services URLS

3) If that works then copy this address into the Target Server URL part of the deployment on 4) 4) Then re-build the project and deploy

It works! Brilliant! Thank you so much for that!

Andrew P SSCarpal Tunnel Points: 4649 More actions · Answer 7

Great - glad you've got this working. I would have given more direct suggestions if I had access to a PC with SSRS installed earlier, so sorry about that :-).

JimReeves71 Default port Points: 1410 More actions · Answer 8

Andrew Pirie (4/29/2015)
Great - glad you've got this working. I would have given more direct suggestions if I had access to a PC with SSRS installed earlier, so sorry about that :-).

No problem my friend.

So based upon what I just learnt...I added a section on 'Deploying SSRS reports'

and added in some screen shots from configuration manager and how to extract the correct

Target Server URL

I'm learning SSRS and this is my first report...so the next one will be easier to write and deploy!

Thanks for your guidance on this anyway. 🙂