MSSQL_ENG021331

MSSQL_ENG021331

 

Applies To: SQL Server 2016

Product NameSQL Server
Event ID21331
Event SourceMSSQLSERVER
ComponentSQL Server Database Engine
Symbolic Name
Message TextFailed to copy user script file to the Distributor.(%ls)

This error can occur when a subscription is initialized manually, and the scripts generated by replication, or specified in a replication command, cannot be saved to the specified directory. The error can be caused by a permissions issue: when a subscription is initialized without using a snapshot, the account under which the SQL Server service runs at the Publisher must have write permissions on the snapshot folder at the Distributor.

Ensure that the correct path has been specified for the snapshot folder and that the account under which the SQL Server service runs at the Publisher has sufficient permissions.

Specify the Default Snapshot Location (SQL Server Management Studio)
Errors and Events Reference (Replication)
Initialize a Transactional Subscription Without a Snapshot

Community Additions

ADD
Show:
© 2016 Microsoft