in

Dotnetpanel Forums

Community support forums for DotNetPanel products

SQL Server Maintenance Plans Fail After Server Rename

Last post 03-17-2009 7:41 AM by Ingvald. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 03-13-2009 8:34 PM

    SQL Server Maintenance Plans Fail After Server Rename

    My server provider renamed my server and did not let me know. I found out when I tried to login to the SQL Server. I also realized that my Maintenance Plans are not working because they still reference the old server name.

    I did quite a bit of research but cannot figure out how to get the Maintenance Plan to work. I tried creating a new MP and it still references the old server name. I created a new connection as well for the MP but it doesn't work.

    I just thought I would see if anyone there has any ideas. The more I look the more confused I get. And I have more fear that this could be impacting some things that I just have not found yet. I have told the server provider to figure this out, but I am doing my own research as well.

    Thanks for any ideas you have.

     Cliff

    Filed under:
  • 03-17-2009 7:41 AM In reply to

    Re: SQL Server Maintenance Plans Fail After Server Rename

    Try the following:

    EXEC sp_dropserver 'OLDNAME'
    GO

    EXEC sp_addserver 'NEWNAME', 'local'
    GO

Page 1 of 1 (2 items)
Powered by Community Server (Commercial Edition), by Telligent Systems