Fixing snapshot replication login error

  • Hello experts,

    We set up the Brent Ozar SQL Agent alerts, one of which sends out an email for Severity 20 errors. We started getting this one every minute yesterday. I was able to run a Profiler trace and narrow down the error to a failed login attempt by a SQL Server replication job. But I don't know how to troubleshoot or stop the failed login attempts.  Does anyone know what I can try?

    Thanks for any help

    -- webrunner.

    SSPI handshake failed with error code 0x8009030c, state 14 while establishing a connection with integrated security; the connection has been closed. Reason: AcceptSecurityContext failed. The operating system error code indicates the cause of failure. The logon attempt failed

    I also found a query online that checks for replication errors. The results are below.

    SELECT *

    FROM distribution..msrepl_errors

    ORDER BY ID DESC

     

    MSSQL_REPL 20084

    Login failed. The login is from an untrusted domain and cannot be used with Integrated authentication.

    MSSQL_ENG 18452

    The process could not connect to Subscriber '[...mysqlserver...]'.

    • This topic was modified 1 month ago by  webrunner.

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply