September 5, 2024 at 8:56 pm
The maintenance plan was working great for several years, after replacing one of the servers is failing.
Log summary:
The Execute method on the task returned error code 0x80131904 (Login failed. The login is from an untrusted domain and cannot be used with Integrated authentication.)
Everything else is working fine.
Norbert
September 6, 2024 at 9:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
September 10, 2024 at 5:35 pm
Could possibly be Kerberos SPNs needing to be created for the new server.
The SQL Server service account often needs SPNs created to make a conneciton, or you get anonymous NTLM connections. We used to be able to use the Microsoft Kerberos Configuration Manager for SQL Server, but it doesn't work for SQL 2022 so you'll need to check manually.
To check for registered SPNs created for your service account, run:
setspn -L "ServiceAccountName"
If you don't get results for your server, an Active Directory domain admin need to run the setspn commands.
Here is the Microsoft documentation on it:
Register a Service Principal Name for Kerberos connections - SQL Server | Microsoft Learn
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply