How to configure a workstation to use IT Analytics


Article ID: 180270


Updated On:


IT Analytics




Using IT Analytics on a client requires two Microsoft pre-requisites to be first installed. Note: Only install the correct version of these components based on the workstation's operating system and whether it is 32 or 64-bit. 

  • Microsoft Office 2003 Web Components (even if Microsoft Office is already installed)
  • 9.0 OLE DB Provider

If these are not installed, various warnings will occur when trying to access pivot tables or cubes in IT Analytics in the Altiris Console. For example, "The query could not be processed. An error was encountered in the transport layer.". This is a Microsoft SQL error.

These files can be downloaded from the following Microsoft web sites:

Microsoft Office 2003 Web Components

Feature Pack for Microsoft SQL Server 2005 - April 2006
, and from this site, download SQLServer2005_ASOLEDB9.msi for Windows 32-bit operating systems.

Related Articles

Warning "This website uses a data provider that may be unsafe. If you trust the website, click OK, otherwise click Cancel." occurs when using IT Analytics

Error "The query could not be processed. An error was encountered in the transport layer. The peer prematurely closed the connection." occurs when trying to use an IT Analytics pivot table or cube on a workstation

How to install and use IT Analytics and its report packs

Warning "The authenticated user cannot access the requested cubes." occurs when trying to access an IT Analytics cube