SQL Log Shipping Error: Logon Failure The Target Account Name Is Incorrect

marc_butler
marc_butler used Ask the Experts™
on
Hi,

I've been successfully using log shipping from my main server to my disaster recovery server for several months now without a problem but this morning I come in to find it's just stopped working with an error I've so far been unable to resolve.

I've tried the actions described in the following Microsoft article on the DR server but it had no effect. http://support.microsoft.com/kb/325850

Both servers are running Windows Server 2003 Enterprise, it should also be noted that 1 other server I have on the same local network as the main domain controller is having similar issues accessing any network drives on the main server.

Any suggestions would be appreciated.

Thanks
Error.jpg
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2014

Commented:
Probably the best bet is to create a regular domain user account that is local admin on both servers. Then change the SQL Server and SQL Server Agent (and the rest of the SQL services) to use that account.

That should solve the log shipping issue.

Author

Commented:
Upon further testing it would seem to be somewhat DNS related, I changed the log shipping options to use the DR servers ip address rather than its computer name and this solved the issue.
Most Valuable Expert 2014

Commented:
The SQL Server Browser service is the one that is supposed to register the SQL Server with DNS. Or is the Windows server not registering?
For now I'm just using the IP address to get round this.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial