We are using SQL Server Management studio to develop a stored procedure that outputs data to JSON via "FOR JSON PATH"
The issue we have is trying to use SSRS to utilize this SPROC and have the data exported as a .json file.
Any way to do this via SSRS?
Currently we are trying table or textbox...
I've tried different credentials, target server versions, etc. hitting our Primavera WSDL.
Works great in any browser.
Via the Web Service SSIS task, I get an error when running the package:
Target Server 2016:
--1. Connection manager "HTTP Connection Manager 1": SSL certificate response...
We upgraded from SQL Server 2016 to 2019, and our reports on the report server now say:
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'DataSource1'. (rsErrorOpeningConnection)
A network-related or instance-specific error occurred...
We are running a classic ASP app, and the upgrade to IIS 8.5 caused our Request.Server variables to be blank:
AUTH_USER
LOGON_USER
Windows Auth is the default authentication type, and server admin has verified all other options are disabled like Anonymous Authentication
Anything else we should...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.