0

So I have to configure SSRS on my box and i tried to search feature name "Report Server Integration Feature" and could not found and my search lead to below two post.

Installing Reporting Services In SharePoint Mode

This blog details every details but for the first step it mentions of installing "Reporting Services In SharePoint Mode"

What I am looking is "How can I convert this step in to PowerShell?"

Is there a way to automate this in powershell?

0

The good news is that there is a way to install SSRS in SharePoint (or native) mode. The bad news is that it's a little complicated.

The trick is that it's done through the command line, not natively PowerShell. Here is a link regarding command line installation of SSRS 2012 in SharePoint mode. I also gather that you want to set it up in PowerShell so that you can run it unattended, so here is an example of an installation script (for SQL Server 2008r2, not SSRS) that uses PowerShell.

Hope this helps!

  • So I posted my answer but your help was g8. When I ran my command windows popup comes with the progress. is there a way where I can suppress that and show the progress in the console? – Ravi Khambhati Jul 23 '15 at 21:58
  • I'm not sure how you can suppress the progress window. If you find a solution, please let us know! – Jeff Freeman Jul 24 '15 at 14:16
0

Here is what I did

So here is what I did

  1. Created ini file by following steps mentioned here

  2. Run below command

    $configFile = "c:\Ravi\SSRS.ini"

    $setupFile = "e:\setup.exe" $installCmd = "$setupFile /qs /IACCEPTSQLSERVERLICENSETERMS /ConfigurationFile=""$configFile"" /ACTION=Install"

    Invoke-Expression $installCmd

My ini file

[OPTIONS]

ACTION="Install"

ENU="True"

QUIET="False"

QUIETSIMPLE="False"

UpdateEnabled="True"

FEATURES=RS_SHP,RS_SHPWFE

UpdateSource="MU"

HELP="False"

INDICATEPROGRESS="False"

X86="False"

INSTALLSHAREDDIR="C:\Program Files\Microsoft SQL Server"

INSTALLSHAREDWOWDIR="C:\Program Files (x86)\Microsoft SQL Server"

SQMREPORTING="False"

RSSHPINSTALLMODE="SharePointFilesOnlyMode"

ERRORREPORTING="True"

INSTANCEDIR="C:\Program Files\Microsoft SQL Server"

IACCEPTSQLSERVERLICENSETERMS="True"

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.