CODEWITHSUNDEEP
c#visual-studio-2008sql-server-2008-r2ssrs-2008
sudheshna
sudheshna

Reputation: 1150

Deploying report shows an error

I'm using SSRS 2008 R2 for my reports.

I have been working in my local environment and there was no problem with deploying to the local server. Now I want to deploy all the reports to live server but when I try to deploy to the live server by changing the Target server url and then providing the user name and password. its showing the error. (I'm deploying from VS 2008) 

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

Could not connect to the report server http://192.168.0.217/ReportServer. Verify that the TargetServerURL is valid and that you have the correct permissions to connect to the report server. (Microsoft SQL Server Report Designer)

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

The underlying connection was closed: An unexpected error occurred on a receive. (System.Web.Services)

------------------------------
Program Location:

   at System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebRequest request)
   at System.Web.Services.Protocols.HttpWebClientProtocol.GetWebResponse(WebRequest request)
   at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
   at Microsoft.SqlServer.ReportingServices2006.ReportServiceAuthentication.GetAuthenticationMode()
   at ReportServiceClient2010.CheckAuthenticated()
   at Microsoft.ReportDesigner.Project.ReportClientManager.DetectEndpointAndAuthenticate(String url, ICredentials credentials, String& authCookieName, Cookie& authCookie, EndpointType& endpointType)
   at Microsoft.ReportDesigner.Project.ReportClientManager.DetectEndpointAndAuthenticate(String url, ConnectionProperties& connectionProperties)
   at Microsoft.ReportDesigner.Project.ReportClientManager.GetCredentials(String url, CancelFlag cancelFlag)
   at Microsoft.ReportDesigner.Project.ReportProjectDeployer.PrepareDeploy()

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

Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. (System)

------------------------------
Program Location:

   at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
   at System.Net.PooledStream.Read(Byte[] buffer, Int32 offset, Int32 size)
   at System.Net.Connection.SyncRead(HttpWebRequest request, Boolean userRetrievedStream, Boolean probeRead)

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

An existing connection was forcibly closed by the remote host (System)

------------------------------
Program Location:

   at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
   at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)

But Im able to browse the report server from my local machine by providing the credentials. Anyone knowsa solution for this?

Upvotes: 1

Views: 2160

Answers (1)

bhupendra patel
bhupendra patel

Reputation: 3179

Try this , should help mostly. Also try and see if you are able to upload reports one by one using the Upload facility on the SSRS server itself http://www.sqlservercentral.com/Forums/Topic1135602-150-1.aspx#bm1135709

Upvotes: 2

Related Questions