관리하는 sql server의 호스트명을 변경했습니다.

서버 호스트명 변경 후 db 내에서도 호스트명을 바꿔줬습니다.

db를 사용하는 서비스는 정상적으로 수행되고 있습니다

문제는 기존에 생성해놓은 유지관리계획이 정상적으로 실행이 되질 않습니다.

물론 쿼리로 백업을 수행하면 정상적으로 백업이 됩니다.

유지관리계획을 실행하면 대충 이런 에러 메시지가 나옵니다

job 'MaintenancePlan.Subplan_1' failed. (SqlManagerUI)

the job failed. the job was invoked by user ccm100t\administrator. the last step to run was step 1 (subplan_1)

에러 내용을 자세히보기 해보면 이런 내용의 에러가 나옵니다

Message

Executed as user: CASMAC2000\CCM100T$. 

Microsoft  SQL Server Execute Package Utility  Version 10.50.2500.0 for 64-bit  Copyright  Microsoft Corporation 2010. All rights reserved.    

Started:  2:40:33 PM  

Error: 2012-12-12 14:40:51.69     

    Code: 0xC00291EC

     Source: {DB612826-E002-405F-9E47-7553471FDDA8} Execute SQL Task

      Description: Failed to acquire connection "Local server connection". Connection may not be configured correctly or you may not have the right permissions on this connection.

  End Error  Warning: 2012-12-12 14:40:51.69

     Code: 0x80019002

     Source: OnPreExecute

      Description: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED.  The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed 

(1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.

  End Warning  Error: 2012-12-12 14:41:06.30 

    Code: 0xC0024104

     Source: Back Up Database Task

      Description: The Execute method on the task returned error code 0x80131904 (A network-related or instance-specific error occurred while establishing a connection 

to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. 

(provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)). The Execute method must succeed, and indicate the result using an "out" 

parameter.

  End Error  Error: 2012-12-12 14:41:23.46

     Code: 0xC0024104

     Source: {29794ECB-72FE-41FC-B140-3AA779C61CA7}

      Description: The Execute method on the task returned error code 0x80131904 (A network-related or instance-specific error occurred while establishing a connection 

to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. 

(provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)). The Execute method must succeed, and indicate the result using an "out" 

parameter.

  End Error  Warning: 2012-12-12 14:41:23.46

     Code: 0x80019002

     Source: OnPostExecute

      Description: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED.  The Execution method succeeded, but the number of errors raised (2) reached the maximum allowed 

(1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.

  End Warning  DTExec: The package execution returned DTSER_FAILURE (1).

  Started:  2:40:33 PM  Finished: 2:41:23 PM  Elapsed:  50.357 seconds.  The package execution failed.  The step failed.

더 문제는 새로 유지관리계획을 만들어서 실행해도 실행이 되질 않습니다...

이걸 어떻게 수정해야 다시 유지관리계획을 사용할 수 있을까요??