Way to know Sql Server or Analysis Server 2005 Version, SPs and Edition installed

Sunil (my Lead) asked me about this. When I googled, I found it here. But our problem was that we had only Analysis Services and Integration Services running on our machine. Finally I found that in MSDN forums, that by looking at the version number displayed along with the Server Instance it is also possible to the SP installed on the machine:

- 9.00.1399 for RTM
- 9.00.2047 for SP1
- 9.00.3042 for SP2 and so on.

There are 2 ways to know the Edition of Analysis Server :

1) Run Regedit, Open the Path: %HKEY_LOCAL_MACHINE\SOFTWARE\MICROSOFT\Microsoft SQL Server\MSSQL 2.0\Setup. You will see the Edition Details on the right Pane

2) On SSMS, Connect to Analysis Server, Right Click on the SSAS Server, Report-> Standard Reports -> General


Comments

Popular Posts