Rename SQLServer instance after rename computer












0















I have SQL Server 2012 running on Windows Server 2012. I renamed the Windows Server and need to adjust the SQL Server for the new name to get my Maintenance Plans running.



When I run Select @@ServerName I get the old server name.



If I try to run the sp_drop/addserver



exec sp_dropserver "oldservernameinstancename"
Go
exec sp_addserver "newservernameinstancename", local
Go


I get the following error:



Msg 15015, Level 16, State 1, Procedure sp_dropserver, Line 45
The server 'oldservernameinstancename' does not exist. Use sp_helpserver to show available servers.
Msg 15028, Level 16, State 1, Procedure sp_addserver, Line 79
The server 'newservernameinstancename' already exists.



sp_helpserver shows the new server name though



How can I correct this so my SQL Server Agent can run maintenance plans again?










share|improve this question























  • Have you restarted SQL after you ran the sp_dropserver and sp_addserver commands?

    – Doug Deden
    Feb 4 at 15:48











  • That was part of the answer. I thought I had restarted after but I guess my last restart was before.

    – Dan Wier
    Feb 5 at 5:25
















0















I have SQL Server 2012 running on Windows Server 2012. I renamed the Windows Server and need to adjust the SQL Server for the new name to get my Maintenance Plans running.



When I run Select @@ServerName I get the old server name.



If I try to run the sp_drop/addserver



exec sp_dropserver "oldservernameinstancename"
Go
exec sp_addserver "newservernameinstancename", local
Go


I get the following error:



Msg 15015, Level 16, State 1, Procedure sp_dropserver, Line 45
The server 'oldservernameinstancename' does not exist. Use sp_helpserver to show available servers.
Msg 15028, Level 16, State 1, Procedure sp_addserver, Line 79
The server 'newservernameinstancename' already exists.



sp_helpserver shows the new server name though



How can I correct this so my SQL Server Agent can run maintenance plans again?










share|improve this question























  • Have you restarted SQL after you ran the sp_dropserver and sp_addserver commands?

    – Doug Deden
    Feb 4 at 15:48











  • That was part of the answer. I thought I had restarted after but I guess my last restart was before.

    – Dan Wier
    Feb 5 at 5:25














0












0








0








I have SQL Server 2012 running on Windows Server 2012. I renamed the Windows Server and need to adjust the SQL Server for the new name to get my Maintenance Plans running.



When I run Select @@ServerName I get the old server name.



If I try to run the sp_drop/addserver



exec sp_dropserver "oldservernameinstancename"
Go
exec sp_addserver "newservernameinstancename", local
Go


I get the following error:



Msg 15015, Level 16, State 1, Procedure sp_dropserver, Line 45
The server 'oldservernameinstancename' does not exist. Use sp_helpserver to show available servers.
Msg 15028, Level 16, State 1, Procedure sp_addserver, Line 79
The server 'newservernameinstancename' already exists.



sp_helpserver shows the new server name though



How can I correct this so my SQL Server Agent can run maintenance plans again?










share|improve this question














I have SQL Server 2012 running on Windows Server 2012. I renamed the Windows Server and need to adjust the SQL Server for the new name to get my Maintenance Plans running.



When I run Select @@ServerName I get the old server name.



If I try to run the sp_drop/addserver



exec sp_dropserver "oldservernameinstancename"
Go
exec sp_addserver "newservernameinstancename", local
Go


I get the following error:



Msg 15015, Level 16, State 1, Procedure sp_dropserver, Line 45
The server 'oldservernameinstancename' does not exist. Use sp_helpserver to show available servers.
Msg 15028, Level 16, State 1, Procedure sp_addserver, Line 79
The server 'newservernameinstancename' already exists.



sp_helpserver shows the new server name though



How can I correct this so my SQL Server Agent can run maintenance plans again?







sql-server sql-management-studio






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked Feb 4 at 5:26









Dan WierDan Wier

111




111













  • Have you restarted SQL after you ran the sp_dropserver and sp_addserver commands?

    – Doug Deden
    Feb 4 at 15:48











  • That was part of the answer. I thought I had restarted after but I guess my last restart was before.

    – Dan Wier
    Feb 5 at 5:25



















  • Have you restarted SQL after you ran the sp_dropserver and sp_addserver commands?

    – Doug Deden
    Feb 4 at 15:48











  • That was part of the answer. I thought I had restarted after but I guess my last restart was before.

    – Dan Wier
    Feb 5 at 5:25

















Have you restarted SQL after you ran the sp_dropserver and sp_addserver commands?

– Doug Deden
Feb 4 at 15:48





Have you restarted SQL after you ran the sp_dropserver and sp_addserver commands?

– Doug Deden
Feb 4 at 15:48













That was part of the answer. I thought I had restarted after but I guess my last restart was before.

– Dan Wier
Feb 5 at 5:25





That was part of the answer. I thought I had restarted after but I guess my last restart was before.

– Dan Wier
Feb 5 at 5:25










1 Answer
1






active

oldest

votes


















0














Restarting the server after running the drop/add server commands got the @@ServerName correct. I had to change the owner of the jobs to a different user because they were mapped to oldservernameusername.






share|improve this answer























    Your Answer








    StackExchange.ready(function() {
    var channelOptions = {
    tags: "".split(" "),
    id: "3"
    };
    initTagRenderer("".split(" "), "".split(" "), channelOptions);

    StackExchange.using("externalEditor", function() {
    // Have to fire editor after snippets, if snippets enabled
    if (StackExchange.settings.snippets.snippetsEnabled) {
    StackExchange.using("snippets", function() {
    createEditor();
    });
    }
    else {
    createEditor();
    }
    });

    function createEditor() {
    StackExchange.prepareEditor({
    heartbeatType: 'answer',
    autoActivateHeartbeat: false,
    convertImagesToLinks: true,
    noModals: true,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: 10,
    bindNavPrevention: true,
    postfix: "",
    imageUploader: {
    brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
    contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
    allowUrls: true
    },
    onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    });


    }
    });














    draft saved

    draft discarded


















    StackExchange.ready(
    function () {
    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1401728%2frename-sqlserver-instance-after-rename-computer%23new-answer', 'question_page');
    }
    );

    Post as a guest















    Required, but never shown

























    1 Answer
    1






    active

    oldest

    votes








    1 Answer
    1






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes









    0














    Restarting the server after running the drop/add server commands got the @@ServerName correct. I had to change the owner of the jobs to a different user because they were mapped to oldservernameusername.






    share|improve this answer




























      0














      Restarting the server after running the drop/add server commands got the @@ServerName correct. I had to change the owner of the jobs to a different user because they were mapped to oldservernameusername.






      share|improve this answer


























        0












        0








        0







        Restarting the server after running the drop/add server commands got the @@ServerName correct. I had to change the owner of the jobs to a different user because they were mapped to oldservernameusername.






        share|improve this answer













        Restarting the server after running the drop/add server commands got the @@ServerName correct. I had to change the owner of the jobs to a different user because they were mapped to oldservernameusername.







        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Feb 5 at 5:25









        Dan WierDan Wier

        111




        111






























            draft saved

            draft discarded




















































            Thanks for contributing an answer to Super User!


            • Please be sure to answer the question. Provide details and share your research!

            But avoid



            • Asking for help, clarification, or responding to other answers.

            • Making statements based on opinion; back them up with references or personal experience.


            To learn more, see our tips on writing great answers.




            draft saved


            draft discarded














            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1401728%2frename-sqlserver-instance-after-rename-computer%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown





















































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown

































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown







            Popular posts from this blog

            How to make a Squid Proxy server?

            Is this a new Fibonacci Identity?

            19世紀