September 10, 2009 at 12:17 am
Hi,
I have installed SQL Server 2005 EE Reporting Services(NO Database Engine has installed.Now how can we make sure that the version of the report server?
I know for database engine we can use SELECT SERVERPROPERTY('PRODUCTLEVEL')
But I need to find out the Version of Reporting services.
thanx
September 10, 2009 at 12:38 am
gmamata7 (9/10/2009)
Hi,I have installed SQL Server 2005 EE Reporting Services(NO Database Engine has installed.Now how can we make sure that the version of the report server?
I know for database engine we can use SELECT SERVERPROPERTY('PRODUCTLEVEL')
But I need to find out the Version of Reporting services.
thanx
navigate to your report server using IE. for example
http://MyReportServer/Reportserver
you will see the version number displayed on the page
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 10, 2009 at 12:41 am
Execute xp_regread 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Microsoft SQL Server\Reporting Services','Version'
http://technet.microsoft.com/en-us/library/bb630446.aspx
HTH
September 10, 2009 at 3:26 am
Vishal Singh (9/10/2009)
Execute xp_regread 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Microsoft SQL Server\Reporting Services','Version'http://technet.microsoft.com/en-us/library/bb630446.aspx
HTH
bear in mine that, the op said the database engine is not installed. checking the web page is easier
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 10, 2009 at 3:47 am
September 10, 2009 at 1:56 pm
I'm sorry, actually I want to know the EDITION not the version.
I have checked the version in IE & it is 9.00.4035.00. So I sure that I have SP3 but How could I know the EDITION like Developer or Standard or Enterprise??
September 10, 2009 at 2:00 pm
connect to reporting services in managment studio and it says edition and verion right there.
:crazy: :alien:
Umar Iqbal
September 10, 2009 at 7:01 pm
connect to reporting services in managment studio and it says edition and verion right there
I have connected the Reporting services using Management studio BUT there is NO way to find the edition & version from there.
Could you explain me how did you find that information about Reporting Services EDITION by connecting to Reporting services from Management studio?
many thanx
September 11, 2009 at 11:14 pm
Is there NO way to know the EDITION of SQL Server 2005 Reporting Services??
September 13, 2009 at 10:23 pm
For the edition, you can check the system registry. The location of the value is different for each SSRS 2000 and 2005. For SSRS 2000 the value is located at HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\80\Reporting Services\ProductCode. For SSRS 2005 the value is under HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.#\Setup\ProductCode.
The SSRS 2000 editions are as follows:
Standard: {B19FEFE7-069D-4FC4-8FDF-19661EAB6CE4}
Enterprise: {33FE9EED-1976-4A51-A7AF-332D9BBB9400}
Developer: {2879CA50-1599-4F4B-B9EC-1110C1094C16}
Evaluation: {7C93251A-BFB4-4EB8-A57C-81B875BB12E4}
I searched high for the SSRS 2005 values, I gave up on searching low for these since I could have installed SSRS 2005 for each edition and obtained the values but I'm not doing that today. Maybe tomorrow.
Also, you can check by going to Control Panel --> Add/Remove Programs --> Select Microsoft SQL Server Report Services and click on the "Click here
for support information" link.
Or, for the programmer in every DBA:
ReportingService2005 rs = new ReportingService2005();
rs.Credentials = System.Net.CredentialCache.DefaultCredentials;
rs.ServerInfoHeaderValue = new ServerInfoHeader();
rs.ListChildren("/", false);
Console.WriteLine(rs.ServerInfoHeaderValue.ReportServerVersion);
Console.WriteLine(rs.ServerInfoHeaderValue.ReportServerEdition);
Console.WriteLine(rs.ServerInfoHeaderValue.ReportServerVersionNumber);
September 13, 2009 at 10:43 pm
September 14, 2009 at 2:08 am
Vishal Singh (9/13/2009)
umar iqbal (9/10/2009)
connect to reporting services in managment studio and it says edition and verion right there.Well I wonder that. I am eager to know where.
ROFL, you can see the edition in Management studio, for Reporting Services 2008, not 2005. the properties tab in 2008 is different to the 2005.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 15, 2009 at 5:45 am
Gamamat7, this took me some time to figure out as well. I had the same problem. The only way to figure out what *Edition* you are running is by looking for specific words in the RS Log files. Here its will laso tell you what Edition the ReportServer Database are installed on as well
Follow this link and all will be clear 🙂
http://technet.microsoft.com/en-us/library/bb630446.aspx
Schwizzla
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply