Follow

TX DWA Prerequisites

Introduction

This document covers the software requirements needed to run TX DWA. It does not cover hardware requirements or recommendations on server configuration. Refer to Microsoft’s recommendations for Microsoft SQL Server sizing when deciding on your hardware needs and configuration.

Software Prerequisites

Shown below are the minimum software requirements needed to run TX DWA. These are split into two areas: Application and Database. If TX DWA is going to be installed on a server that does not house the Microsoft SQL Server Installation, then those requirements must manually be installed. If Microsoft SQL Server and TX DWA reside on the same server then all but the .NET Framework will be installed during the Microsoft SQL Server installation.

Application Server

When installing TX DWA on a separate server from Microsoft SQL Server, the following components need to be installed:

  • .NET Framework 4.6.2 or higher
  • Core XML Services (MSXML) 6.0
  • Microsoft SQL Server Native Client
  • Microsoft SQL Server System CLR Types
    • Install version that corresponds to the version of SQL Server
  • Microsoft SQL Server Management Objects
    • Install version that corresponds to the version of SQL Server
  • Microsoft SQL Server Integration Services (SSIS)
    • Only necessary if SSIS will be utilized. See SSIS section for further details.

Using a Microsoft Azure SQL server requires the application server to be installed with the following components:

  • .NET Framework 4.6.2 or higher
  • Microsoft SQL Server System CLR Types
    • Install version 2016
    • Install version 2008 R2 - if data types Geography or Geometry is bulk copied
  • Microsoft SQL Server Management Objects
    • Install version 2016

Database Server

On the Microsoft SQL server, the above requirements (except the .NET Framework), are installed during the SQL installation. In addition to those, the following minimum requirements must be met:

  • Microsoft SQL Server 2008/2008 R2/2012/2014/2016. Minimum edition is Standard with the following components installed:
    • DB Engine
    • Integration Services (SSIS)
      • Only necessary if SSIS will be utilized.
    • Analysis Services (SSAS)
      • Only necessary when using OLAP Cubes.
  • Microsoft Azure SQL Server (DB Engine only)

TX DWA Advanced Feature Requirements

Most of TX DWA functionality can be accomplished using the Standard version of Microsoft SQL Server; however, there are some features that require the Enterprise addition.

The following TX DWA features require Microsoft SQL Server Enterprise Edition or SQL Server 2016 SP1:

  • Compression of tables and indexes
  • Partitioning on tables
  • Non-Physical Cube Perspectives (Standard Perspectives on SSAS)
  • Incremental Load on Cubes
  • OLAP translations where you translate dimension member display values

Verify Requirements

This section will help you make sure you have met the necessary requirements.

.NET Verification

The .NET version can be verified by:

  1. Click on the Windows Start button.
  2. Type “run” (without the quotes), and click enter.
  3. Type “%windir%\Microsoft.NET\framework” (without the quotes), and click enter.

Microsoft SQL Components Verification

Microsoft SQL Server Native Client, Microsoft SQL Server System CLR Types, Microsoft SQL Server Management Objects and Microsoft SQL Server Integration Services (SSIS) can all be found by checking the list of installed programs.

In Windows, navigate to the Control Panel and then Programs and Features.

The image below shows the necessary requirements listed above have been met. It also shows that Microsoft SQL Server 2016 (64-bit), is installed. This is due to having SQL Server Installation Services (SSIS), a component of the Microsoft SQL Server installation, installed. 

SSIS Verification

To verify the installation of SSIS, click on the Windows Start button, type “services.msc” (without the quotes), and hit enter.

The image below verifies the installation of SSIS.

SSIS Notes

When using SSIS for data transfer there are a couple of options available when installing TX DWA on a separate server.

  1. Install SSIS on the Application server. Since there will be two installations of SSIS (Application and Database), a separate license for SSIS will be needed.
  2. Install SSIS and the TX DWA Remote SSIS Execution package on the Application server.

MSXML Version Verification

To verify the version of MSXML on the server, navigate to C:\Windows\System32 folder. In the search field, type in “MSXML*” (without the quotes). The results should look similar to the image below.

TX DWA Activation

To use TX DWA, you will need a valid activation code, which is usually provided by your TimeXtender partner. If you are not yet a TimeXtender customer, you can request a trial activation code valid for a limited time. The easiest way to activate TX DWA is over the Internet. If your machine does not have an active internet connection, email support@timextender.com to obtain an offline activation file.

Troubleshooting

Shown below are a few of the most common errors found when using TX DWA without all of the prerequisites met. If you encounter a problem and it’s not listed below, please email support@timextender.com or visit the knowledge base.

Problem 1 - Error writing to file.

  • Issue: Microsoft .NET 4.6.2 or higher is not installed.
  • Resolution: Install Microsoft .NET 4.6.2 or higher or, using the TX DWA installer, run the setup.exe (not the msi), and DWA will download and install it automatically. See the image below for reference.

Problem 2 - Error creating DTS package for…

  • Issue: SSIS is either not installed or running.
  • Resolution: Verify SSIS is installed and running. See SSIS Verification above to check.
    • If SSIS is missing, it can be installed using the Microsoft SQL Server installation.
    • If you encounter the following image then SSIS is not running. Click on Start in the upper left to start the service.

Alternatively, right-click SQL Server Integration Services and choose Start Service.

Problem 3 - Error could not load file or assembly

  • Issue: SQL Shared Management Objects is not installed.
  • Resolution: Install the appropriate version of Microsoft’s SQL Shared Management Objects that corresponds with the version of Microsoft SQL Server. Follow the link below for more information and links to download.
  • Link to SMO

Problem 4 - TX DWA will not launch after installation

  • Issue: Missing the appropriate .NET Framework.
  • Resolution: Reinstall TX DWA using the setup file or download Microsoft’s .NET Framework 4.6.2 or higher.

Problem 5 - An Error Occurred while loading a list of projects from the database

  • Issue: The user does not have appropriate permissions to access the project repository.
  • Resolution: Verify the user has at least read access to the project repository.

Problem 6 – There was no endpoint listening at…

  • Issue: This occurs during activation of a license or trial when there is no internet connection on the machine.

error6.png

  • Resolution 1: Verify the machine has an active internet connection. If needed, email support@timextender.com to obtain an offline activation file.
  • Resolution 2: If direct internet access is not allowed perhapse access by proxy is. Try configuring the proxy and reactivate the license.

proxy.png

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.