Installing Reporting Services via Cmd line after SP
-
I would like help installing SQL Server Reporting Services on the d: drive of my server, using command prompt. I have to install it using the command prompt becuase I've already installed the service pack and the version compatiblity is a problem during regular setup. can some one help me with this script pointing it to the d: drive?
Start /wait R:\Servers\setup.exe /qb INSTANCENAME=MSSQLSERVER ADDLOCAL=RS_Server,RS_tools,RS_Web_Interface,RS_Tools,SQL_Documentation,SQL_BooksOnline,SQL_SQLServerBooksOnline,SQL_Samples,SQL_AdventureWorksSamples,SQL_AdventureWorksDWSamples,SQL_ReportingServicesSamples RSACCOUNT=***** RSPASSWORD=******
dkb2715 -
Running SETUP via a command line or via the GUI does exactly the same thing. The only reason to run via a command line is you prefer to do it that way.
Your command string looks about right. You can try adding a INSTALLSQLDIR keyword to direct the RS components to your D drive, but I suspect it will ignore this and put RS into the same folders as your other components. If you have already installed BOL you do not need the keywords relating to documentation. Likewise if you have already installed the Samples you do not need those keywords, apart from the RS samples.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
-
IGNORE Start/wait... Then it will work...Microsoft puzzles
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply