We use SP2016 with SQL 2016 Enterprise Edition. The SSRS feature is enabled in SQL Server and the service has started. I can browse the SSRS portal with http: // sqlserver / reports. In addition, I can connect to the report server in my SQL 2016 Report Builder: http: // sqlserver / ReportServer /
Then I set up my first data source in a report. Connection type is Microsoft SharePoint list, In the connection string field, I enter "https://sharepoint.com/sites/dev". This URL can be searched correctly both on my PC and in SQL Server.
in the references I tried all possible combinations. I tried my personal account (this is site collection administrator) and SQL administrator and farm administrator, etc. All the results in error message
An error occurred while accessing the specified SharePoint list. The
Connection string may be invalid. Check the connection
String is correct.
I tried to upload the report to the SSRS web portal (http: // sqlserver / reports), and the error has also occurred.
May I know why that might be? Is there a patch specifically for this problem?