Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

A colleague has renamed a SQL server, however all of the maintenance plans still have references to 'OLD_NAME' as 'Local Server Connection'.

The text boxes containing the server names for Local Server Connections are greyed-out and cannot be changed

Is there a way to change these values, short of exporting all of the SSIS packages, changing in Visual Studio and re-adding them again?

share|improve this question

migrated from stackoverflow.com Jul 13 '11 at 16:57

This question came from our site for professional and enthusiast programmers.

1 Answer 1

up vote 3 down vote accepted

How did the colleague rename the server? Did they follow this procedure:

http://msdn.microsoft.com/en-us/library/ms143799.aspx

If not, they need to, The procedure should be the same regardless of SQL version.

share|improve this answer
    
Do you expect doing this will correct the naming issue, even if it wasn't necessarily followed the first time? (I don't know whether the guide was followed or not) –  Richard Jul 14 '11 at 7:03
1  
Changed the version to SQL Server 2005 (just below title of page) and at the bottom of that page there is some prepared SQL for sorting out the local server connection server names. Excellent - thank-you –  Richard Jul 14 '11 at 8:53
    
Glad to help... –  joeqwerty Jul 14 '11 at 10:37

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.