Article ID: 277029 - View products that this article applies to.
This article was previously published under Q277029
This article has been archived. It is offered "as is" and will no longer be updated.
When defining multiserver jobs, SQL Server 7.0 as master server (MSX) is unable to enlist a SQL Server 2000 named instance as a target server (TSX). Trying to do so generates the following error message:
Enlistment failed (reason: Error 22026: The enlist operation failed (reason: Unable to create login and/or user for target server. 'server name\instance name' is not a valid name because it contains invalid characters. [SQLSTATE 42000] (Error 15006)))
By design, SQL Server does not provide forward compatibility. In US Service Pack 3 for SQL Server 7.0, new functionality has been added to SQL Server 7.0 so that you can define multiserver jobs with SQL Server 7.0 as MSX and enlist a SQL Server 2000 named instance as a TSX.