none
Site Server Computer can no longer authenticate to SQL Server

    Question

  • We have a site server (CAS specifically in our test hierarchy) that randomly started being unable to authenticate to the SQL Server. The server is running CB 1806 and was upgraded in early October and the last time the sync between the CAS and child sites was successful (and I would imagine coincides with the onset of this issue) was late November, so I do not suspect it was upgrade related.

    The error in the SQL logs is:

    "2019-01-11 14:00:17.12 Logon       Login failed for user '<ComputerNameRedacted>'.
    Reason: Could not find a login matching the name provided. [CLIENT: 10.1.71.31]
    2019-01-11 14:00:17.13 Logon       Error: 18456, Severity: 14, State: 5."

    Any idea what might have caused this? My initial googling did not find any solid leads.
    Friday, January 11, 2019 7:46 PM

All replies