I am trying to automate the setup of SQL server 2014 Standard edition with SSRS. To avoid SSRS being setup using the default port 80 for the webservice and report manager url's, I've chosen to install SQL server with the setting RSINSTALLMODE="FilesOnlyMode" and then use powershell to do the final setup steps.

To setup the ReportServer database, I use the "GenerateDatabaseCreationScript" method available in the "MSReportServer_ConfigurationSetting" class. This succeeds without problems however when I use my browser to connect to the web service or report manager url's, I get a "rsInvalidReportServerDatabase" and a "rsReportServerDatabaseUnavailable " error, respectively.

Running the stored procedure named GetDbVersion in the ReportServer database returns "C.0.9.45". If I delete the ReportServer database and then recreate it database manually with the Report Services Configuration manager, the same stored procedure returns "162".

So it seems to me there's a problem with the GenerateDatabaseCreationScript but I can't find any information on this. How can I automate the setup of SSRS and ensure it does not use port 80?

There are many manual solutions involving multi-step GUI solutions but the key for me is to automate this with powershell which doesn't appear to be possible.

example you can refer

https://go4answers.webhost4life.com/Example/configure-reporting-services-39562.aspx

Hi Hollister,

Thank you for your question. 

I am trying to involve someone more familiar with this topic for a further look at this issue. Sometime delay might be expected from the job transferring. Your patience is greatly appreciated. 

Thank you for your understanding and support.

Best regards,
Qiuyun Yu

If you have any feedback on our support, please click here.

Hi Hollister,

As we can learn from the following documentation, to automate the configuration of the port (as a part of URL configuration), you have to write custom code that makes calls into the Report Server Windows Management Instrumentation (WMI) provider.

Script Deployment and Administrative Tasks
https://msdn.microsoft.com/en-us/library/ms159720(v=sql.120).aspx

For the custom code, as Raoul mentioned, you may refer to the code sample from the community:

https://social.technet.microsoft.com/Forums/sqlserver/en-us/33ad2907-744e-4da8-bb84-07028dfbaa2f/how-to-configure-reporting-services-programmatically