Share via

SSRS 2019 - Getting Error while creating Datasource

DU16 1 Reputation point
2021-07-05T09:31:56.917+00:00

Hi all,

Installed SSRS 2019 in my Machine and trying to connect the Remote server Database SQL server 2018.
When i run the web portal URL and it shows the homepage of SSRS when i trying to create Data source and its says Something went wrong and Web service URL shows HTTP 500 error. I checked the Remote DB , report server and report server temp db. was created that means connection is OK .plz clarify what is the error?
111862-ssass.png
111748-ssss.png

Error in Log:

2021-07-05 18:09:21.8279|ERROR|8|OData exception occurred: Microsoft.SqlServer.ReportingServices2010.RSConnection2010+MissingEndpointException: The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. ---> System.InvalidOperationException: Client found response content type of '', but expected 'text/xml'.

The request failed with an empty response.
at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SetConnectionProtocol()
at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SoapMethodWrapper1.ExecuteMethod(Boolean setConnectionProtocol) --- End of inner exception stack trace --- at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SoapMethodWrapper1.ExecuteMethod(Boolean setConnectionProtocol)
at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.ListExtensions(String extensionType)
at Microsoft.ReportingServices.Portal.Services.SoapProxy.SoapAuthenticationHelper.ExecuteWithWindowsAuthTReturn
at Microsoft.ReportingServices.Portal.Repositories.SystemService.GetExtensions(IPrincipal userPrincipal, ExtensionType extensionType)
at Microsoft.ReportingServices.Portal.Repositories.SystemService.ListExtensions(IPrincipal userPrincipal, ExtensionType extensionType)
at Microsoft.ReportingServices.Portal.ODataWebApi.V2.Controllers.ExtensionsController.GetEntitySet(String castName)
at Microsoft.ReportingServices.Portal.ODataWebApi.Controllers.Reflection.ReflectionODataController1.Get(ODataPath oDataPath) at lambda_method(Closure , Object , Object[] ) at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass6_2.<GetExecutor>b__2(Object instance, Object[] methodParameters) at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary2 arguments, CancellationToken cancellationToken)
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__6.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__6.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Filters.ActionFilterAttribute.<ExecuteActionFilterAsyncCore>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Controllers.ExceptionFilterResult.<ExecuteAsync>d__6.MoveNext().| RequestID = s_6a4ea515-0336-495c-a81b-6c92dbd9465b
2021-07-05 18:09:21.8359|INFO|8|Sending response. Response code CONTROL-NB2\ravan 500, Elapsed time 0:00:05.3050159| RequestID = s_6a4ea515-0336-495c-a81b-6c92dbd9465b
2021-07-05 18:09:30.3194|INFO|8|Received request GET /api/v2.0/CatalogItems(Path='/')/AllowedActions| RequestID = s_ee211593-0dae-4fad-8538-0f06797aa101
2021-07-05 18:09:30.3224|INFO|7|Received request GET /api/v2.0/CatalogItems(Path='/')| RequestID = s_cbb0d9ab-4d76-4303-ab84-e8c137502745
2021-07-05 18:09:30.3224|INFO|20|Received request GET /api/v2.0/Folders(Path='/')/AllowedActions| RequestID = s_dbdc2fb7-c077-4a24-8f72-925b77407294
2021-07-05 18:09:30.3384|INFO|5|Sending response. Response code CONTROL-NB2\ravan 200, Elapsed time 0:00:00.0152663| RequestID = s_cbb0d9ab-4d76-4303-ab84-e8c137502745
2021-07-05 18:09:30.3384|INFO|6|Sending response. Response code CONTROL-NB2\ravan 200, Elapsed time 0:00:00.0265045| RequestID = s_ee211593-0dae-4fad-8538-0f06797aa101
2021-07-05 18:09:30.3384|INFO|6|Sending response. Response code CONTROL-NB2\ravan 200, Elapsed time 0:00:00.0267303| RequestID = s_dbdc2fb7-c077-4a24-8f72-925b77407294
2021-07-05 18:09:30.4614|INFO|20|Received request GET /api/v2.0/catalogitems(4e5346f4-dcdb-4a7a-90ba-bff327cf18f8)/Model.Folder/catalogitems/| RequestID = s_4fd04b58-3e1d-44a5-b686-25170ab8a226
2021-07-05 18:09:30.5004|INFO|6|Sending response. Response code CONTROL-NB2\ravan 200, Elapsed time 0:00:00.0394247| RequestID = s_4fd04b58-3e1d-44a5-b686-25170ab8a226
2021-07-05 18:09:32.1655|INFO|20|Received request GET /api/v2.0/Folders(Path='/Reports')/AllowedActions| RequestID = s_862923e6-ca69-468d-ba74-83369d1352e6
2021-07-05 18:09:32.1845|INFO|15|Sending response. Response code CONTROL-NB2\ravan 200, Elapsed time 0:00:00.0190995| RequestID = s_862923e6-ca69-468d-ba74-83369d1352e6
2021-07-05 18:09:33.8666|INFO|20|Received request GET /api/v2.0/CatalogItems(Path='/Reports')/AllowedActions| RequestID = s_c1a57a82-4a85-4b9e-8cd4-0e69223a22ef
2021-07-05 18:09:33.8676|INFO|8|Received request GET /api/v2.0/CatalogItems(Path='/Reports')/AllowedActions| RequestID = s_f90cbc3a-582b-405d-b874-f9efd1d87541
2021-07-05 18:09:33.8676|INFO|7|Received request GET /api/v2.0/CatalogItems(Path='/Reports')| RequestID = s_b7cd8521-dc2c-478d-8dbc-10204b63c9c7
2021-07-05 18:09:33.8916|INFO|22|Sending response. Response code CONTROL-NB2\ravan 200, Elapsed time 0:00:00.0252433| RequestID = s_c1a57a82-4a85-4b9e-8cd4-0e69223a22ef
2021-07-05 18:09:33.8916|INFO|24|Sending response. Response code CONTROL-NB2\ravan 200, Elapsed time 0:00:00.0238021| RequestID = s_f90cbc3a-582b-405d-b874-f9efd1d87541
2021-07-05 18:09:33.9246|INFO|28|Sending response. Response code CONTROL-NB2\ravan 200, Elapsed time 0:00:00.0491529| RequestID = s_b7cd8521-dc2c-478d-8dbc-10204b63c9c7
2021-07-05 18:09:35.8697|INFO|7|Received request GET /api/v2.0/CatalogItems(Path='/Reports')| RequestID = s_5dc602a8-bb8a-4de8-ab8b-9d313519baaf
2021-07-05 18:09:35.8917|INFO|24|Sending response. Response code CONTROL-NB2\ravan 200, Elapsed time 0:00:00.022108| RequestID = s_5dc602a8-bb8a-4de8-ab8b-9d313519baaf
2021-07-05 18:09:36.0087|INFO|7|Received request GET /api/v2.0/Folders(30318dd6-6ae9-4f90-8bbc-4bec2236e261)/Policies| RequestID = s_6fa3797e-b4b7-4465-973c-c72a96f6d047
2021-07-05 18:09:36.0577|INFO|29|Sending response. Response code CONTROL-NB2\ravan 200, Elapsed time 0:00:00.049133| RequestID = s_6fa3797e-b4b7-4465-973c-c72a96f6d047
2021-07-05 18:09:45.6283|INFO|7|Received request GET /api/v2.0/CatalogItems(Path='/Reports')| RequestID = s_cfcedbf8-c786-4459-a8b8-ab136164e013
2021-07-05 18:09:45.6423|INFO|22|Sending response. Response code CONTROL-NB2\ravan 200, Elapsed time 0:00:00.0135034| RequestID = s_cfcedbf8-c786-4459-a8b8-ab136164e013
2021-07-05 18:09:45.8313|INFO|7|Received request GET /api/v2.0/catalogitems(30318dd6-6ae9-4f90-8bbc-4bec2236e261)/Model.Folder/catalogitems/| RequestID = s_d0910634-8cc8-40a2-ad43-329734f66f9c
2021-07-05 18:09:45.8533|INFO|29|Sending response. Response code CONTROL-NB2\ravan 200, Elapsed time 0:00:00.0228838| RequestID = s_d0910634-8cc8-40a2-ad43-329734f66f9c

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,878 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Joyzhao-MSFT 15,571 Reputation points
    2021-07-06T02:59:50.303+00:00

    Hi @DU16 ，

    OData exception occurred: Microsoft.SqlServer.ReportingServices2010.RSConnection2010+MissingEndpointException: The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version.

    Based on your error log, it seems you specify the Reporting Services Management Endpoint( https://localhost/ReportServer/ReportService2010.asmx) as the report server URL. Please check the Web Service URL, it supposed to be like "http://<server name>/ReportServer“.

    Please refer to the following link to reconfigure the URL: Configure Report Server URLs (Report Server Configuration Manager).
    Restart the server after completing the configuration.
    Best Regards,
    Joy

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.