Manage connections after renaming server
I have just renamed my SQL Server host computer and then followed the Microsoft support article for renaming a standalone instance of SQL Server. However, before the server rename, I had created several maintenance plans under the old server name.
Now, that I try to edit the existing connection in order to match it with the new server name, I am unable to do so. Even after adding a secondary connection, I am unable to delete the original connection. Therefore, since the original connection
mapped to the old server name is incorrect, the maintenance plan and job never executes successfully.
How do I modify the connections associated with the Maintenance Plan so that everything executes correctly as it once was before the server rename?
Thanks.
November 25th, 2010 4:38pm