Post reply

Credential problems with Snapshot agent

  • March 4, 2010 at 7:39 pm

    #221244

    Hello,

    I am trying to set up transactional replication.

    Distributor is a remote server running on sql server 2008 SP1 64 BIT.

    The Snapshot agent is running under the sql service agent service account and whenever snapshot agent is started i get the following error message

    ''Source: mscorlib

    Target Site: Void WinIOError(Int32, System.String)

    Message: Access to the path 'D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\ReplData\unc\publisher name\20100304210002\' is denied.

    Stack: at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)

    at System.IO.Directory.InternalCreateDirectory(String fullPath, String path, DirectorySecurity dirSecurity)

    at System.IO.Directory.CreateDirectory(String path, DirectorySecurity directorySecurity)

    at Microsoft.SqlServer.Replication.Utilities.CreateDirectoryWithExtendedErrorInformation(String directory)

    at Microsoft.SqlServer.Replication.Snapshot.SnapshotProvider.CreateSnapshotFolders()

    at Microsoft.SqlServer.Replication.Snapshot.SqlServerSnapshotProvider.GenerateSnapshot()

    at Microsoft.SqlServer.Replication.SnapshotGenerationAgent.InternalRun()

    at Microsoft.SqlServer.Replication.AgentCore.Run() (Source: mscorlib, Error number: 0)

    Get help: http://help/0 ''

    The service account has sysadmin permissions and has local administrator permissions on the box.

    I have checked and the drive has been shared to everyone and even the folder Repldata has full control permissins granted for Everyone.

    I have searched online and found someone having same problem and the fix suggested was

    ''Snapshot agent is executed with sql server account. Not account that is used for merge agent. And there is some problem with installation and sql server account was not in special user group (that has required permissons) created by setup. After I explicitely added sql server account to mentioned group the error was disappeared.''

    In my case i have added the service account has sysadmin for SQL Serverand local admin on the box.

    Still it's not working.

    any help would be highly appreciated.

  • March 4, 2010 at 7:44 pm

    #1128926

    And one more thing although the error message states access denied to D...\Repldata\unc\..

    i cannot see the subfolder UNC under Repldata.

    Repldata folder is empty and i cannot see any subfolders.

    I knew in 2000 we can see subfolders for snapshotagent default folder like unc and in that we can find publication name and in that we file BCP file, schema file.

    Is this changed in 2008 or i have them missing?

Viewing 2 posts - 1 through 1 (of 1 total)

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