MSSQL_ENG021331
Message Details
Product Name |
SQL Server |
Product Version |
10.0 |
Product Build Number |
|
Event ID |
21331 |
Event Source |
MSSQLSERVER |
Component |
SQL Server Database Engine |
Symbolic Name |
|
Message Text |
Failed to copy user script file to the Distributor.(%ls) |
Explanation
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.
User Action
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.