How to tell Version installed with only SSAS installed

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » How to tell Version installed with only SSAS...

How to tell Version installed with only SSAS installed

Rate Topic

Display Mode

Topic Options

Author

Message

stebennettsjb

Posted Wednesday, January 16, 2013 4:41 AM

SSC Veteran

Group: General Forum Members
Last Login: Friday, January 18, 2013 2:45 AM
Points: 297, Visits: 582

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

Post #1407745

anthony.green

Posted Wednesday, January 16, 2013 4:44 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

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.

Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1407746

stebennettsjb

Posted Wednesday, January 16, 2013 5:01 AM

SSC Veteran

Group: General Forum Members
Last Login: Friday, January 18, 2013 2:45 AM
Points: 297, Visits: 582

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

Post #1407750

anthony.green

Posted Wednesday, January 16, 2013 5:03 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

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.

Post #1407753

Want a cool Sig

Posted Wednesday, January 16, 2013 7:25 AM

SSC Veteran

Group: General Forum Members
Last Login: Friday, April 26, 2013 2:58 PM
Points: 221, Visits: 452

This post may help:
http://www.sqlservercentral.com/Forums/Topic262014-17-1.aspx

---------------------------------------------------------------
Mike Hahn - Future MCM 2025 Smile

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 Cool

I want to win the lotto BigGrin

I want a gf like Tiffa w00t

Post #1407830

stebennettsjb

Posted Wednesday, January 16, 2013 8:14 AM

SSC Veteran

Group: General Forum Members
Last Login: Friday, January 18, 2013 2:45 AM
Points: 297, Visits: 582

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

Post #1407865

« Prev Topic | Next Topic »

Permissions