Microsoft KB Archive/277029

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

Article ID: 277029

Article Last Modified on 12/17/2004

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition
 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q277029





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.

Keywords: kbfix kbprb KB277029

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.