Package could not be loaded after server name changed

• Denise McMillan

  SSCertifiable

  Points: 6216

  More actions

  March 14, 2007 at 2:56 pm

  #172817

  I have jobs in maintenance plans that don't work after we changed the server name. Is there some things I have to do at the database level when the server's name is changed?

  The jobs fail now with error: The package could not be loaded. The step failed."

  I did run sp_dropserver <old name>, sp_addserver <new name>, local

  commands, is there something else I have to change? Do I have to recreate the jobs?

  Thanks for any help.

   

• Amit Jethva

  SSCarpal Tunnel

  Points: 4707

  More actions

  March 15, 2007 at 4:18 am

  #695173

  see http://support.microsoft.com/?id=281642 if it is applies to you.

  if so, you could take a msdb backup ( for safety ), and then

  UPDATE sysjobs SET originating_server =  @@servername

  WHERE  originating_server = 'your_servername_before_rename'

   

  
  

  -- Amit

  ---

  
  "There is no 'patch' for stupidity."

  ---

  
  Download the Updated SQL Server 2005 Books Online.