RE: What permissions on shared snapshot folder?

From: Farooq Mahmud [MS] (farooqm@online.microsoft.com)
Date: 06/12/02 

From: farooqm@online.microsoft.com (Farooq Mahmud [MS])
Date: Wed, 12 Jun 2002 21:24:17 GMT

By default the SQL Server Agent account on the subscriber will be accessing
the snapshot folder so it should have permissions on the folder and files
in REPLDATA. Since the publisher and subscriber are in different untrusted
domains you will need to use the pass-through authentication feature of
Windows. In the below steps, assume the following:

-The SQL Server Agent startup account on the subscriber is
Domain2\sqlagentsvc. The password is 1234.
-The snapshot folder is named REPLDATA.

1. Create a local account on the distributor called sqlagentsvc. Set its
password to 1234. You do not have to put this account in any additional
local groups.
2. If the REPLDATA folder is shared via an administrative share (c$ for
example) then explicity share the REPLDATA folder.
3. Give the local sqlagentsvc account created in step 1 full control over
the REPLDATA share and all folders, subfolders, and files in REPLDATA.

The key here is that the name and password of the local sqlagentsvc account
should match the domain account on the subscriber.

Hope this helps,
Farooq Mahmud [MS SQL Support]

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.

Relevant Pages

  • Re: Help with configuration
    ... to redirect their My Documents folder to a share on the fileserver. ... GPo, if it is already redirecting by default? ... account profile is blank, also). ... Your GPO settings do not apply to your Terminal Server. ...
    (microsoft.public.windows.terminal_services)
  • Re: Missing Folders in Documents & Settings for New Users
    ... I renamed the default administrator account <SNIP> I ... Settings folder name, and ProfileImagePath value. ... that you have decided to use, choose Rename, and rename the <user ...
    (microsoft.public.windowsxp.customize)
  • RE: SBS 2K3 R2 and Outlook
    ... The archive file created on the SBS is the folder redirection function. ... | account create a new user profile on client computer. ... | transfer the local user profile to domain user profile. ...
    (microsoft.public.windows.server.sbs)
  • Re: Missing Folders in Documents & Settings for New Users
    ... I renamed the default administrator account ... Documents and Settings folder update your backup. ... have decided to use, choose Rename, and rename the ...
    (microsoft.public.windowsxp.customize)
  • Re: Searching items in non-visible folder?
    ... I believe you will need to hard code a password in your code to use the Logon ... I don't think you can impersonate an account with greater ... read permissions to any Public Folder or Mailbox that you are accessing. ... > I only said that I set a reference to prove that I had "CDO" on my machine. ...
    (microsoft.public.outlook.program_forms)
Quantcast