Hi Technet, I had successfully configured Log Shipping in a domain. In configuration manager, The SQL Server account (Both sql server and agent) are domain administrator account only. The Primary and Secondary Shared folders are given full permissions of Read Write access to Everyone. Now, the 'COPY' Job getting failed due to error: Message 2016-09-26 06:53:43.12 *** Error: The password for this account has expired. (mscorlib) *** 2016-09-26 06:53:43.20 *** Error: Could not log history/error message.(Microsoft.SqlServer.Management.LogShipping) *** Can someone help me there.?
I reckon your SQL Agent service is running under a domain account that has expired due to Group Policy settings. Look in SQL Server Configuration Tool or the Services Control Panel applet to see which account the SQL Agent service is running under. In SQL Server Management Studio, find that login and right click to look at its properties. If 'Enforce password expiration' is ticked it means Windows account expiration policies are applied to that account. That might be at the machine level or at a higher level in Active Directory. I don't know how this works as I don't use it, but if this is your problem you'll p[robably need some domain admin help to sort it out.