question

DU16-4192 avatar image
0 Votes"
DU16-4192 asked Joyzhao-MSFT commented

SSRS 2019 - Getting Error while creating Datasource

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.SoapMethodWrapper`1.ExecuteMethod(Boolean setConnectionProtocol)
--- End of inner exception stack trace ---
at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SoapMethodWrapper`1.ExecuteMethod(Boolean setConnectionProtocol)
at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.ListExtensions(String extensionType)
at Microsoft.ReportingServices.Portal.Services.SoapProxy.SoapAuthenticationHelper.ExecuteWithWindowsAuth[TReturn](SoapHttpClientProtocol soapClient, IPrincipal userPrincipal, Func`1 func)
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.ReflectionODataController`1.Get(ODataPath oDataPath)
at lambda_method(Closure , Object , Object[] )
at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c_DisplayClass6_2.<GetExecutor>b2(Object instance, Object[] methodParameters)
at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 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
ssass.png (81.1 KiB)
ssss.png (58.5 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered Joyzhao-MSFT commented

Hi @DU16-4192

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.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @Joyzhao-MSFT ,

I gave the Report URL in web service as you say like below,
http://control-ss1/ReportServer2019 but am getting HTTP 500 Internal Server Error .
In Web portal display the Homepage but cannot able to create a data source. Do i need to change any configuration in web or rsreportserver file. In my hosting machine , is there any requirements need to install like IIS,etc?

0 Votes 0 ·

For situations where you can view the homepage but cannot create a data source, you could refer to this link: Cannot create New data source on SSRS 2016.

Since you are using SSRS2019, rsreportserver.config is located at: C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\ReportServer.


0 Votes 0 ·