Cannot publish report to SSRS 2008 R2
I have new installation of SQL Server 2008 R2 standard with SSRS on Win 2008 R2 Standard. I'm using BIDS 2008 and trying to deploy reports to the server. I'm using Native mode, with default domain authentication for the report server. Using
SQL Authentication to connect to the Report server database. When I'm logged on to the Report Manager via
Http://PCName/Reports , I can manually copy and run reports there, but cannot publish from BIDS, or call from a VS 2005 application via a Report viewer control in my Winform app.
Error message during deployment: The specified report server URL .... could not be found, verify the syntax of the .... I know the URL is valid because I run the report from the manager.
Error message from VS 2005 Winforms project: "The attempt to connect to the Report Server failed. check the connection information and that the report server is a compatable version", "The request failed with HTTP status 404: Not found". I'm at my wits end,
been working on it for days. I have a functional 2005 Report server running with no issues. I appreciate any input I can get
Thanks
Paul
Paul J. Ilacqua
November 8th, 2010 1:06pm
Hi Paul,
Right click the report project and select Properties, in the General page, make sure the TargetServerURL value is the string of report server instead of report manager, for example,
http://PCName/ReportServer. You can get it from Web Service URL page of Reporting Services Configuration Manager tool.
thanks,
Jerry
Free Windows Admin Tool Kit Click here and download it now
November 8th, 2010 10:11pm
Hi Paul,
Right click the report project and select Properties, in the General page, make sure the TargetServerURL value is the string of report server instead of report manager, for example,
http://PCName/ReportServer. You can get it from Web Service URL page of Reporting Services Configuration Manager tool.
thanks,
Jerry
November 8th, 2010 10:11pm
Jerry,
Thank you so much. It's so easy to get engrossed in the myriad of SSRS settings that you overlook the basics that you pointed out. I appreciate your help.
PaulPaul J. Ilacqua
Free Windows Admin Tool Kit Click here and download it now
November 9th, 2010 6:51am
Hi,
I have my targetserverURL typed correctly, and can connect to it in SSMS, but I cannot get to it from BIDS to deploy any report. This target server uses both types of authentication, sql and windows. I also cannot open the target server url in a
browser. This target server is my own machine, local. Thanks!
January 11th, 2011 6:38pm
Hi,
If the Server OS is WIN7 or WIN Server 2008, Then the Browser should be opened via "Run as Administrator".
Thanks
M
Please click the 'Mark as Answer' button if my Reply helped you to solve your problem! Thanks M.Mahendra
Free Windows Admin Tool Kit Click here and download it now
January 11th, 2011 6:44pm