Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. how2trainyourdragon

    SSRS export report as JSON

    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...
  2. how2trainyourdragon

    SSIS Web Service task SSL errors

    Not sure if makes a difference, but just told by db/server admin this web service is setup for cookie authentication.
  3. how2trainyourdragon

    SSIS Web Service task SSL errors

    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...
  4. how2trainyourdragon

    SQL Server 2016 to 2019 now SSRS Cannot create a connection to data source

    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...
  5. how2trainyourdragon

    SQL Server 2016 to 2019 now SSRS Cannot create a connection to data source

    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...
  6. how2trainyourdragon

    Request.Server variables blank for classic ASP

    Admin set authentication property on main/root site and that seemed to fix the issue.
  7. how2trainyourdragon

    Request.Server variables blank for classic ASP

    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
  8. how2trainyourdragon

    Request.Server variables blank for classic ASP

    LOL...yeah, already did...and copy/highlighted that last forum reply.
  9. how2trainyourdragon

    Request.Server variables blank for classic ASP

    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...
  10. how2trainyourdragon

    Request.Server variables blank for classic ASP

    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.
  11. how2trainyourdragon

    Request.Server variables blank for classic ASP

    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>...
  12. how2trainyourdragon

    Request.Server variables blank for classic ASP

    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...

Part and Inventory Search

Back
Top