Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

SQL Service account change Expand / Collapse
Author
Message
Posted Wednesday, April 24, 2013 5:35 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, July 28, 2014 12:44 AM
Points: 91, Visits: 322
Hi,

Log shipping (backup job) failed after we change SQL service account in our production database and DR database server.

Earlier its was working fine with existing account name (Account name having domain admin rights) but current a/c name doesn't have domain admin rights its normal domain account.

Is it having any chances to failed log shipping process?

Pls advice on this...

thanks.



Pradeep
Post #1445870
Posted Wednesday, April 24, 2013 5:49 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Monday, October 13, 2014 4:54 AM
Points: 708, Visits: 3,290
pradeep.mohan (4/24/2013)
Hi,

Log shipping (backup job) failed after we change SQL service account in our production database and DR database server.

Earlier its was working fine with existing account name (Account name having domain admin rights) but current a/c name doesn't have domain admin rights its normal domain account.

Is it having any chances to failed log shipping process?

Pls advice on this...

thanks.



Looks like your new domain account doesn't have write privileges to the location of the TLOG backups. Speak to your AD admin should be able to sort it out for you.


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


It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens

Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
Post #1445877
Posted Monday, April 29, 2013 7:24 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 12:41 PM
Points: 396, Visits: 2,002
Does the new Service account is added in the Local administrator group on both the servers (Primary and seconday)?
Post #1447505
Posted Monday, April 29, 2013 7:34 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Saturday, October 18, 2014 5:21 PM
Points: 5,877, Visits: 13,005
what error do you get?

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

Post #1447514
Posted Tuesday, April 30, 2013 12:43 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, July 28, 2014 12:44 AM
Points: 91, Visits: 322
yes new account has been added to local administrator group.

Pradeep
Post #1447909
Posted Wednesday, May 1, 2013 7:40 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 2:07 PM
Points: 1,289, Visits: 2,843
Did you change the password of the SQL Server service to?




Post #1448418
Posted Wednesday, May 1, 2013 11:08 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, July 28, 2014 12:44 AM
Points: 91, Visits: 322
Yes, i changed the password also.

Pradeep
Post #1448687
Posted Thursday, May 2, 2013 8:54 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 2:07 PM
Points: 1,289, Visits: 2,843
pradeep.mohan (5/1/2013)
Yes, i changed the password also.


did you bounce SQL Server after you changed the password?

Make sure you changed the password in all places as far as MSSQL Server and SQL Agent as well as if you used it for the Log SHipping stuff.



Post #1448841
Posted Thursday, May 2, 2013 10:49 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, July 28, 2014 12:44 AM
Points: 91, Visits: 322
Yes i restart the SQL server and i changed both SQL Server Service and agent as well


Pradeep
Post #1449044
Posted Monday, May 6, 2013 7:45 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, July 28, 2014 12:44 AM
Points: 91, Visits: 322
Please find the error log

The job failed. The Job was invoked by Schedule 2864 (DefaultCopyJobSchedule). The last step to run was step 1 (Log shipping copy job step.)
Executed as user: XXXX\sqljobs. The step failed.


Pradeep
Post #1449722
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse