Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Deploy Error

Author  Topic 

Les.61
Starting Member

49 Posts

Posted - 2009-11-18 : 22:19:28
I have istalled SQL Express 2008 on my home PC and can create reportings however when I try to deploy the report I get the following:

TITLE: Microsoft Report Designer
------------------------------

Could not connect to the report server http://localhost/ReportServer. Verify that the TargetServerURL is valid and that you have the correct permissions to connect to the report server.

------------------------------
ADDITIONAL INFORMATION:

Unable to connect to the remote server (System)

------------------------------

No connection could be made because the target machine actively refused it xxx.x.x.x:80 (System)

------------------------------
BUTTONS:

OK
------------------------------

(I have hidden the IP numbers)

The SQL Server Services for Reporting is logged on as Localsystem and Sevice Type is ReportServer

Any suggestion?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-11-18 : 22:30:54
Did you verify that it is the correct path? Are you able to pull up Report Manager?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page

Les.61
Starting Member

49 Posts

Posted - 2009-11-18 : 22:35:53
I cannot bring up http://localhost/ReportServer in the browser but I can 'run' a report by right clicking on the report in Solution Explorer.

Unfortunately I know basically nothing about how to set up SQL.
Go to Top of Page

Les.61
Starting Member

49 Posts

Posted - 2009-11-18 : 23:15:40
I have managed to get the report deployed but not get the following message when browsing for the url

Server Error in '/Reports' Application.
--------------------------------------------------------------------------------

Access is denied.
Description: An error occurred while accessing the resources required to serve this request. You might not have permission to view the requested resources.

Error message 401.3: You do not have permission to view this directory or page using the credentials you supplied (access denied due to Access Control Lists). Ask the Web server's administrator to give you access to 'c:\Program Files\Microsoft SQL Server2008\MSRS10.SQLEXPRESS\Reporting Services\ReportManager\home.aspx'.


--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:; ASP.NET Version:2.0.50727.3082
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-11-18 : 23:49:21
Looks like you are encountering a permissions issue. Is this on XP?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page

Les.61
Starting Member

49 Posts

Posted - 2009-11-19 : 00:33:55
Yes Windows XP Home Edition
Go to Top of Page

Les.61
Starting Member

49 Posts

Posted - 2009-11-19 : 00:56:29
I can now access but get a plain pages as follows:

xxxxxxxxxxxxxxxxx/ReportServer - /

--------------------------------------------------------------------------------

Thursday, 19 November 2009 2:52 PM <dir> Data Sources
Thursday, 19 November 2009 2:52 PM <dir> Report Project1


--------------------------------------------------------------------------------
Microsoft SQL Server Reporting Services Version 10.0.1600.22
Go to Top of Page
   

- Advertisement -