Skip to main content

Silent Install of MicroStrategy 9.3.0

Create a batch file "install.bat" (name does not matter) with the following command line:

"Path_to_setup_file\setup.exe" -L0009 --ResponseFile="Path_to_setup_file\response.ini" -f1"Path_to_setup_file\setup.iss" -f2"c:\setup.log"

Path_to_setup_file above should be replaced with actual path to the setup.exe for the version you are trying to uninstall. The setup files can be located on remote server. Make sure to provide a proper fully qualified UNC path. Use the below response file. Response file should be named response.ini and should be saved in the same location as setup.exe. Below script only installs Desktop and Narrowcast. If you would like to install additional components, make necessary changes. Also notice that the below script will force a reboot of your system. Most errors encountered during installation will be logged in c:\setup.log. Again, feel free to change the location of the setup.log file.

[Installer] 
HideAllDialogs=TRUE 
PreventReboot=FALSE 
ForceReboot=TRUE 
ShowConfigWizard=FALSE 
ShowWelcomeScreen=FALSE 
StopAllServices=TRUE 
CheckRenameOperations=FALSE 
TutReportingOverwrite=FALSE 
  
### User Registration ###
[UserRegistration] 
CompanyName=Shah Company or Your Company Name
LicenseKey=YOUR_LICENSE_KEY_GOES_HERE 
  
### Visible Components ### 
[ComponentSelection]
HideDialog=TRUE
AnalyticsModulesVisible=FALSE
ArchitectVisible=TRUE
CommandManagerVisible=FALSE
DeliveryEngineVisible=FALSE
DesktopDesignerVisible=TRUE
DesktopAnalystVisible=TRUE
EnterpriseManagerVisible=FALSE
FunctionPluginVisible=FALSE
GISConnectorsVisible=FALSE
IntegrityManagerVisible=FALSE
IServerDistributionServicesVisible=FALSE
IServerOLAPServicesVisible=FALSE
IServerReportServicseVisible=FALSE
IServerTransactionServicesVisible=FALSE
IServerVisible=FALSE
MobileClientVisible=FALSE
MobileServerASPVisible=FALSE
MobileServerJSPVisible=FALSE
MobileVisible=FALSE
NCSAdminVisible=TRUE
ObjectManagerVisible=FALSE
OfficeVisible=FALSE
PortletsVisible=FALSE
ProjectBuilderVisible=TRUE
SDKVisible=FALSE
SequeLinkVisible=FALSE
ServerAdminVisible=TRUE
SubscriptionPortalVisible=FALSE
TMIConnectorVisible=FALSE
TutorialDeliveryConfigureVisible=FALSE
TutorialDeliveryInstallVisible=FALSE
TutorialReportingVisible=FALSE
WebAnalystVisible=FALSE
WebMMTVisible=FALSE
WebProfessionalVisible=FALSE
WebReporterVisible=FALSE
WebServerASPNETVisible=FALSE
WebServerJSPVisible=FALSE
WebServicesASPNETVisible=FALSE
WebServicesJSPVisible=FALSE
  
### Components To Install (TRUE) or Remove (FALSE) ### 
AnalyticsModulesSelect=FALSE
ArchitectSelect=TRUE
CommandManagerSelect=FALSE
DeliveryEngineSelect=FALSE
DesktopDesignerSelect=TRUE
DesktopAnalystSelect=TRUE
EnterpriseManagerSelect=FALSE
FunctionPluginSelect=FALSE
FunctionPluginSelect=FALSE
GISConnectorsSelect=FALSE
IntegrityManagerSelect=FALSE
IServerDistributionServicesSelect=FALSE
IServerOLAPServicesSelect=FALSE
IServerReportServicseSelect=FALSE
IServerTransactionServicesSelect=FALSE
IServerSelect=FALSE
MobileClientSelect=FALSE
MobileServerASPSelect=FALSE
MobileServerJSPSelect=FALSE
MobileSelect=FALSE
NCSAdminSelect=TRUE
ObjectManagerSelect=FALSE
OfficeSelect=FALSE
PortletsSelect=FALSE
ProjectBuilderSelect=TRUE
SDKSelect=FALSE
SequeLinkSelect=FALSE
ServerAdminSelect=TRUE
SubscriptionPortalSelect=FALSE
TMIConnectorSelect=FALSE
TutorialDeliveryConfigureSelect=FALSE
TutorialDeliveryInstallSelect=FALSE
TutorialReportingSelect=FALSE
WebAnalystSelect=FALSE
WebMMTSelect=FALSE
WebProfessionalSelect=FALSE
WebReporterSelect=FALSE
WebServerASPNETSelect=FALSE
WebServerJSPSelect=FALSE
WebServicesASPNETSelect=FALSE
WebServicesJSPSelect=FALSE

Try on a test server before you work on production!

Comments

The Popular Ones

Using SQL To Calculate XIRR (Internal Rate of Return)

Thanks to binaryworld.net , I was finally able to get a sql way to calculate XIRR. After 2 long hours of search I found this site and the logic as well as the code works perfectly well! XIRR is a function in excel that calculates Internal Rate of Return based on payments/income over a period of time. Without further ado, here is the code (a slightly modified version from BinaryWorld.net. Happy XIRRing! -- First, CREATE XIRR Table to store values CREATE TABLE XIRRTempData( amt float, dt datetime, guid varchar(128) ) go create function dbo.XIRR( @d datetime, @GUID varchar(128) ) returns decimal(18,10) as begin /* USAGE: select @IRR = dbo.xirr(null, guid) select @IRR IRR, @IRR * 100 'IRR %' Note: Leave the first parameter (date) null if you wish to see the XIRR calculated as of the maximum date in the dataset provided else provide a specific date to see the XIRR calculated as the given date. Created By: Ankeet Shah Created On: 7/16/2008 */ IF @d is null SELECT @d = max(d) from Inc

Alternating Row Background Color For SSRS Matrix (Pivot Table)

I had a tough time to apply alternate row colors to a SSRS Matrix and finally figured out! Without further ado, here it is... Assume you have a matrix with more than 1, lets say 2 row groupings; RG1 and RG2. 1. Right-click on RG2 (innermost row group), and select "Insert Group"; for simplicity call it "RowColorGroup" 2. In the "Group On" section, add some constant value - for example ="" or ="ankeet" etc... you get the idea! 3. Select the newly created group "RowColorGroup" and enter the following in its "Value" property: =iif(RunningValue(Fields!RG1.Value & Fields!RG2.Value,CountDistinct,Nothing) Mod 2, "LightSteelBlue", "White") 4. Select the "BackgroundColor" property of "RowColorGroup" and enter "=Value" 5. Set the width of "RowColorGroup" to 0pt and "CanGrow" to false 6. Select the data cell(s) and set their "BackgroundColor" pro

cannot create a column accessor for OLE DB provider "ibmdasql" for linked server

I have a linked server from Microsoft SQL 2008 to a DB2 server. Today when I tried to run a SELECT statement based on the linked server, I hit this error, "cannot create a column accessor for OLE DB provider "ibmdasql" for linked server". Earlier in the day, we had restarted the SQL Server Service. Running the following script on the 'affected' sql server should fix the issue. USE [master] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROC [dbo].[usp_enum_oledb_providers] AS exec sp_enum_oledb_providers GO sp_procoption 'usp_enum_oledb_providers', 'startup', 1 Restart the sql server service after running above script.