THIS TOPIC APPLIES TO: yesSQL ServernoAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Message Details

Product Name SQL Server
Event ID 21797
Component SQL Server Database Engine
Symbolic Name
Message Text '%s' must be a valid Windows Login in the form: 'MACHINE\Login' or 'DOMAIN\Login'. Please see the documentation for '%s'.


This error is raised by the following replication stored procedures if the value specified for the @job_login parameter is null or not valid. This error can occur if a member of the db_owner fixed database role runs scripts from previous versions of SQL Server. The security model changed in SQL Server 2005, and these scripts must be updated.

User Action

Ensure you specify a valid Windows account for the @job_login parameter of each procedure. If you have replication scripts from previous versions of SQL Server, update these scripts to include the stored procedures and parameters required by SQL Server 2005. For more information, see Upgrade Replication Scripts (Replication Transact-SQL Programming).

See Also

Errors and Events Reference (Replication)