Deploying reports on Production server

hello experts,

i need help with deployment of reports (SSRS 2005). we need to deploy many reports (more then 100) on the production everytime we make changes in them.

"the problem is we cannot install visual studio on the server to open the project and use the deploy option from it" i tried using the script - PublishSampleReports.rss

but everytime i run i need to go and manully configure the report to map the shared datasource to it. any way to pass the information in the script itself, or is there any smart way to deploy on production.

/chandresh soni

Hello Chandresh,

You can deploy to your production server from your local machine, or wherever you develop the reports.

Open your report project and go to Properties from the Project menu. From here, you can change your TargetServerURL to be your production server, then when you deploy the reports, they will go there.

Hope this helps.

Jarret

|||

Hi Jarret,

when i try to deploy on the remote server through my local report Solution then i get the below error.

===================================

A connection could not be made to the report server http://seldapp113.corpusers.net/ReportServer. (Microsoft Report Designer)

===================================

The request failed with HTTP status 407: Proxy Authentication Required. (System.Web.Services)

Program Location:

at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Microsoft.SqlServer.ReportingServices2006.ReportServiceAuthentication.GetAuthenticationMode()
at Microsoft.ReportDesigner.Project.ReportServiceClient2006.CheckAuthenticated()
at Microsoft.ReportDesigner.Project.ReportClientManager.DetectEndpointAndAuthenticate(String url, ICredentials credentials, String& authCookieName, Cookie& authCookie, EndpointType& endpointType)
at Microsoft.ReportDesigner.Project.ReportClientManager.GetCredentials(String url)
at Microsoft.ReportDesigner.Project.ReportProjectDeployer.PrepareDeploy()

any solution?