Log shipping Copy job is failing

Hi All,

I have issue with Logshipping copy job,Below is the Error. Some body help me what was the mistake in configuration. 

let me know which stage it is failing copy or Paste ?

Microsoft (R) SQL Server Log Shipping Agent

[Assembly Version = 11.0.0.0, File Version = 11.0.2100.60 ((SQL11_RTM).120210-1917 )]
Copyright (c) 2012 Microsoft. All rights reserved.

2015-07-15 09:28:35.58 ----- START OF TRANSACTION LOG COPY   -----
2015-07-15 09:28:40.22 Starting transaction log copy. Secondary ID: '117c7df2-09c7-42b1-a8fb-1f06641f8a01'
2015-07-15 09:28:40.22 Retrieving copy settings. Secondary ID: '117c7df2-09c7-42b1-a8fb-1f06641f8a01'
2015-07-15 09:28:40.22 Retrieved copy settings. Primary Server: '200.115.200.106', Primary Database: 'MyDB', Backup Source Directory: '\\200.115.200.106\sharefoldertest\MyDB', Backup Destination Directory: 'D:\sharefolder\MyDB', Last Copied File: '<None>'
2015-07-15 09:28:40.23 Copying log backup files. Primary Server: '200.115.200.106', Primary Database: 'MyDB', Backup Source Directory: '\\200.115.200.106\sharefoldertest\MyDB', Backup Destination Directory: 'D:\sharefolder\MyDB'
2015-07-15 09:28:40.71 *** Error: The user name or password is incorrect.
(mscorlib) ***
2015-07-15 09:28:40.72 ----- END OF TRANSACTION LOG COPY     -----

Exit Status: 1 (Error)

Regards,

July 15th, 2015 4:43am

can check you have access \\200.115.200.106\sharefoldertest\MyDB ?

The user name or password is incorrect. check it..

Free Windows Admin Tool Kit Click here and download it now
July 15th, 2015 5:02am

Hi VMD,

Yes,I have access to \\200.115.200.106\sharefoldertest\MyDB, this folder configured to access Everyone.

Copy job step

"C:\Program Files\Microsoft SQL Server\110\Tools\Binn\sqllogship.exe" -Copy 117C7DF2-09C7-42B1-A8FB-1F06641F8A01 -server 182.30.100.255 

Is there any way I can pass username/password here in above step ?

Looking forward many replies.

Regards,



  • Edited by MyWish 21 hours 49 minutes ago added more lines
July 15th, 2015 5:16am

Did you changed the service account/password of service account of SQl Sever agent on both or any machines involved in logshipping. Can you please check that you can restart SQl Server agent with current acount it is running
Free Windows Admin Tool Kit Click here and download it now
July 15th, 2015 7:45am

Hi Shanky,

No I never changed services account /password in any machine.

If service account is problem,My backup job and restore job working as expected.

Regards,


July 15th, 2015 8:02am

No I never changed services account /password in any machine.

If service account is problem,My backup job and restore job working as expected.

Seems logical, as per error message it is facing problem while copying data from Primary to secondary so did you also checked that required privilege is there, the error message seems misleading.

What all rights does SQl Server agent account has. I hope both agents are running with same account. is it a domain account. Is logshipping configured between 2 different domain

Free Windows Admin Tool Kit Click here and download it now
July 15th, 2015 8:55am

Hi VMD,

Yes,I have access to \\200.115.200.106\sharefoldertest\MyDB, this folder configured to access Everyone.

Copy job step

"C:\Program Files\Microsoft SQL Server\110\Tools\Binn\sqllogship.exe" -Copy 117C7DF2-09C7-42B1-A8FB-1F06641F8A01 -server 182.30.100.255 

Is there any way I can pass username/password here in above step ?

Looking forward many replies.

Regards,



  • Edited by MyWish Wednesday, July 15, 2015 9:18 AM added more lines
July 15th, 2015 9:14am

Hi Shanky,

Thanks for reply

Sorry for late reply,Below are the Answers.

1.We are using Logshipping fro migration purpose(2008 to 2014).

2. Yes,Two servers are in Different domain and Different DC's as well.

Is there any way to create proxy account to copy files from primary server to secondary server  using same job?

If yes,Please let me know what type of windows is required.

Appreciate your help,thanks in advance

Regards,

Free Windows Admin Tool Kit Click here and download it now
July 15th, 2015 10:23pm

Hi,

Problem here is services Agent service account which may not having read/write permissions on Primary server.

"Make sure that the service account we are using has the read and write access permission on both the servers, for them to be able to copy and paste the T-Log backup without any issue".

Thanks,

Snivas

July 15th, 2015 11:34pm

Hi Shanky,

Thanks for reply

Sorry for late reply,Below are the Answers.

1.We are using Logshipping fro migration purpose(2008 to 2014).

2. Yes,Two servers are in Different domain and Different DC's as well.

Is there any way to create proxy account to copy files from primary server to secondary server  using same job?

If yes,Please let me know what type of windows is required.

Appreciate your help,thanks in advance

Regards,

You dont need to create proxy just add the domain account to have privilege on folder where SQL agent is picking files from see details in below article

https://www.mssqltips.com/sqlservertip/2562/sql-server-log-shipping-to-a-different-domain-or-workgroup/

Free Windows Admin Tool Kit Click here and download it now
July 16th, 2015 12:47am

Hi Shanky,

Thanks for reply,

That means I need a Domain account  in Secondary server and it suppose to have read/write permission on Primary server folder ?  and this domain account should run the  Copy job ?.

Please correct me if I'm wrong ...

Thanks for supporting us.

Regards,

July 16th, 2015 2:51am

Hi Shanky,

Thanks for reply,

That means I need a Domain account  in Secondary server and it suppose to have read/write permission on Primary server folder ?  and this domain account should run the  Copy job ?.

Please correct me if I'm wrong ...

The copy job is performed by SQL Server agent of secondary server so yes the domain account running SQL agent on Secondary server should have read, write permission on folder from where agent is picking up the file I mean the folder on primary server where it is picking up the transaction log backup file.

I hope this is clear

Free Windows Admin Tool Kit Click here and download it now
July 16th, 2015 2:58am

Hi,

Is Problem  resolved ?

If not Instead of running services with newly created  user(mentioned in below link) 

https://www.mssqltips.com/sqlservertip/2562/sql-server-log-shipping-to-a-different-domain-or-workgroup/

you can add below step in Copy job as a first step,It will work no need to change in Agent services account 

Net use \\<SourceServerIP>\<sharefolder> /USER:DomainName\username passwor

Please verify and let us know if it work....

above scenario is working for me.

Thanks,


July 21st, 2015 1:46am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics