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 got the report to work by changing our datasource connection string InStr() to uppercase for the first parameter, and the new server URL is uppercased.
Our expression works now after updated to the following, but problem is we have 50+ report to now do this for. Looks like this was due to a...
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...
If we hit site in private browser tab and no prompt for credentials >> looks like anonymous is still allowed in some way.
IIS anonymous is disabled...see attachment.https://files.engineering.com/getfile.aspx?folder=a2c0f887-9ee6-4ac3-aacb-07f857b1f26e&file=anonymous.jpg
Thanks for the link. We saw that one last week too, and I highlighted to our admin the disabling Anonymous Auth. He said it's disabled:
Jesus tapdancing **** 7 years later and this was the only place I could find an answer to this infuriating question! Many thanks, tad_n, for bothering to...
Admin says it's set to Windows..."everything else is disabled".
Anything we can run to prove it's running anonymous?
Admin is only one that can log in to IIS, so we're relying on what he's saying.
Our admin states we're on Windows Auth.
Is there a way to write back to the page showing the site is still using anonymous?
The web.config file is:
<?xml version="1.0" encoding="UTF-8"?>
<configuration>
<system.webServer>
<tracing>
<traceFailedRequests>...
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.