rename/change SQL server name

  • I need to rename a reporting server which is installed SQL server 2008 R2 , both database and reporting service is on the same server.

    Now after we rename the phyical computer name, then I need to change the sql server name by using,

    EXEC master.dbo.sp_dropserver ‘[SERVER NAME]‘

    EXEC master.dbo.sp_addserver ‘[NEW SERVER NAME]‘, ‘local’

    And restart the server,

    What is the next step for renaming the reporting server, thanks,

    I have read the http://msdn.microsoft.com/en-us/library/ms345235(v=sql.105).aspx

    But it is not clearly said:

    So in my case, should I do the first one: Renaming a SQL Server Database Engine

    or should I do the second one too: Renaming a Report Server Computer

    If it is the first one quoted as below

    Renaming a SQL Server Database Engine

    --------------------------------------------------------------------------------

    If you rename the SQL Server Database Engine instance that runs the report server database, do the following:

    1.Start the Reporting Services Configuration tool and connect to the report server that uses the report server database on the renamed server.

    --Question: when it says the renamed server above, does it mean after physical server name change, and also after I changed the sql server name by using sp_addserver

    2.Open the Database Setup page.

    3.In Server Name, type or select the SQL Server name, and then click Connect.

    4.Click Apply.

    If the report server is using a local Database Engine instance, you can use (local) or (local)\instancename to specify the server. If you use (local) to refer to the server, you can rename the server and the connections will continue to work. If you are using a remote server, or if Reporting Services is configured using the server name, you must update the database connection information whenever the server name is changed.

    --Question: I tried in report configuration tool to put the (local), it doesn't work

    Thanks

  • sqlfriends (5/22/2012)


    I need to rename a reporting server which is installed SQL server 2008 R2 , both database and reporting service is on the same server.

    Now after we rename the phyical computer name, then I need to change the sql server name by using,

    EXEC master.dbo.sp_dropserver ‘[SERVER NAME]‘

    EXEC master.dbo.sp_addserver ‘[NEW SERVER NAME]‘, ‘local’

    And restart the server,

    What is the next step for renaming the reporting server, thanks,

    I have read the http://msdn.microsoft.com/en-us/library/ms345235(v=sql.105).aspx

    But it is not clearly said:

    So in my case, should I do the first one: Renaming a SQL Server Database Engine

    or should I do the second one too: Renaming a Report Server Computer

    If it is the first one quoted as below

    Renaming a SQL Server Database Engine

    --------------------------------------------------------------------------------

    If you rename the SQL Server Database Engine instance that runs the report server database, do the following:

    1.Start the Reporting Services Configuration tool and connect to the report server that uses the report server database on the renamed server.

    --Question: when it says the renamed server above, does it mean after physical server name change, and also after I changed the sql server name by using sp_addserver

    2.Open the Database Setup page.

    3.In Server Name, type or select the SQL Server name, and then click Connect.

    4.Click Apply.

    If the report server is using a local Database Engine instance, you can use (local) or (local)\instancename to specify the server. If you use (local) to refer to the server, you can rename the server and the connections will continue to work. If you are using a remote server, or if Reporting Services is configured using the server name, you must update the database connection information whenever the server name is changed.

    --Question: I tried in report configuration tool to put the (local), it doesn't work

    Thanks

    You need to run the SSRS config and give it the new server name, so if it was SSRSServer and its now SQLSSRSServer then you give it SQLSSRSServer as the location of the RS database.

    Then you need to edit the RSReportServer.config file and give it the new servername like it says in that article you have provided.

  • You need to run the SSRS config and give it the new server name, so if it was SSRSServer and its now SQLSSRSServer then you give it SQLSSRSServer as the location of the RS database.

    Then you need to edit the RSReportServer.config file and give it the new servername like it says in that article you have provided.

    Thanks, I am looking one of our existing production reporting server 2008 R2, I opened the rsReportserver.config,

    I cannot find a place that says servername, I searched our severname in the file, nothing is found.

    Also the string <UrlRoot></UrlRoot>, is empty, <ReportServerUrl></ReportServerUrl> is empty,

    but in reporting configuration tool, these are all populated.

    So not sure what I should change in the file.

    Thanks

  • did you read the article in your first post on how to do the tasks you needed to do?

    if so you should of seen the part where if it says that if the URLs are blank in the config, then leave them blank.

  • Thanks, how about URLroot?

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

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