Deployment error??

Question

Deployment error??

Mark F-428640

Hall of Fame

Points: 3659
More actions
March 15, 2010 at 12:28 pm

#217800

Let me start by saying what I am trying to attempt overall. I am trying to email a report. Very basic I think. There are a few more elements they are as follows:
I am attempting to email an error report based on the execution results of an SSIS package. I have created a report in SSRS but when I attempt to deploy it (Menu Build-> Deploy) I get an error stating -- Could not connect to the report server http://localhost/ReportServer. Verify that the TargetServer URL is valid and that you have the correct permissions to connect to the report server...
How do I go about resolving this issue. Please note I am very new to SSRS please hold my hand on this one.
Thanks,

Viewing 7 posts - 1 through 6 (of 6 total)

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

Luke L SSC-Dedicated Points: 35547 More actions · Answer 1

The reportserver URL is a property of your solution and it is the same as the value of the location for where you want the report to be deployed on the reportsever.

http://localhost/reportserver is the default, but that will only work to deploy a report to the local machine and only if it's running SSRS. You will need to replace that value with the actual reprot server location, i.e. if your SSRS instance is hosted on a server called MyServer in a virtual directory called reportserver, you'll want to enter http://MyServer/reportserver in that property field. In Visual Studio, If you right click on the project and click properties you'll see 3 fields to enter data. one of them is the report server URL. Heres a link to BOL which details changing those settings... http://msdn.microsoft.com/en-us/library/ms155802.aspx

Hope this helps.

-Luke.

To help us help you read this[/url]For better help with performance problems please read this[/url]

Gift Peddie SSC Guru Points: 73570 More actions · Answer 2

Mark Fyffe-428640 (3/15/2010)
Let me start by saying what I am trying to attempt overall. I am trying to email a report. Very basic I think. There are a few more elements they are as follows:
I am attempting to email an error report based on the execution results of an SSIS package. I have created a report in SSRS but when I attempt to deploy it (Menu Build-> Deploy) I get an error stating -- Could not connect to the report server http://localhost/ReportServer. Verify that the TargetServer URL is valid and that you have the correct permissions to connect to the report server...
How do I go about resolving this issue. Please note I am very new to SSRS please hold my hand on this one.
Thanks,

To create a SSRS report with SSIS error you need to use custom SSIS error logging by passing your error to a SQL Server database table. Then write T-SQL code to create your report and enable subscription. The reason SSIS does not come with error system that you can use as SSRS datasource by default. This comes with more work but uses both systems separately.

Kind regards,
Gift Peddie

Mark F-428640 Hall of Fame Points: 3659 More actions · Answer 3

Thanks Luke for the quick response it appears that when the SSRS was configured IIS was not installed on the machine. My admin is doing that now so I will attempt to deploy again once he has completed that.

Gift Peddie SSC Guru Points: 73570 More actions · Answer 4

Mark Fyffe-428640 (3/15/2010)
Thanks Luke for the quick response it appears that when the SSRS was configured IIS was not installed on the machine. My admin is doing that now so I will attempt to deploy again once he has completed that.

SSRS 2005 can be added but not configured without IIS but it cannot be configured without IIS because SSRS 2005 is Asp.net depenedent, BIDs however uses VS2005/8 built in development server.

Kind regards,
Gift Peddie

Mark F-428640 Hall of Fame Points: 3659 More actions · Answer 5

My admin has installed IIS and now I don't get an error message but a request to log into reporting services. The administrative login isn't working but I notice in the IIS folders that there is not a ReportServer folder. Is this something which must be created on install or can this be configured after? And how should I do this?

Thanks in advance for any help.

Luke L SSC-Dedicated Points: 35547 More actions · Answer 6

In order to configure SSRS you need to use the reporting services configuration tool. It should have been installed with the rest of the client components on your workstation. If I recall correctly BOL has a pretty decent description of how to use it, worded much better than I can.

-Luke.

To help us help you read this[/url]For better help with performance problems please read this[/url]