Friday, March 9, 2012

Problem deploying reports

Hi,

I have an application that involves 3 components one of which is
Reports.
My system's configuration:
SQL 2000 - Default instance
SQL 2005 - Named instance (Instance1).

I provide the user with an option of selecting the SQL Server instance.
If the user chooses Instance1, then I need to deply the reports in SQL
2005.
The exceptions encountered during installation are logged in the Event
log.
When I do the installation for the in a machine, I always
get the following error in the event log:
Could not connect to the Report Server Database
http://<MachineName>/ReportingServices.asmx.
I tried giving the rs.exe options from commandline. I got an error like:

Error in DetermineReportUrlSecurity().

I don't have the exact error with me now.

Note that I do not get this error when I do the installation in a
machine where both default and named instances are SQL 2005.

Can anyone tell me why this happens?

Thanks,

Sandhya

Are you installing RS2005 on the same machine as RS 2000? If so you should be prompted to do a files only install, is that the case? If it is then I am not sure when you are seeing this error. During configuration? If you could provide the error message and a better description of exactly what you are doing, perhaps I can offer some help.|||

Hi,

I am deploying my reports during the time of installation of my application i.e., throwugh an msi. I deploy the reports using rs.exe command and any error encountered would be logged in event log.

While installing SQL 2005. I selected the option 'Install and configure' for Reporting Services component. I also verified that I am able to browse to the Reports page. So there is no problem with the configuration. Someone had a similar problem which I saw in another forum. There a solution was given as to disable the firewall/create exceptions for report server. But in my system the firewall is already disabled.

I am deploying my reports from the installer by giving the rs.exe command wherein I get the following error:
Could not connect to the Report Server Database
http://<MachineName>/ReportingServices.asmx.

I tried giving the rs.exe from the command line with -t parameter to trace the error.
Folowing is the exact error that I am getting:
Microsoft.ReportingServices.ScriptHost.ScriptHost.DetermineServerUrlSecuri
ty()
at Microsoft.ReportingServices.ScriptHost.ScriptHost.InstanceMain()
at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] args,
BaseCmdLine instance)

Why do I get this error?


Thanks,
Sandhya

|||

You need to connect to http://machinename/ReportServer/ReportingServices.asmx.

I hope this help.s

|||Hi,
I am connecting to http://machinename/ReportServer/ReportingServices.asmx.
Still I get the error. Any clues as to why I face this problem?
Thanks,
Sandhya|||According to the error the report server does not exist. Does the report server come up if you browse to http://machinename/reportserver? Does http://machinename/reports work?|||

Hi,

For Yukon, the default configuration for the Report page would be:

Default instance - http://<machinename>/reports

Named Instance - http://<machinename>/reports$<InstanceName>

In my case, I have Yukon in the named instance(Instance1). Hence I need to connect to http://<machinename>/reports$Instance1 and I verified that I am able to browse to this page. I get the Reports homepage.

When I browse to http://machinename/reportserver$Instance1, I get the following displayed in the page:

chnshl13423/ReportServer$Instance1 - /



Microsoft SQL Server Reporting Services Version 9.00.1399.00

So what might be the problem?

Thanks,

Sandhya

|||you should pass in -s http://machinename/reportserver$Instance1 to rs.exe.|||

Hi,

I am already giving the following:

rs.exe -i "C:\Pr\DCMReports For Yukon\DeploymentScript\PublishDCMReports.rss" -s "http://chnshl13423/reportserver$Instance1" -v parentFolder="DCM Reports For Yukon" -v reportLocation="C:\Pr\DCMReports For Yukon\DeploymentScript\PublishDCMReports.rss" -v serverName="chnshl13423\Instance1" -v databaseName="DCMSolution"

Thanks,

Sandhya

|||Any suggestions?|||

Hmm, It looks like you are doing everything that you should be. All the script host does at this point is call the soap method ListSecureMethods, using the ReportService2005.asmx endpoint. Your command looks correct and the server is up and running. I really don't know what would be causing this error.

The only thing I can think of is if the user you are running rs.exe as can not be authenticated with RS or RS is setup to use forms or basic auth. You could try using a different user, or if you are using basic auth, pass in the username and password options.

No comments:

Post a Comment