Diagnostic logs will be sent to the Messaging Services Server after you perform the following: Enable MicroStrategy Messaging Services. 7, the MicroStrategy Messaging Services services can also be registered with the operating system during installation. The Intelligence server has entered MCM denial state, but recovers and then works as expected. This video steps through multiple ways of starting and stopping the Intelligence Server Service, including using the MicroStrategy Service Manager. Give the non-administrator user control to C:/Program Files (x86)/MicroStrategy and C:/Program Files (x86)/Common Files/MicroStrategy folders. xml" must either be edited, renamed, or deleted. Access the MicroStrategy Web Administrator page. If Custom Install is chosen, make sure "MicroStrategy Telemetry Server" is selected (it's auto selected when "MicroStrategy Intelligence" is selected). The JSESSIONID or ASP. Speed is important because it affects the user experience. For this point admins need to try the three options and see which one has better performance. Click on the Developer Machine Name to copy it. 4. Upgrading Flash-Based Content What is load balancing? Load balancing, as it applies to MicroStrategy Intelligence Server, is a strategy aimed at achieving even distribution of MicroStrategy Web or Web Universal user sessions across MicroStrategy Intelligence Servers, so that no single machine is overwhelmed. csv file to keep a record of their settings, or import a previously save file to apply the setting to a project. Right-click an Intelligent Cube and select Delete. If your password was changed from the default of mstr123 update the parameter in your WEB-INF/microstrategy. Enabling LDAP Authentication for MicroStrategy Web. It's being used even in the biggest financial, telecom and manufacturing organizations. Both enabling and disabling logs are covered. 24. jks at this time via the sslClientKeystore parameter in the microstrategy. Stop MicroStrategy Intelligence Server in all cluster nodes. Make sure that SSL is already configured and note down the REST port number used, as shown in the screenshot below. 4. DisconnectProjects. The MicroStrategy Listener will also check to see that MicroStrategy Intelligence Server is. A Processing Unit is a job-queuing and processing station with a collection of tasks, that a job will undergo after it is submitted to the MicroStrategy Intelligence Server. This can be achieved via the report level VLDB property > SQL Time. In the Service drop-down list, select the service. From the DSN drop-down list, select the DSN used to connect to the metadata repository. When State displays Running the service is ready. Our analytics and mobility platform transforms data into actionable insights that help people make better business decisions. Restart the MicroStrategy Intelligence Server to. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. process. System Performance Trends. instancename is the name of a server instance, where required. MicroStrategy Web, statistics can be used to troubleshoot issues with hanging or slow performance of certain MicroStrategy objects, such as reports or prompts. MicroStrategy Web must be connecting to the MicroStrategy Intelligence Server via the name configured in the certificate. Although it is possible to use the Microsoft Access database. 11. The Intelligence Server selection page opens. x to be restarted in order for the changes to take effect. Published: May 2, 2018; Last updated: Jul 17, 2023; Related versions: 10. WORKAROUND: Disable the Cube Health Check Feature on the effected environment by adding the following key: [HKEY_LOCAL_MACHINESOFTWAREMicroStrategyDSS ServerCastor]. type: Puppeteer exporter. 4. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. Perform the following steps to install MicroStrategy Library on a Windows server. /mstrctl -s IntelligenceServer stopSample URLs for exporting a Report Services document to PDF are shown below. Supported data structure and distribution on Gateway. x and newer, the following information is needed: LDAP version 3 compatible Directory Server that supports Clear text or LDAPS (LDAP over SSL) communications. Deploying a GCP instance. Click Project Defaults from the Menu in the left. x-10. The MicroStrategy Intelligence Server's backup frequency controls how long the server will wait to write cache and inbox files to disk. Number of Views 5. Review the file to ensure all entries match the ones seen in the following screenshot (namely iserver. To set up MicroStrategy Intelligence Server. Theoretically, capacity is a certain. If a name is not specified, the command uses the default instance name. /mstrcfgwiz. All necessary privileges are included in the Administrator role by default. Right-click a connected environment and choose Properties. The XML call's socket default read timeout: ConfigDefaults. 4. Efficiently manages thousands of end-user requests (jobs. mstr file can be opened in MicroStrategy Desktop and MicroStrategy Workstation. Learn how to use an external REST client to run MSTR related REST requests. reportName. x-10. Copy, paste, and execute the following XML script into the command line:Add the MicroStrategy Mobile Admin page URL with the full domain name to the list of Trusted Sites in Internet Explorer: Navigate to Tools > Internet Options > Security > Trusted Sites, like shown below: Click on the 'Sites' button. Start building with MicroStrategy to deliver exceptional product experiences. Important Notes: To ensure integrity of the intelligent cubes, make sure the metadata copies on the source and target environments are exactly same. This book shows you how to implement Business Intelligence (BI) with MicroStrategy. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. Click Options. In 2019 Update 2, it takes eight minutes to load the same three projects from the same metadata. Doing so avoids issues where a busy database can't scale up to a capacity with enough memory for the features that are turned on in your cluster and the database workload. xml should do. 9 release, MicroStrategy has introduced a new application called Library, which allows users to interact with their analytics from any device and to collaborate across their organization. 3. With every new MicroStrategy release, these files will include additional logging information. - modify the data a little bit. The license check takes place anytime within the next half hour of the time specified in the setting. MicroStrategy Telemetry Store: This service consumes all telemetry data from MicroStrategy Services layer, and do ETL process for the Platform Analytics project, also named as Platform Analytics Consumer. yaml. Ensure auth. With MicroStrategy Web, business users perform any of or all the major styles of BI - Scorecards and Dashboards, Enterprise Reporting, OLAP Analysis, Predictive Analysis, and Alerts and Proactive Notification - within a single, unified Web interface. x to version 10. Description The . x, the limit is 2 TB (2097152 MB) On MicroStrategy 11. In the MicroStrategy Library Configuration box, enter. Speed is important because it affects the user experience. iserver. 5. UNIX/Linux: After you deploy MicroStrategy Web Universal and log on to the mstrWebAdmin servlet using proper. xml file. Alternative means for resolving the issue include using the root user to run the commands, or performing a re-install with the desired user account who should be starting and stopping. You can find this ID by running the “ps” command. MicroStrategy Server Activation is a licensing technology that ensures that installations of MicroStrategy server products are authentic and have been legitimately licensed. Setting this to a higher limit does not mean the memory will be set aside for immediate use by the Microstrategy Intelligence Server. New Export Engine in MicroStrategy 2019 can deliver a high-quality PDF files with complete data, diversified widgets and various fonts, compared with the Legacy Engine in 10. The "status-iserver. Select Intelligence Server > Default Properties. You should periodically reevaluate the system and update it based on. On the other hand, some other configuration files stay as part of the configuration process and are useful to run the applications. This will prompt to stop the MicroStrategy Intelligence Server process in order to create the new Server Definition. MicroStrategy Library. Access to a machine with the keytool utility. In the Service drop-down list, select MicroStrategy Intelligence Server. x, users should see the Intelligence Server automatically rejoin a cluster upon restart. It collects real-time data (also known as telemetry) which is generated by different components of the MicroStrategy platform like the Intelligence Server. This book shows you how to implement Business Intelligence (BI) with MicroStrategy. In MicroStrategy cluster logic, Intelligence Server uses machine name to. The memory used by Intelligence Server is limited by the machine's virtual memory. Intelligence Server ensures the. MicroStrategy Web can be accessed from a third-party web browser, which means there are no additional storage requirements. Turn On the Sending Log to Messaging Services Feature. This allows the Intelligence Server to utilize the system memory resources. The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. The user must review the contents of any shell scripts that have been modified post installation that are used by MicroStrategy Intelligence Server Universal. From the Windows Start menu go to All Programs > MicroStrategy Tools > Web Administrator. x Administration page although the Intelligence Servers are set to automatically connect. '. Cube index generation will increase cube size. The cache. Users experience an issue where Intelligence Servers are getting frequently disconnected from the MicroStrategy Web 9. Once logged in, the user must navigate to. To view the current status of a MicroStrategy Intelligence Server Universal instance in a UNIX/Linux environment, run the command ‘mstrctl -s IntelligenceServer gs’ from the <MicroStrategy HOME>/bin directory using a command prompt / terminal. Step 3. xml should do. Windows: C:\Program Files (x86)\MicroStrategy\Intelligence Server\TLS. Helps you to manipulate the database in a single package. 52K. Together, they are often referred to as the JSON Data API. Select Intelligence Server > Default Properties. x information regarding the connected servers or to make changes manually to the connection properties of a MicroStrategy Intelligence Servers without using the MicroStrategy Web 9. This is likely the case if the service is disabled or. The default one is Interactive. Enter this value in the Server busy timeout field. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. Embedded is the power play — this is where the magic happens. Re-run the Configuration Wizard and enabled TLS. Open the MicroStrategy Configuration Wizard. Enterprise environments can have up to 4 clustered nodes. For more information regarding the MicroStrategy Web architecture or the process of customizing MicroStrategy Web, please refer to MicroStrategy Developer Zone (the Server Instance tab. For this reason, outbound network traffic needs to be allowed on port 443 in order to transmit the data. The following article lists the settings that require MicroStrategy Intelligence Server 10. Alternative means for resolving the issue include using the root user to run the commands, or performing a re-install with the desired user account who should be. Follow the below steps to change your environment's Library URL. Optionally, you can change the location or name of the Keystore file clientKey. The Java Virtual Machine has a heap that is shared among all Java Virtual Machine threads. e. 3 — Leverage Embedded. After upgrading from MicroStrategy 2019 Update 1 to MicroStrategy 2019 Update 2, it takes much longer to start the Intelligence Server. Turn On the Sending Log to Messaging Services Feature. The path to the Web server application is entered in the Web Server Application field. Expand Intelligent Cubes, and then select General. The client libraries are certified for use with the MicroStrategy Intelligence Server by operating system platform. With these statistic logs, administrators can observe the amount of time spent on each step of the process for a certain task in MicroStrategy Web. x interface. max_map_count be defined as 5,242,880 bytes. To launch the Database Administration Tool: Open the command prompt and navigate to the repository-administration bin folder: C:Program Files (x86)Common FilesMicroStrategy<MSTR_INSTALL>Repository epository-administrationin. reportID. xml file. trustToken and auth. Project default level preferences are set at the MicroStrategy Intelligence Server 8. 0, the behavior has been changed and the Intelligence Server does not use Messaging Services by default. 4. The DUMMY_SERVER instance for example, helps for the configuration of the Intelligence. The governing setting 'Maximum Report Execution Time' can be defined at the Project Configuration level in MicroStrategy, as shown below: Although there is no direct equivalent to this setting at the report level, there is an alternative that should suit many scenarios. MicroStrategy Web: Web Server. Enter the Intelligence Server address (IP or FQDN): Enter the port that the Intelligence Server service is running on. Follow these steps while connected to the MicroStrategy Intelligence Server machine to modify the processor affinity settings of an specific installation: Shutdown the MicroStrategy Intelligence Server Universal 8. The license check takes place anytime within the next half hour of the time specified in the setting. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. xml. There are a few steps that must be completed in order to restart the MicroStrategy Web Server on a Linux machine. x ODBC calls by default. Telcos using MicroStrategy can run. x from the Command Line, run the following command: $ mstrctl -s IntelligenceServer stop. In MicroStrategy 9. Select the Security Filters tab. Introduction Integrated Authentication to the MicroStrategy Intelligence Server utilizes the Kerberos authentication protocol to provide a Single Sign-On capability for MicroStrategy users connecting from Web or Developer from a Microsoft Active Directory environment. Add the IP to hostname mapping (e. renderer. Virtual memory is the amount of physical memory (RAM) plus the Disk Page file (swap file). Interactive jobs per project:Step. Seeing this issue after the upgrade to latest mstr software launched in Jan 2022. For example: "C:Program FilesMicroStrategyAdministratorCommand Managercmdmgr. 1 and above on Windows and Linux operating systems. x/9. KB48030: Font change is not applied to the graph in MicroStrategy 9. To retrieve a list of services on a machine, use the command mstrctl -m machinename ls. The default value is 256 megabytes. xml > isAliveRequestTimeoutMillis. x and 11. When publishing or updating a cube, MicroStrategy does not impose any limits on cube memory consumption except for the memory available on Intelligence Server machine. You will be able to: - connect to MicroStrategy Server. Select the "exportMaxCellsPlainText" setting and modify the "Maximum" value under "Other. command is one of the commands from the list below. Expand the Data Collector Sets node. To improve the data fetching performance for JDBC connections, Administrators can also increase the JNI Bridge Heap Space. Search for the files changed (below) in the target machine and create a backup of these files in all cluster nodes. 5 GB. polling. Performance is a combination of speed and scale. Click Connect. Capacity Planning for Platform Analytics. KB48030: Font change is not applied to the graph in MicroStrategy 9. In the top right corner, click MSTR User and then click Preferences to access Web Preferences. For steps to use the Configuration Wizard to upgrade your statistics repository and other MicroStrategy components, see the Upgrade Guide. If False (default), this feature will be disabled. pd_dump and pg_restore utility can be found in folder C:\Program Files (x86)\Common Files\MicroStrategy\Repository\pgsql\bin STEPS: 1. It performs the following critical tasks for the MicroStrategy BI platform: Runs queries, performs calculations, and formats reports. If the administrator would like to get the status of MicroStrategy Intelligence Server Universal 9. The default Load balance factor value is 1. By default, it is C:Program Files. This technical note will explain six methods for determining which server definition is currently being used:Click on Access MicroStrategy Platform to open MicroStrategy Web. The book starts by detailing the different. Expand Intelligent Cubes, and then select General. x when Intelligence Server is on Linux. This section discusses how to analyze your users' requirements, and the ways you can configure and tune your system to meet. war file to upgrade MicroStrategy Library. With the Parameterized Query option enabled, reports containing text filters and prompts will be executed using parameter markers (?) during SQL execution. HKEY_LOCAL_MACHINESoftwareMicrostrategyMicrostrategy Broadcast Server7. com) to the hosts file of the Library server machine to manually resolve the iserver name. To retrieve a list of services on a machine, use the command mstrctl -m machinename ls. The Intelligence Server generates various indexes that allow it to speed up performance for the various reports that would use the cube. Hover over a connected Intelligence server and click the Server Administration icon in the Properties column. sp. Create Response fileMicroStrategy Internal case number: 379474 -----Installation instructions-----This patch should be applied on top of MicroStrategy 9. x - 10. Both enabling and disabling logs are covered. 0. xml file. Performance degradation occurs because the MicroStrategyWhen a cluster of MicroStrategy Intelligence Servers connects to MicroStrategy Web, the following behavior can be observed in the MicroStrategy Web Administrator page: All MicroStrategy Intelligence Servers in the cluster will be added as a single unit, as shown with the example above. This is because registering MicroStrategy Intelligence Server Universal 9. By default: -Windows: C:WindowsSystem32driversetchostsThe MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. jks at this time via the sslClientKeystore parameter in the microstrategy. Or. Navigate to Configure MicroStrategy Intelligence Server > Web Single Sign-on. Start the MicroStrategy Intelligence Server. MicroStrategy OLAP Services allows users to analyze data by slicing and dicing, inserting new metrics and filters, and manipulating reports in-memory without executing queries against the data warehouse. From the DSN drop-down list, select the DSN used to connect to the metadata repository. On MicroStrategy 11. Launch MicroStrategy Web from the Landing Page of your environment. instancename is the name of a server instance, where required. MicroStrategy Developer must successfully connect to the Intelligence Server via the SSL port. From the pane on the left, select Servers. The heap is a location in memory used by the Java Virtual Machine (JVM). xxin omcat9w. Right mouse click on the project source of the Intelligence Server you wish to remove the trust relationship from. There's a reason we're at the top of the list. We tried all your suggestion but we still had the problem. The default value is 10. There will most likely be a direct correlation between user load and resource consumption. Platform Analytics is the new monitoring tool in MicroStrategy 11. This is also tuning for issues revolving around errors with Garbage Collection overhead limits and in some cases HTTP 500 errors. old' or delete the file. trusted. Right-click an Intelligent Cube and select Delete. The . Upload FilesOr drop files MicroStrategy Intelligence Server is the architectural foundation of the MicroStrategy platform. In addition, this release introduces new features across the analytics, mobility, and security platform - making it easier for users to build applications. Select Configure Intelligence Server, and click Next. The search specifies a base location in the directory tree as specified by the user in the "Search root distinguished name (DN)" field of the MicroStrategy Intelligence Server configuration. For detailed information refer to the System Administration Help. 67. Step 2. x to version 10. Watch on. We need to use the same REST port number when binding to the SSL certificate. The setting described below (ServerName) is NOT ONLY for the '&SERVERNAME' macro used in the history list URL. Click Dependencies tab, the above 3 dependencies are listed. 2. The default path is C:Program FilesApache GroupTomcatwebappsMicroStrategyWEB-INF. 3s. /mstrcfgwiz. MicroStrategy is an enterprise business intelligence application. 9 How to use Guacamole to copy and paste text or files in MicroStrategy on AWS; All new Download site is now available! How to increase the Java Heap size in Tomcat Application Server; KB41943: How to create a metric that calculates the distinct count of an attribute order to display total number of regist… The MicroStrategy Listener will monitor the Windows NT Application Event Log for new log entries and uses the log entry of Category 12 from the 'MSTRServer' Source as an indication that MicroStrategy Intelligence Server has been started. Select Automatic as the Startup Type option. Verify that the token file physically exists on the machine running MicroStrategy Web Services and that the token file is named according to the Intelligence Server machine name (I-SERVER_MACHINE_NAME. Type the command of . In MicroStrategy Developer, log in to a project source with administrative privileges. The ultimate goal of load balancing is to use all available resources in the most efficient manner, leading to improved system performance. Perform a single project test against one project. A new file 'status-iserver. They are part of the MicroStrategy REST Server, which is shipped inside the. What is the reason for the. d/ directory. The size of the connection pool: ConfigDefaults. x server using Microsoft IIS 7. You can search, view, and edit all project-level settings. This action loads the cube data section to memory and the status changes from AMF -> AMLF (back to Step 3). This will generate a new certificate and key pair and start the Intelligence Server. MicroStrategy Library Web Server on Windows: 4 GB or higher recommended per CPU core: 1. Optionally, you can change the location or name of the Keystore file clientKey. A Google account: This account will be used to deploy the Google instance that MicroStrategy will be deployed onto. Define the values for the following project governing options: Maximum RAM usage (MBytes): Defines the data size, in megabytes, to limit the amount of Intelligent Cube data that can be stored in Intelligence Server memory for a project at one time. A third party IP distribution tool such as Cisco Local Router, Microsoft Network Load Balancing, or Microsoft Windows Load Balancing Service distributes the user connections from the Web clients among Web Servers. Note, for more information refer to tech note KB10211 . In other words, this name needs to be recognizable as a network machine. Select Configure Intelligence Server, and click Next. Upload FilesOr drop files. KB20300: After removing the Tahoma font in MicroStrategy Web 10. Hello, We had the same problem after upgrading our 11. Selected. Enter your API Server and select your authentication mode and enter your credentials. Step 5. KB235107: How to Embed a Custom Font Without Having to Install it on the Client Machines using MicroStrategy Web SDK 9. Apache Kafka is an open-source distributed event streaming platform used by thousands of companies for high-performance data pipelines, streaming analytics and data integration. The following topics describe sizing guidelines to consider when you initially set up MicroStrategy. x-10. Telemetry Server Configuration: If you want to setup messaging services cluster, tick the check box "Create a cluster of three or more Telemetry Servers", input the local machine name and remote. To manually configure the MicroStrategy Repository, Platform Analytics, and the Collaboration Server database user, schema, and warehouse, use the steps below: Prerequisite : Ensure the mstr user, or any other non-root user used to register services, is a valid system user and able to log in. The Intelligence Server moves from the list to the Connected servers list and MicroStrategy Web is connected to the Intelligence Server. backtrace. The MicroStrategy Intelligence Server 9. How to use Guacamole to copy and paste text or files in MicroStrategy on AWS; All new Download site is now available! How to increase the Java Heap size in Tomcat Application Server; KB222220: Images are not displayed in Excel documents that are delivered through Distribution Services in MicroStrategy 9. Choose the individual modules to be logged. Related articles from the Community: Knowledge Base: How to Increase JVM Heap Size in IISA temporary file or folder is the location or files temporary generated by all the applications running on the machine. Right-click in the grid and select New to create a new connection mapping. g. Connect to the Developer Instance. Statistics logged. Select “MicroStrategy SDK”. When the MicroStrategy Web 9. Python coding is short, minimal and easy. x, the limit is 4 TB (4194304 MB) Note : Increasing the 'Maximum RAM for Working Set cache' setting will increase the possible limit amount of RAM that. You can build real-time or near-real-time MicroStrategy applications based on it. The user is the basic unit in the MicroStrategy security model. The MCM settings are in the Intelligence Server Configuration Editor, in the Governing Rules: Default: Memory Settings category. Right-click on User Defined and select New. Expand Intelligent Cubes, and then select General. Increasing this setting can increase caching efficiency in cases where the cache memory is full and several concurrent reports are trying to swap from disk. It turns data into reports for making and executing key organization decisions. This article narrates tips to retain PA repository at a. The Servers page opens. 3. zip file, with the. In the MicroStrategy Library Configuration box, enter. In MicroStrategy Developer, log in to a project source with administrative privileges. For more details on Intelligent Cube size increase, refer to the following technical note: KB33449: Intelligent Cube size increases over time in the MicroStrategy. Users should therefore run the "Monitor. Edit All Project-Level Settings. x when Intelligence Server is on Linux. Editing cluster membership is an administrative action and should be performed exclusively. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. We’ve introduced an all-new Advanced Properties panel for the Cube Editor in Workstation. Solution. Select the database instance. exe application from the extracted zip file. The PostgreSQL ODBC Driver has the best cube publish performance as it has the highest throughput. x machine: Run the command '. On MicroStrategy Intelligence Server 9. Iserver is on windows server, web server is apache tomcat. To specify a database instance, in the Intelligence Server Configuration Editor, select the General subcategory of the Server Definition category, and, in the Database Instance drop-down list, select the database instance to use for the History List. • Enterprise Manager. This action starts MicroStrategy Intelligence Server on 'M1. KB7295: What is the Memory Contract Manager in MicroStrategy Intelligence Server? PART 1. You can build real-time or near-real-time MicroStrategy applications based on it. The chart below shows how the statistics collection change from MicroStrategy version 9. 0. Significantly improves user-perceived query performance. User session and project session analysis. View the out-of-the-box Platform Analytics Project Dossier>Database Capacity Planning dossier, go to Overview This video shows how to change the user idle timeouts that affec MicroStrategy Web users. On MicroStrategy 10. labs. After installation, user may need to check those folder path to locate specific files. From the Windows Start menu go to All Programs > MicroStrategy Tools > Web Administrator. "" -n "" -u -p -f. x in Microsoft IIS to use Anonymous authentication, but for security reasons, would want to have the MicroStrategy Web Administration page to authenticate using Windows authentication, the following steps will ensure that a user must enter the application server's administrative credentials in order. Choose the individual modules to be logged. Choose the Statistic Database instance from 'Statistics' tab in Project Configuration. Refer to the following Community article for details on how to increase this setting: How to set the maximum Java Heap Size value for JDBC source connectivity in MicroStrategy Developer and Web 10. x. Computation is separate from storage, which enables you to scale computation resources independently of the data storage in your system. The. Choose Get Info if you are using a Mac. Prerequisites. In practice, you get a cert for the server. 230. The default Intelligence Server configuration settings, defined in the Intelligence Server Configuration Editor, are provided below. x > Configure Tomcat. The default value is 256 megabytes. x*. As seen below, the MicroStrategy Library version is still 11. Project. If the Startup type of the MicroStrategy Intelligence Server on 'M1' is set to 'Automatic', the available projects appear automatically. For New Export Engine in MicroStrategy 2019, when the number of concurrent user increases, the throughput (pages per minute) would remain almost unchanged. ) ,. From the DSN drop-down list, select the DSN used to connect to the metadata repository. war file on a default MicroStrategy Windows installation.