February 23, 2009 at 1:39 pm
I'm trying to determine whether I have standard or enterprise installed on my reporting services box. My 2000 box only has Report Manager installed. How do I check whether I have standard or enterprise for 2000?
My other reporting services box has 2005 and it does have SSMS installed, but when I try to connect to Reporting Services by browsing for a local instance nothing shows up. How do I check whether I have standard or enterprise for 2005?
Any help is greatly appreciated.
February 23, 2009 at 1:55 pm
Run the code below in Management studio, check the link below for more options.
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
http://support.microsoft.com/kb/321185
Kind regards,
Gift Peddie
February 24, 2009 at 7:57 am
Gift Peddie (2/23/2009)
Run the code below in Management studio, check the link below for more options.
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
Thanks for the info. Any ideas on my SQL 2000 box? Shouldn't I be able to connect to Reporting Services using SSMS? When I browse for Reporting Services on my 2000 or 2005 nothing shows up.
February 24, 2009 at 8:16 am
That code works in all SQL Server from 6.5 the only difference is where the code is executed so you need to run that code in Query Analyzer for your SQL Server 2000 box. You should also know SSRS in 2000 is a separate add on in 2004 that is four years after 2000 is live so you need to make sure you are in SP4.
Kind regards,
Gift Peddie
February 24, 2009 at 8:24 am
Gift Peddie (2/24/2009)
That code works in all SQL Server from 6.5 the only difference is where the code is executed so you need to run that code in Query Analyzer for your SQL Server 2000 box. You should also know SSRS in 2000 is a separate add on in 2004 that is four years after 2000 is live so you need to make sure you are in SP4.
Now that I have some more information about how my RS is setup, let me run this by you. Both of my RS boxes have JUST the reporting services portion of SQL installed. The 2005 does have the DB engine installed, but the service is off and will remain off according to the higher ups.
Both RS boxes have the DB that they use on another server for their respective version. So, my thought is that the RS boxes have the same edition (enterprise) as the other servers that contain the DB that each RS box is using. Does that make sense?
February 24, 2009 at 8:37 am
Now that I have some more information about how my RS is setup, let me run this by you. Both of my RS boxes have JUST the reporting services portion of SQL installed. The 2005 does have the DB engine installed, but the service is off and will remain off according to the higher ups.
The technically unskilled should not make SSRS architecture decissions because SSRS services is initialized by the relational engine so to leave it off in a box running SSRS is not techinically valid. The correct setup will be running only the two reportserver databases with the relational engine and all system databases running.
Kind regards,
Gift Peddie
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply