In order for this to work, your web server that is hosting wordpress must have connectivity to the on-premise SSRS report server. If you are using a hosted provider and there is no direct path from the web server, it won’t work.
If you do have on-premise wordpress + reportserver and the servers can access each other then you need to make sure to enable basic authentication in the report server configuration. This is not on by default.
Likely it is one of these two issues, hope this helps!
Sincerely,
Module Masters
well, it turns out, the fix is the same as the other thread.
replace http://servername/reportserver
with http://X.X.X.X.X/reportserver
using ip number works
-
This reply was modified 2 years, 6 months ago by
Alan Cave.
Hi There,
Having exactly the same issue, have used the ip address and still giving me the same error. I am able to access the report through the web browser. So am now not sure what the problem is. Using SQL Server 2014.
@surenkasil did you confirm
1) you have basic auth turned on the report server
2) your web server can ping and access the ssrs server
Yes I basic auth turned on.
<Authentication>
<AuthenticationTypes>
<RSWindowsBasic/>
</AuthenticationTypes>
<EnableAuthPersistence>true</EnableAuthPersistence>
</Authentication>
From the webserver, I can ping to the ssrs server, internally, it is on the same machine.
However, the other website that is running the report is elsewhere.
I have opened the firewalls.
I can also connect to the server from an outside browser.
Check the reporting server log files and see if you are seeing any hints as far as what is going on. What version of WP are you using? What are you using for the report server URL?
Looked into the server logfiles, eventviewer cannot see anything that is giving any idea on why it is not working. I am using WordPress 5.9.2 On the url I have tried both the ssl certificate and also the direct ip address to test. I am able to get access via the browser and everything works but not on WordPress.
What are you using for the report server URL? Is the report server accessible from the internet? If so, email service@modulemasters.com and we are happy to test from our side as well.
I have sent through an email with more information.
Thank you for your trying to assist.
I found what my issue was
<AuthenticationTypes>
<RSWindowsBasic/>
</AuthenticationTypes>
<RSWindowsExtendedProtectionLevel>Off</RSWindowsExtendedProtectionLevel>
<RSWindowsExtendedProtectionScenario>Proxy</RSWindowsExtendedProtectionScenario>
<EnableAuthPersistence>true</EnableAuthPersistence>
I needed to change this Proxy to Any and restart the SQL Server Reporting Services in Services. I was only looking at Basic <RSWindowsBasic> and missed the Proxy, I am using SQL 2019.
Configure Basic Authentication on the Report Server https://docs.microsoft.com/en-us/sql/reporting-services/security/configure-basic-authentication-on-the-report-server?view=sql-server-2017
