Cannot publish reports... report server could not be found

Question

Post reply

Cannot publish reports... report server could not be found

pietlinden

SSC Guru

Points: 63421
More actions
October 31, 2014 at 7:22 pm

#300704

SSRS 2012 (yup, I'm in the right forum!)
(for Active/Release config)
In the project properties, the Target Server URL is http://localhost/Reports
The weird thing is that the TargetServerVersion property is on "SQL Server 2008R2 or later" and I can't change it to 2012.
When I try to deploy, I get:
"The specified report server could not be found."
I can go to the page in IE, and it displays (although I can't see any reports, because they won't publish).
How do I fix this? Any weblinks? Sites with instructions? Kinda irritating... everything works fine inside SSRS, but I can't publish anything.
--- Oddly, ReportBuilder works... Sorted it... it was a configuration issue... (big surprise!)
Thanks!
Pieter

Viewing 5 posts - 1 through 4 (of 4 total)

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

bcaruso 14201 SSC Veteran Points: 272 More actions · Answer 1

I don't know if this helps since I'm just learning SSRS myself, but I found this Technet information:

Set Deployment Properties (Reporting Services)

http://msdn.microsoft.com/en-us/library/ms155802%28v=sql.110%29.aspx

Maybe this is old news to you, since you already mentioned TargetServerURL, but I noticed the note around step 7 that the default TargetServerVersion is SQL Server 2008 R2 and (note below step 2) that multiple configurations can be set up to enable switching between servers and environments.

Perhaps these properties weren't configured for report deployment at the same time as the report server, especially since there's apparently a separate configuration tool just for deploying reports? (I didn't expect that twist in the installation plot :))

Quoting from the same link, right below the intro on SQL Server Data Tools:

"Use Configuration Manager to create and manage sets of project properties in project configurations. Configuration Manager is a feature supported by Visual Studio, on which SQL Server Data Tools is based.

Note

Do not confuse this feature with the Reporting Services Configuration Manager, which is used to configure Reporting Services after installation. For more information, see Configuration and Administration a Report Server (Reporting Services SharePoint Mode)."

Becky

pietlinden SSC Guru Points: 63421 More actions · Answer 2

Finally got it sorted out... read this[/url] and followed the instructions (imagine that!). Figured Robert Pearl probably knows how to configure SSRS properly... not sure how I managed to screw it up so badly, but it's fixed now.

Thanks!

bcaruso 14201 SSC Veteran Points: 272 More actions · Answer 3

Thanks, Pieter, that's a great article! I bookmarked it in case I also run into this problem on my first SSRS installation 🙂

Becky

pietlinden SSC Guru Points: 63421 More actions · Answer 4

The great thing about it is that he walks you through all the gotchas and fixes them. I've been fighting with this stupid problem forever and finally found an answer!