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.
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
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.
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