Using RS.Exe to change Reporting Services Name
Hi, I'm using the rs.exe tool to run some vb scripts for configuring a reporting services install. I'm trying to change the reporting services name (within site settings) but I can't seem to find any way of doing this programatically. Does anyone know how to achieve this using the Microsoft.SqlServer.ReportingServices2005 Namespace? Many Thanks, Phil
May 18th, 2012 5:57am

Hello Phil, Do you mean to rename the instance name of SSRS? That's not possible to change it, you would have to install a new instance.Olaf Helper * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich tglich Blog Xing
Free Windows Admin Tool Kit Click here and download it now
May 18th, 2012 9:49am

Hi Olaf, No I don't mean the SQL instance name.. I mean the name you see when you go into site settings from the reporting services home page.. This name appears at the top of the report manager screen. Thanks for any info! Phil
May 18th, 2012 12:20pm

Hello Phil, Yes, we can use rs.exe utility to modify the "SQL Server Reporting Services " description on the Report Manager. Here are the sample code for your reference: Copy and paste the following code into a Notepad and named "Sample.rss". Public Shared Sub Main() Dim rs As New ReportingService2005() rs.Credentials = System.Net.CredentialCache.DefaultCredentials Dim setProp As New [Property]() setProp.Name = "SiteName" setProp.Value = "My report server that resides on the computer named RSSERVER1." Dim props(0) As [Property] props(0) = setProp Try rs.SetSystemProperties(props) Console.WriteLine("New site property set.") Catch ex As SoapException Console.WriteLine(ex.Detail.OuterXml) End Try End Sub 'Main 2. Open a command prompt: On the Start menu, click Run, type cmd in the text box, and then click OK. 3. Using the following code to run this script: rs i sample.rss s http://myserver/reportserver For more information, please refer to the articles below: ReportingService2005.SetSystemProperties Method: http://msdn.microsoft.com/en-us/library/reportservice2005.reportingservice2005.setsystemproperties.aspx Report Server System Properties: http://msdn.microsoft.com/en-us/library/ms155025.aspx Regards, Bin Long TechNet Subscriber Support If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here. Bin Long TechNet Community Support
Free Windows Admin Tool Kit Click here and download it now
May 22nd, 2012 10:02pm

Hello Phil, Yes, we can use rs.exe utility to modify the "SQL Server Reporting Services " description on the Report Manager. Here are the sample code for your reference: Copy and paste the following code into a Notepad and named "Sample.rss". Public Shared Sub Main() Dim rs As New ReportingService2005() rs.Credentials = System.Net.CredentialCache.DefaultCredentials Dim setProp As New [Property]() setProp.Name = "SiteName" setProp.Value = "My report server that resides on the computer named RSSERVER1." Dim props(0) As [Property] props(0) = setProp Try rs.SetSystemProperties(props) Console.WriteLine("New site property set.") Catch ex As SoapException Console.WriteLine(ex.Detail.OuterXml) End Try End Sub 'Main 2. Open a command prompt: On the Start menu, click Run, type cmd in the text box, and then click OK. 3. Using the following code to run this script: rs i sample.rss s http://myserver/reportserver For more information, please refer to the articles below: ReportingService2005.SetSystemProperties Method: http://msdn.microsoft.com/en-us/library/reportservice2005.reportingservice2005.setsystemproperties.aspx Report Server System Properties: http://msdn.microsoft.com/en-us/library/ms155025.aspx Regards, Bin Long TechNet Subscriber Support If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here. Bin Long TechNet Community Support
May 26th, 2012 10:07pm

Hi Bin, Thanks for your answer this works well and is exactly what I was after. Do you also know how to add users to security under site settings using the rs.exe tool / vb script? I'd be very grateful if you could send me an example script. Many Thanks, Phil
Free Windows Admin Tool Kit Click here and download it now
May 27th, 2012 4:37am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics