Deployment issue SSRS 2000 reports on Production server

Hi All,
I am facing the issue while deploying Reporting Services 2000 Reports in
Production environment (Windows NT Server and SQL Server 2000) in our
application.
Background: I developed few reports using SQL Server Reporting Services 2000
and are able to deploy in Development environment and those reports are
working fine without any issues.
When we are trying to deploy the same in our Production environment, then we
are facing some issue during the deployment time and not able to deploy those
reports into it. We are followed 3 ways to deploy the same as mentioned below:
Method 1: From Application or report manager screen
(http://servername/reports or http://localhost/reports ) we are trying to
deploy / uploads all the reports one by one, then we are getting the error at
the time of upload as â'The underlying connection was closed: Could not
establish trust relationship with remote server.â'
Method 2: From Reports Designer window, we set build mode as â'Productionâ'
and set all the project environments as Production environment and made a
build and then made deploy. After that we are getting an error as "A
Connection could not be made to the report server
http://servername/reportserver". Later we manually copying all the reports
into Production environment and trying to open the reports, then we are not
able to open / call those reports from our application. Here we could not
able to connect or do not know what to do after copying of the reports into
physical environment of the application.
Method 3: We search thru google and few forums, and then we got to know that
we can deploy reports from the script also. So we tried to do the same as per
their instructions, then we got the error in command prompt as below:
E:\New Folder\Files\Dev2.0\ProfessionalServices\REPORTS>rs -i ps_reports.rss
â's http://servername/reportserver -v parentfolder="DBDReports"
The operation you are attempting requires a secure connection (HTTPS). -->
The operation you are attempting requires a secure connection (HTTPS).
The operation you are attempting requires a secure connection (HTTPS). -->
The operation you are attempting requires a secure connection (HTTPS).
The operation you are attempting requires a secure connection (HTTPS). -->
The operation you are attempting requires a secure connection (HTTPS).
The operation you are attempting requires a secure connection (HTTPS). -->
The operation you are attempting requires a secure connection (HTTPS).
The operation you are attempting requires a secure connection (HTTPS). -->
The operation you are attempting requires a secure connection (HTTPS).
The command completed successfully
Kindly help us to resolve this issue and thanks in advance for your help.
Regards,
nsbThe best way to work this out is from the development environment. You can
deploy a single report by doing a right mouse click on the report and
deploy. What error if any are you getting? Do you have the rights to
publish? One easy thing to try in that regard is to add your user to the
local adminstrators group on the server.
I am betting that you are not part of the administrators group and you were
on the development server. You need to have someone who is in that group to
add you to the appropriate roll in RS.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"nsb" <nsb@.discussions.microsoft.com> wrote in message
news:8327C9F9-4320-4D0B-84F2-B636A0CAC04C@.microsoft.com...
> Hi All,
> I am facing the issue while deploying Reporting Services 2000 Reports in
> Production environment (Windows NT Server and SQL Server 2000) in our
> application.
> Background: I developed few reports using SQL Server Reporting Services
> 2000
> and are able to deploy in Development environment and those reports are
> working fine without any issues.
> When we are trying to deploy the same in our Production environment, then
> we
> are facing some issue during the deployment time and not able to deploy
> those
> reports into it. We are followed 3 ways to deploy the same as mentioned
> below:
> Method 1: From Application or report manager screen
> (http://servername/reports or http://localhost/reports ) we are trying to
> deploy / uploads all the reports one by one, then we are getting the error
> at
> the time of upload as "The underlying connection was closed: Could not
> establish trust relationship with remote server."
> Method 2: From Reports Designer window, we set build mode as "Production"
> and set all the project environments as Production environment and made a
> build and then made deploy. After that we are getting an error as "A
> Connection could not be made to the report server
> http://servername/reportserver". Later we manually copying all the reports
> into Production environment and trying to open the reports, then we are
> not
> able to open / call those reports from our application. Here we could not
> able to connect or do not know what to do after copying of the reports
> into
> physical environment of the application.
> Method 3: We search thru google and few forums, and then we got to know
> that
> we can deploy reports from the script also. So we tried to do the same as
> per
> their instructions, then we got the error in command prompt as below:
> E:\New Folder\Files\Dev2.0\ProfessionalServices\REPORTS>rs -i
> ps_reports.rss
> -s http://servername/reportserver -v parentfolder="DBDReports"
> The operation you are attempting requires a secure connection (HTTPS). -->
> The operation you are attempting requires a secure connection (HTTPS).
> The operation you are attempting requires a secure connection (HTTPS). -->
> The operation you are attempting requires a secure connection (HTTPS).
> The operation you are attempting requires a secure connection (HTTPS). -->
> The operation you are attempting requires a secure connection (HTTPS).
> The operation you are attempting requires a secure connection (HTTPS). -->
> The operation you are attempting requires a secure connection (HTTPS).
> The operation you are attempting requires a secure connection (HTTPS). -->
> The operation you are attempting requires a secure connection (HTTPS).
> The command completed successfully
> Kindly help us to resolve this issue and thanks in advance for your help.
> Regards,
> nsb