November 13, 2007 at 2:09 am
We are running SQL Server 2000 databases and were proposing to go to SQL Server 2008 next year. However, one of our suppliers wants to move a database to SQL Server 2005 and wants to use Reporting Services. We have never used Reporting Services with SQL Server 2000 though we did install it on a test server.
We appreciate that SQL Server 2005 uses SQL Server Management Studio (?) but are Reporting Services bundled into it or are they installed separately? Can anyone point us towards an idiot’s guide to the differences between SQL Server 2000 and SQL Server 2005
:Whistling:
Madame Artois
November 13, 2007 at 5:11 am
Reporting Services 2000 and 2005 and managed virtually the same. 2000 uses Visual Studio 2003 and 2005 uses Visual Studio 2005 for creating reports. Both versions of reporting services will work with either version of the database engine.
Management Studio does not play into reporting services too much. You use Visual Studio to author and publish reports, and all of your security and actually running the reports can be done either through creating a custom UI, or using the web-based report manager that is installed with the server components.
If your vendor is proposing you install SQL 2005 and Reporting Services, I am sure they can show you what needs to be installed and where. Since this is a vendor it is probably because their product uses the reporting engine and you will not be creating custom reports or having users use report manager. In a configuration like this, there is very little management overhead to it, so you should not be too afraid.
As an aside - don't let your vendors drive your IT choices. You are the customer - tell them what you want.
November 13, 2007 at 5:34 am
Thanks for the info. Should be able to sort it out.
By the way, we are an emergency service; sometimes we have no options and are driven!!
:Whistling:
Madame Artois
November 14, 2007 at 4:24 am
And remember, you don't have to install Reporting Services for SQL Server to function.
SSRS is a separate install that you are required to choose (or not) during the initial SQL Server installation. If you don't choose to install SSRS, you can always go back and install it later. But you aren't "required" to install it with any version of SQL Server, 2000 / 2005 / 2008 (I'm pretty sure).
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply