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