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

Article translations Article translations
Article ID: 277029 - View products that this article applies to.
This article was previously published under Q277029
Expand all | Collapse all

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: December 17, 2004 - Revision: 2.2
APPLIES TO
  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server 2000 Standard Edition
Keywords: 
kbfix kbprb KB277029

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com