Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Two days back our client changed one of our Dev Server name

After Server Renamed, All my maintenance jobs and other jobs are failing because server name mismatch.

We are using sql server 2012 version and server 2008 OS

So today morning i renamed my Sql server 2012 name to updated given name and made table, procedures updates

I tried to update Local server connection in maintenance job but it is uneditable. Then i added new server connection,still no use i am getting below error, while executing jobs.

After i tried with target page in jobs property option, there also only target server is selected and multiple target server is disable.

Error below

Executed as user: NT Service\SQLSERVERAGENT. Microsoft (R) SQL Server Execute Package Utility Version 11.0.2100.60 for 64-bit Copyright (C) Microsoft Corporation. All rights reserved.
Started: 12:01:28 AM Error: 2013-12-16 00:01:43.98 Code: 0xC00291EC Source: {410F7661-F71A-4B68-9584-BA422AB00F02} 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
Error: 2013-12-16 00:02:00.00
Code: 0xC0024104
Source: Territory_Update
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: 2013-12-16 00:02:15.00
Code: 0xC0024104
Source: {4E2AF328-0B8D-4905-83BE-839FDDEFC09C}
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 DTExec: The package execution returned DTSER_FAILURE (1).
Started: 12:01:28 AM
Finished: 12:02:15 AM
Elapsed: 46.641 seconds.
The package execution failed.
The step failed.

Help me out in this guys, Thanks in advance

share|improve this question

1 Answer 1

Maintenance plans make use of SSIS packages that are stored in MSDB. These packages use connection strings, which are not changed after a server rename.

Use the script posted by Thomas Lee in the comments of this link to get some inspiration on how to change these connection strings. Or recreate the maintenance plans.

share|improve this answer
1  
Thanks a lot Edward it worked. –  sairam Dec 16 '13 at 11:18

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.