Fixing snapshot replication login error

• webrunner

  SSC-Dedicated

  Points: 31984

  More actions

  May 21, 2024 at 2:19 pm

  #4422836

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

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  May 22, 2024 at 3:10 pm

  #4423305

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

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

• webrunner

  SSC-Dedicated

  Points: 31984

  More actions

  February 5, 2025 at 7:03 pm

  #4530657

  Bumping this topic. Thanks for any help.

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