How to configure a workstation to use IT Analytics

book

Article ID: 180270

calendar_today

Updated On:

Products

IT Analytics

Issue/Introduction

 

Resolution

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
http://www.microsoft.com/downloads/en/details.aspx?FamilyId=7287252C-402E-4F72-97A5-E0FD290D4B76&displaylang=en

Feature Pack for Microsoft SQL Server 2005 - April 2006
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=df0ba5aa-b4bd-4705-aa0a-b477ba72a9cb&DisplayLang=en
, 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
http://www.symantec.com/business/support/index?page=content&id=TECH161735

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
http://www.symantec.com/business/support/index?page=content&id=TECH150390

How to install and use IT Analytics and its report packs
http://www.symantec.com/business/support/index?page=content&id=HOWTO39470

Warning "The authenticated user cannot access the requested cubes." occurs when trying to access an IT Analytics cube
http://www.symantec.com/business/support/index?page=content&id=TECH174986