How to tell Version installed with only SSAS installed

Question

How to tell Version installed with only SSAS installed

Staggerlee

SSCertifiable

Points: 5272
More actions
January 16, 2013 at 4:41 am

#266993

Hi all,
I have to report on which editions and versions of SQL we have installed in our environment. I can get the Version info easy enough. But we have 2 boxes, One a 2005 box and the other 2000. That only have SSAS installed. I cant seem to find a way to work out which edition they are using.
Anyone know a way to get it?
Thanks

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Ant-Green SSC Guru Points: 113507 More actions · Answer 1

2005 you can connect to the SSAS server is SSMS and it will show you the version number as it does if you connect to the engine.

Unsure on 2000, would of thought the same, but dont have a 2000 server any more to play with so cant advise on that.

Staggerlee SSCertifiable Points: 5272 More actions · Answer 2

Hi sir,

thanks for the reply.

Any ideas on how to get the edition?

For the 2000 box.

I have gone though the registry keys for HKLM-Software-Microsoft-Microsoft SQL Server + MSSQLServer and found no mention of it.

I have however. now found a License.txt in C:/program files/microsoft sql server/mssql/reporting services

which says

Microsoft SQL Server 2000 Reporting Services, Developer Edition

so far its the only mention of edition i can find...

Thanks

Ant-Green SSC Guru Points: 113507 More actions · Answer 3

Google may be your friend on the 2000 side of things, as I say I dont have SQL 2000 any more so cant advise on that.

Mike.Hahn SSCarpal Tunnel Points: 4053 More actions · Answer 4

This post may help:

http://www.sqlservercentral.com/Forums/Topic262014-17-1.aspx

---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar :hehe:
I want a personal webpage 😎
I want to win the lotto 😀
I want a gf like Tiffa :w00t: Oh wait I'm married!:-D

Staggerlee SSCertifiable Points: 5272 More actions · Answer 5

Thanks for the replies.

So far im sorted on Versions.

Edition for 2000 im taking from the license.txt file. found in reporting services folder.

Edition for 2005 im lost and still hunting the web.

Thanks again