PRB: Error 14274 Occurs When You Update a SQL Agent Job After Renaming Windows Server

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

SYMPTOMS

After the Windows server name been changed, when trying to update or delete the jobs previously created in a SQL Server 2000 instance, you may receive the following error message:
Error 14274: Cannot add, update, or delete a job (or its steps or schedules) that originated from an MSX server. The job was not saved.
This problem does not occur for Microsoft SQL Server 7.0; however, you might receive this error message when you upgrade a SQL Server 7.0 virtual server to a SQL Server 2000 virtual server even though you keep the same virtual server name. During the upgrade process, you have to uncluster the SQL Server 7.0 virtual server. When you uncluster the virtual server, it becomes a stand-alone instance of SQL Server and it takes the node name, and you may receive the error message when you change the name.

CAUSE

SQL Server 7.0 does not exhibit this problem because in the msdb..sysjobs table, the field originating_server stores the value '(local)' referencing the local server. Therefore, no matter how the server name is modified, the change does not affect the local server jobs.

Because SQL Server 2000 supports multi-instances, the originating_server field contains the instance name in the format 'server\instance'. Even for the default instance of the server, the actual server name is used instead of '(local)'. Therefore, after the Windows server is renamed, these jobs still reference the original server name and may not be updated or deleted by the process from the new server name.

After an upgrade from SQL Server 7.0 to SQL Server 2000, the originating_server column is also updated for all existing jobs and the value '(local)' is no longer used.

WORKAROUND

The best way to handle this problem after the rename process is to follow these steps:
  1. Rename the server back to the original name.
  2. Script out all of the jobs and then delete them.
  3. Rename the server to the new name.
  4. Add back the jobs by running the script generated from step 2.
For additional information, see the "Multiserver Administration" article in SQL Server Books Online.

STATUS

Microsoft has confirmed this to be a problem in SQL Server 2000.

Properties

Article ID: 281642 - Last Review: December 21, 2005 - Revision: 4.4
APPLIES TO
  • Microsoft SQL Server 2000 Standard Edition
Keywords: 
kbbug kbpending KB281642

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