Sage 100

 View Only

  • 1.  Win Server 2025 and Task Scheduler authentication

    Posted 03-11-2026 14:40

    FYI,

    Posting this before I forget.  On a recent upgrade to a Win Server 2025 (...not sure of the SQL version), I had an authentication issue using a Windows authentication SQL DSN, used by scheduled tasks (Visual Cut and sqlcmd).

    After consulting with Ido (Visual Cut), we seem to believe that Microsoft may have changed how this kind of authentication works... from a Google search:

    It could also be a recent SQL server change...

    While unsure of the actual background of the change / problem, adjusting from Windows authentication to SQL authentication fixed the issues.



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------


  • 2.  RE: Win Server 2025 and Task Scheduler authentication

    Posted 03-12-2026 08:12

    I don't think it's the same thing but I ran into a similar issue with one of my PowerShell scripts a few months back. That was caused by SQL client updates that made changes to NOT trust the server certificates by default. In my case, I updated PowerShell and the modules to get access to new parameters to enable the legacy auth.



    ------------------------------
    Steve Iwanowski, NextStep Technology Advisors, aka DSD Lancaster PA ¯\_(ツ)_/¯
    ------------------------------



  • 3.  RE: Win Server 2025 and Task Scheduler authentication

    Posted 03-12-2026 12:57

    That could certainly be it.  The SQL logs only show the anonymous login failure, but it could have a failover method to try that if encryption fails for a "trusted" connection attempt.  I know SSMS has new options for certificates, but don't see anything about certificates in the DSN settings.



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------

    Original Message


Related Content