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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics