SQL Server 2019 problems deploying reports

%3CLINGO-SUB%20id%3D%22lingo-sub-1440788%22%20slang%3D%22en-US%22%3ESQL%20Server%202019%20problems%20deploying%20reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1440788%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20an%20Windows%20Server%202019%20in%20the%20cloud%20with%20Visual%20Studio%202019%20and%20SQL%20Server%202019%20installed%20on%20it.%26nbsp%3B%20When%20I%20try%20to%20deploy%20reports%20to%20the%20same%20server%20(i.e.%20local%20server%20-%20I%20do%20use%20the%20hostname%20and%20not%20%22local%20server%22)%20I%20get%20this%20error%3A%3C%2FP%3E%3CDIV%3E%3CFONT%3E%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3C%2FFONT%3E%3C%2FDIV%3E%3CDIV%3E%3CFONT%3ECould%20not%20connect%20to%20the%20report%20server%20https%3A%2F%2Fxxxxxxxxxxxxx%2FReportServer.%20Verify%20that%20the%20TargetServerURL%20is%20valid%20and%20that%20you%20have%20the%20correct%20permissions%20to%20connect%20to%20the%20report%20server.%20(Microsoft%20SQL%20Server%20Report%20Designer)%3C%2FFONT%3E%3C%2FDIV%3E%3CDIV%3E%3CFONT%3E%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3C%2FFONT%3E%3C%2FDIV%3E%3CDIV%3E%3CFONT%3EThe%20underlying%20connection%20was%20closed%3A%20Could%20not%20establish%20trust%20relationship%20for%20the%20SSL%2FTLS%20secure%20channel.%20(System.Web.Services)%3C%2FFONT%3E%3C%2FDIV%3E%3CDIV%3E%3CFONT%3E------------------------------%3CBR%20%2F%3E%3CBR%20%2F%3EProgram%20Location%3A%3C%2FFONT%3E%3C%2FDIV%3E%3CDIV%3E%3CFONT%3E%26nbsp%3B%26nbsp%3B%20at%20System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebRequest%20request)%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20at%20ReportServiceClient2010.GetWebResponse(WebRequest%20request)%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20at%20System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String%20methodName%2C%20Object%5B%5D%20parameters)%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20at%20Microsoft.SqlServer.ReportingServices2010.ReportingService2010.ListItemTypes()%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20at%20Microsoft.SqlServer.ReportingServices2010.RSConnection2010.%3CLISTITEMTYPES%3Eb__127_0()%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20at%20Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SoapMethodWrapper%601.ExecuteMethod(Boolean%20setConnectionProtocol)%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20at%20Microsoft.SqlServer.ReportingServices2010.RSConnection2010.ListItemTypes()%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20at%20ReportServiceClient2010.CheckAuthenticated()%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20at%20Microsoft.ReportDesigner.Project.ReportClientManager.DetectEndpointAndAuthenticate(String%20url%2C%20ICredentials%20credentials%2C%20String%26amp%3B%20authCookieName%2C%20Cookie%26amp%3B%20authCookie%2C%20EndpointType%26amp%3B%20endpointType)%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20at%20Microsoft.ReportDesigner.Project.ReportClientManager.DetectEndpointAndAuthenticate(String%20url%2C%20ConnectionProperties%26amp%3B%20connectionProperties)%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20at%20Microsoft.ReportDesigner.Project.ReportClientManager.GetCredentials(String%20url%2C%20CancelFlag%20cancelFlag%2C%20IPromptCreds%20promptCredentials)%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20at%20Microsoft.ReportDesigner.Project.ReportProjectDeployer.PrepareDeploy()%3C%2FLISTITEMTYPES%3E%3C%2FFONT%3E%3C%2FDIV%3E%3CDIV%3E%3CFONT%3E%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3C%2FFONT%3E%3C%2FDIV%3E%3CDIV%3E%3CFONT%3EThe%20remote%20certificate%20is%20invalid%20according%20to%20the%20validation%20procedure.%20(System)%3C%2FFONT%3E%3C%2FDIV%3E%3CDIV%3E%3CFONT%3E------------------------------%3CBR%20%2F%3E%3CBR%20%2F%3EProgram%20Location%3A%3C%2FFONT%3E%3C%2FDIV%3E%3CDIV%3E%3CFONT%3E%26nbsp%3B%26nbsp%3B%20at%20System.Net.Security.SslState.StartSendAuthResetSignal(ProtocolToken%20message%2C%20AsyncProtocolRequest%20asyncRequest%2C%20Exception%20exception)%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20at%20System.Net.Security.SslState.CheckCompletionBeforeNextReceive(ProtocolToken%20message%2C%20AsyncProtocolRequest%20asyncRequest)%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20at%20System.Net.Security.SslState.StartSendBlob(Byte%5B%5D%20incoming%2C%20Int32%20count%2C%20AsyncProtocolRequest%20asyncRequest)%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20at%20System.Net.Security.SslState.ProcessReceivedBlob(Byte%5B%5D%20buffer%2C%20Int32%20count%2C%20AsyncProtocolRequest%20asyncRequest)%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20at%20System.Net.Security.SslState.StartReadFrame(Byte%5B%5D%20buffer%2C%20Int32%20readBytes%2C%20AsyncProtocolRequest%20asyncRequest)%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20at%20System.Net.Security.SslState.StartReceiveBlob(Byte%5B%5D%20buffer%2C%20AsyncProtocolRequest%20asyncRequest)%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20at%20System.Net.Security.SslState.CheckCompletionBeforeNextReceive(ProtocolToken%20message%2C%20AsyncProtocolRequest%20asyncRequest)%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20at%20System.Net.Security.SslState.StartSendBlob(Byte%5B%5D%20incoming%2C%20Int32%20count%2C%20AsyncProtocolRequest%20asyncRequest)%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20at%20System.Net.Security.SslState.ProcessReceivedBlob(Byte%5B%5D%20buffer%2C%20Int32%20count%2C%20AsyncProtocolRequest%20asyncRequest)%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20at%20System.Net.Security.SslState.StartReadFrame(Byte%5B%5D%20buffer%2C%20Int32%20readBytes%2C%20AsyncProtocolRequest%20asyncRequest)%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20at%20System.Net.Security.SslState.StartReceiveBlob(Byte%5B%5D%20buffer%2C%20AsyncProtocolRequest%20asyncRequest)%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20at%20System.Net.Security.SslState.CheckCompletionBeforeNextReceive(ProtocolToken%20message%2C%20AsyncProtocolRequest%20asyncRequest)%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20at%20System.Net.Security.SslState.StartSendBlob(Byte%5B%5D%20incoming%2C%20Int32%20count%2C%20AsyncProtocolRequest%20asyncRequest)%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20at%20System.Net.Security.SslState.ProcessReceivedBlob(Byte%5B%5D%20buffer%2C%20Int32%20count%2C%20AsyncProtocolRequest%20asyncRequest)%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20at%20System.Net.Security.SslState.StartReadFrame(Byte%5B%5D%20buffer%2C%20Int32%20readBytes%2C%20AsyncProtocolRequest%20asyncRequest)%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20at%20System.Net.Security.SslState.StartReceiveBlob(Byte%5B%5D%20buffer%2C%20AsyncProtocolRequest%20asyncRequest)%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20at%20System.Net.Security.SslState.CheckCompletionBeforeNextReceive(ProtocolToken%20message%2C%20AsyncProtocolRequest%20asyncRequest)%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20at%20System.Net.Security.SslState.StartSendBlob(Byte%5B%5D%20incoming%2C%20Int32%20count%2C%20AsyncProtocolRequest%20asyncRequest)%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20at%20System.Net.Security.SslState.ForceAuthentication(Boolean%20receiveFirst%2C%20Byte%5B%5D%20buffer%2C%20AsyncProtocolRequest%20asyncRequest)%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20at%20System.Net.Security.SslState.ProcessAuthentication(LazyAsyncResult%20lazyResult)%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20at%20System.Net.TlsStream.CallProcessAuthentication(Object%20state)%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20at%20System.Threading.ExecutionContext.RunInternal(ExecutionContext%20executionContext%2C%20ContextCallback%20callback%2C%20Object%20state%2C%20Boolean%20preserveSyncCtx)%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20at%20System.Threading.ExecutionContext.Run(ExecutionContext%20executionContext%2C%20ContextCallback%20callback%2C%20Object%20state%2C%20Boolean%20preserveSyncCtx)%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20at%20System.Threading.ExecutionContext.Run(ExecutionContext%20executionContext%2C%20ContextCallback%20callback%2C%20Object%20state)%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20at%20System.Net.TlsStream.ProcessAuthentication(LazyAsyncResult%20result)%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20at%20System.Net.TlsStream.Write(Byte%5B%5D%20buffer%2C%20Int32%20offset%2C%20Int32%20size)%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20at%20System.Net.PooledStream.Write(Byte%5B%5D%20buffer%2C%20Int32%20offset%2C%20Int32%20size)%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20at%20System.Net.ConnectStream.WriteHeaders(Boolean%20async)%3C%2FFONT%3E%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3EIf%20I%20use%20the%20same%20user%20on%20my%20laptop%20and%20deploy%20to%20the%20server%20using%20Visual%20Studio%20I%20do%20not%20have%20any%20problems.%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3EI%20can%20preview%20the%20report%20on%20my%20laptop%20and%20on%20the%20server%20in%20Visual%20Studio%20with%20no%20problem.%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3EIf%20I%20try%20to%20open%20the%20report%20on%20my%20laptop%20in%20IE%20I%20get%20this%20error%3A%3C%2FDIV%3E%3CDIV%3E%3CP%3E%22An%20error%20has%20occurred%20during%20report%20processing.%20(rsProcessingAborted)%3C%2FP%3E%3CP%3ECannot%20create%20a%20connection%20to%20data%20source%20'xxxxxxxxx'.%20(rsErrorOpeningConnection)%3C%2FP%3E%3CP%3EFor%20more%20information%20about%20this%20error%20navigate%20to%20the%20report%20server%20on%20the%20local%20server%20machine%2C%20or%20enable%20remote%20errors%22%3C%2FP%3E%3CP%3EAny%20ideas%20what%20may%20be%20causing%20my%20problem%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFred%3C%2FP%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1440788%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EReporting%20Services%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

I have an Windows Server 2019 in the cloud with Visual Studio 2019 and SQL Server 2019 installed on it.  When I try to deploy reports to the same server (i.e. local server - I do use the hostname and not "local server") I get this error:

===================================
Could not connect to the report server https://xxxxxxxxxxxxx/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: Could not establish trust relationship for the SSL/TLS secure channel. (System.Web.Services)
------------------------------
Program Location:
   at System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebRequest request)
   at ReportServiceClient2010.GetWebResponse(WebRequest request)
   at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
   at Microsoft.SqlServer.ReportingServices2010.ReportingService2010.ListItemTypes()
   at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.<ListItemTypes>b__127_0()
   at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SoapMethodWrapper`1.ExecuteMethod(Boolean setConnectionProtocol)
   at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.ListItemTypes()
   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, IPromptCreds promptCredentials)
   at Microsoft.ReportDesigner.Project.ReportProjectDeployer.PrepareDeploy()
===================================
The remote certificate is invalid according to the validation procedure. (System)
------------------------------
Program Location:
   at System.Net.Security.SslState.StartSendAuthResetSignal(ProtocolToken message, AsyncProtocolRequest asyncRequest, Exception exception)
   at System.Net.Security.SslState.CheckCompletionBeforeNextReceive(ProtocolToken message, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.StartSendBlob(Byte[] incoming, Int32 count, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.ProcessReceivedBlob(Byte[] buffer, Int32 count, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.StartReadFrame(Byte[] buffer, Int32 readBytes, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.StartReceiveBlob(Byte[] buffer, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.CheckCompletionBeforeNextReceive(ProtocolToken message, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.StartSendBlob(Byte[] incoming, Int32 count, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.ProcessReceivedBlob(Byte[] buffer, Int32 count, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.StartReadFrame(Byte[] buffer, Int32 readBytes, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.StartReceiveBlob(Byte[] buffer, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.CheckCompletionBeforeNextReceive(ProtocolToken message, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.StartSendBlob(Byte[] incoming, Int32 count, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.ProcessReceivedBlob(Byte[] buffer, Int32 count, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.StartReadFrame(Byte[] buffer, Int32 readBytes, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.StartReceiveBlob(Byte[] buffer, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.CheckCompletionBeforeNextReceive(ProtocolToken message, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.StartSendBlob(Byte[] incoming, Int32 count, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.ForceAuthentication(Boolean receiveFirst, Byte[] buffer, AsyncProtocolRequest asyncRequest)
   at System.Net.Security.SslState.ProcessAuthentication(LazyAsyncResult lazyResult)
   at System.Net.TlsStream.CallProcessAuthentication(Object state)
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Net.TlsStream.ProcessAuthentication(LazyAsyncResult result)
   at System.Net.TlsStream.Write(Byte[] buffer, Int32 offset, Int32 size)
   at System.Net.PooledStream.Write(Byte[] buffer, Int32 offset, Int32 size)
   at System.Net.ConnectStream.WriteHeaders(Boolean async)
 
 
If I use the same user on my laptop and deploy to the server using Visual Studio I do not have any problems.
 
I can preview the report on my laptop and on the server in Visual Studio with no problem.
 
If I try to open the report on my laptop in IE I get this error:

"An error has occurred during report processing. (rsProcessingAborted)

Cannot create a connection to data source 'xxxxxxxxx'. (rsErrorOpeningConnection)

For more information about this error navigate to the report server on the local server machine, or enable remote errors"

Any ideas what may be causing my problem?

 

Fred

0 Replies