How to determine the version of Microsoft Analysis Services Running?

Hi Folks --

I have Microsoft Analysis Services running and I have applied Service
Pack 3a from April, 2003. How do I tell if I am current, or validate
what version of MSAS I am running?

The "About _" says I am running Version 8.00.382 of MSAS. Is there a
better/different way to determine version?

Many thanks for any help.

Pete

Pete Hohenhaus
Kirkland, WA, East Side, Seattle

Make sure you apply SP3 for Analysis Services. They are actually different
installs and come as separate downloads off the main SP3 download page. If
you have SP3 running, it should report back version 8.00.760 as the version
number via the method you described below.

Sean


--
Sean Boon
SQL Server BI Product Unit

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.

"Pete Hohenhaus" <cam_pete (AT) hotmail (DOT) com> wrote

Below is the section titled: "Verifying the Appropriate Service Pack or Hot
FIx Level" from an in-progress Analysis Services Operations Guide white
paper.

--------------------------------

"Ensuring that you are working on an Analysis Services instance that has the
latest service pack (or hot fix) can assist you in resolving problems.
Similarly, when working on an Analysis Services client computer, you need to
ensure that the most recent service pack (or any applicable hot fix) has
been applied to that client. Unfortunately there isn't a quick and easy way
to determine the service pack level (or hot fix) that has been applied to an
Analysis Services instance or to an Analysis Services client computer.

To determine the level of service pack, including any hot fixes, there are
four different files that you have to be concerned with to determine the
level of your installation:

Analysis Services engine: To determine the version of Analysis Services,
locate the msmdsrv.exe file in the Microsoft Analysis Services\Bin folder
and then right-click this file to get the version information from the
Properties dialog box. If the file version is 8.00.760, you have applied
SP3.

DSO: To determine the version of DSO, locate the msmddo80.dll file in the
Program Files\Common Files\Microsoft Shared\DSO folder and then right-click
this file to get the version information from the Properties dialog box. If
the file version is 8.00.0760, you have applied SP3. While the version of
the msmdsrv.exe and msmddo80.dll files will be identical after a service
pack installation, the installation of hot fixes can result in different
values for these two crucial files.

Analysis Manager: To determine the version of Analysis Manager on a client
computer, right-click the Analysis Servers object in Analysis Manager and
then click About Analysis Services. If the version is 8.0.760, you have
applied SP3. If you click About Microsoft SQL Server Analysis Services on
the Help menu in Analysis Manager, the build number returned is the build
number of the Analysis Manager MMC.

Pivot Table Services: To determine the version of Pivot Table Services,
locate the msolap80.dll file in the Program Files\Common Files\System\Ole DB
folder and then right-click this file to get the version information from
the Properties dialog box. If the file version is 8.00.760, you have applied
SP3. (msolap80.dll) "


Hope this

--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Practices Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Pete Hohenhaus" <cam_pete (AT) hotmail (DOT) com> wrote