Post reply

SQL Server 2019 Instance Name Change

  • March 15, 2022 at 5:04 pm

    #4000048

    I am running SQL 2019 on Windows 2019 server and have come across an issue I have not seen before and cannot find a resolution on the web. I have went through the normal process of changing the Instance name by using the following..

    EXEC sp_dropserver '<old_name\instancename>';

    GO

    EXEC sp_addserver '<new_name\instancename>', local;

    GO

    I rebooted the server afterward but I have to use the original instance name to actually connect but if I run

    Select @@servername it returns the new instance name.. It acts like Windows Server 2019 is blocking the final piece the name change. Anybody seen this and have a fix?

    Thanks

    Rich

  • March 16, 2022 at 1:02 pm

    #4000539

    I found my answer on this. Thanks

  • March 16, 2022 at 4:18 pm

    #4000671

    rmsdip69 wrote:

    I found my answer on this. Thanks

    Would you mind sharing what you found to be the answer, please?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • March 17, 2022 at 7:19 am

    #4001107

    Posting your solution would be very much appreciated.

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply