May 21, 2024 at 2:19 pm
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...]'.
-------------------
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
May 22, 2024 at 3:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
February 5, 2025 at 7:03 pm
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
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy