Post reply

Renaming server breaks R

  • May 4, 2017 at 5:06 am

    #342757

    I have an AWS instance running SQL 2016. If i rename the default instance with the SQL code below 'R' breaks although the rename is successful.
    I don't need 'R' but it stops SQL SP1 being installed.

    sp_dropserver 'oldname';
    GO
    sp_addserver 'newname', local;
    GO

    The AWS SQL instance does not have the SQL install media loaded but is there a way i can remove 'R services' from the server ?

  • May 16, 2017 at 3:41 am

    #1942663

    Hi,

    Did you find your answer on technet?

    Thanks

  • May 16, 2017 at 8:20 am

    #1942703

    ac427 - Thursday, May 4, 2017 5:06 AM

    I have an AWS instance running SQL 2016. If i rename the default instance with the SQL code below 'R' breaks although the rename is successful.
    I don't need 'R' but it stops SQL SP1 being installed.

    sp_dropserver 'oldname';
    GO
    sp_addserver 'newname', local;
    GO

    The AWS SQL instance does not have the SQL install media loaded but is there a way i can remove 'R services' from the server ?

    Did you also rename the machine ?

    SQL 2000/2005/2008/2012 DBA - MCTS/MCITP

  • May 16, 2017 at 4:24 pm

    #1942805

    I did change the computername to reflect the SQL server name

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

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