Share via


MSSQL_ENG021331

Message Details

Product Name

SQL Server

Product Version

9.0

Product Build Number

9.00.1399.60

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.

See Also

Concepts

Cause and Resolution of Replication Errors

Other Resources

How to: Specify the Default Snapshot Location (SQL Server Management Studio)
Initializing a Merge Subscription Without a Snapshot
Initializing a Transactional Subscription Without a Snapshot

Help and Information

Getting SQL Server 2005 Assistance