Renaming server breaks R

  • ac427

    SSC Enthusiast

    Points: 129

    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 ?

  • sql_lock

    SSCrazy Eights

    Points: 9373

    Hi,

    Did you find your answer on technet?

    Thanks

  • Kenny Jozi

    SSCrazy

    Points: 2004

    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

  • ac427

    SSC Enthusiast

    Points: 129

    I did change the computername to reflect the SQL server name

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

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