SQL Server 7.0 as master server cannot enlist SQL Server 2000 named instance as target server

This article was previously published under Q277029
This article has been archived. It is offered "as is" and will no longer be updated.

SYMPTOMS
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)))
MORE INFORMATION
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.
Properties

Article ID: 277029 - Last Review: 01/16/2015 20:56:11 - Revision: 2.2

  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server 2000 Standard Edition
  • kbnosurvey kbarchive kbfix kbprb KB277029
Feedback