May 22, 2012 at 4:49 pm
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
May 23, 2012 at 1:31 am
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.
May 23, 2012 at 9:26 am
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
May 23, 2012 at 9:40 am
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.
May 23, 2012 at 9:49 am
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy