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

Logshipping Configuration error:3201 Expand / Collapse
Author
Message
Posted Tuesday, June 4, 2013 10:25 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 5, 2013 8:47 AM
Points: 9, Visits: 44
Hi am configuring Logshipping on SQL Server 2008 R2 servers,

my primary and secondary both servers are same editions and

i gave full access on the backup, copy folders but still it is giving the error. 3201


Please help me outttt!!! urgent!!


  Post Attachments 
error.PNG (21 views, 128.04 KB)
Post #1459854
Posted Tuesday, June 4, 2013 10:30 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 7:05 PM
Points: 23,293, Visits: 32,026
What about permissions on the share (not just the actual directories).



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1459855
Posted Tuesday, June 4, 2013 11:59 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 5, 2013 8:47 AM
Points: 9, Visits: 44
Hi Lynn,

Thanks for your quick reply

i have given the Read&Write permissions on the share drive but still having the same error
Post #1459891
Posted Wednesday, June 5, 2013 3:03 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 12:53 AM
Points: 1,375, Visits: 2,667
Did you assign those permissions to the SQL service account?
Post #1460101
Posted Thursday, June 6, 2013 11:09 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, June 23, 2014 6:49 AM
Points: 62, Visits: 326
1) check Both Instance should run on same (service) account.
2) Check backup location have full access.
Post #1460820
Posted Friday, June 7, 2013 12:00 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:57 AM
Points: 6,304, Visits: 13,601
Check the share "testing_backup". On the properties go to the share permissions tab and set permission for sql service accounts for both instances (if not the same).
Then go to security tab and set NTFS ACLs, again for both accounts.


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

"Ya can't make an omelette without breaking just a few eggs"
Post #1460966
Posted Friday, June 7, 2013 12:45 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 12:53 AM
Points: 1,375, Visits: 2,667
Make sure that the SQL Agent service account also has permissions to the share..
Post #1460974
Posted Thursday, June 13, 2013 4:46 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
Its a permission issue check both server SQL Server Agent rights level and share folder access level as well as domain.

Pradeep
Post #1462977
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse