Post reply

Rename the hostname in sql server

  • March 7, 2019 at 6:35 am

    #370950

    Hi Team,

    A windows sever which is installed SQL server database engine/report server/SSIS/analysis service on it.

    the windows server name is like ' Server A'.

    if we changed windows server name to Server B then ...
    After executing the below commands will it change Report server , SSIS and SSRS server name as well ? as it is working for database engine but not others .please give inputs on this ?
     

    EXEC sp_DROPSERVER 'oldservername'

    1. Execute below to add a new server name. Make sure local is specified.

    EXEC sp_ADDSERVER 'newservername', 'local

  • March 7, 2019 at 11:22 am

    #2023871

    dastagiri16 - Thursday, March 7, 2019 6:35 AM

    Hi Team,

    A windows sever which is installed SQL server database engine/report server/SSIS/analysis service on it.

    the windows server name is like ' Server A'.

    if we changed windows server name to Server B then ...
    After executing the below commands will it change Report server , SSIS and SSRS server name as well ? as it is working for database engine but not others .please give inputs on this ?
     

    EXEC sp_DROPSERVER 'oldservername'

    1. Execute below to add a new server name. Make sure local is specified.

    EXEC sp_ADDSERVER 'newservername', 'local

    For SSAS, you use the instance rename tool called asinstancerename.exe.
    For SSRS, open the Report Server Configuration Manager and change the server in the first window asking for server name. Change it, connect and hit apply.
    You also want to check the the URLRoot and ReportServerURL in the RSReportServer.config to reflect the new server name if these have the old server name.
    You can find more information for both in the following documentation:
    Rename an Analysis Services Instance
    Rename a Report Server Computer

    Sue

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

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