Localsyatem account for logshipping

Question

Localsyatem account for logshipping

sej2008

SSCarpal Tunnel

Points: 4495
More actions
September 27, 2014 at 6:04 am

#397415

I am doing log shipping on same machine between two instances using Localsystem account for sql agent service on windows server2008 R2 and I am able to connect to secondary server.It does not give any error.But if I try to do it through administrator as sql server agent service it works fine.can anyone explain???

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Perry Whittle SSC Guru Points: 233792 More actions · Answer 1

sej2008 (9/27/2014)
I am doing log shipping on same machine between two instances using Localsystem account for sql agent service on windows server2008 R2

OK got this so far

sej2008 (9/27/2014)
and I am able to connect to secondary server.

You need to throw a dog a bone here for us to help you, so,

Do you mean unable to connect?
Are you using the GUI to setup logshipping?
how far have you got through the setup process, have you setup the primary part successfully?
Have you checked the sql srever logs on both instances?
have you setup the file share and NTFS ACLs correctly?

sej2008 (9/27/2014)
It does not give any error.But if I try to do it through administrator as sql server agent service it works fine.can anyone explain???

Check the logs thoroughly, if the agent jobs have been created check the output history for each step carefully.

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

sej2008 SSCarpal Tunnel Points: 4495 More actions · Answer 2

yes I have given administrator the permission to access my shared folder on primary server.it does not give any specific sql error.But says can not connect to secondary server.My primary backup job and copy job works fine but restoration does not work.

When I tried to work on administrator account for sql server agent,it worked perfectly fine.why I am not able to do logshipping using localsystem account on same machine across instances?As this was possible to do it on windows server 2003 in sql 2008.

is there any change how localsystem behaves?

Perry Whittle SSC Guru Points: 233792 More actions · Answer 3

sej2008 (10/1/2014)
yes I have given administrator the permission to access my shared folder on primary server.

The administrator has nothing to do with it, when a service runs as local system it acts as the computer account on the network 😉

sej2008 (10/1/2014)
it does not give any specific sql error.But says can not connect to secondary server.My primary backup job and copy job works fine but restoration does not work.

The only job on the primary is the backup job, the copy and restore run on the secondary!!

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉