SQL Reporting services

Bakedgoods

Bakedgoods

Bakedgoods

Capodecina
Permabanned
Joined
31 Dec 2003
Posts
5,172
Location
Barrow-In-Furness
Has anyone used this before?

I'm trying to get an understanding of exactly what and how it needs to be setup.

I've read that the SQL server and the Reporting Services service needs to be on the same server as your Web Server, which isn't really possible..

I've got the client end software but what do I need to do? Just install the reporting services bolt addon on the SQL Server?
 
hi,

Reporting services needs to be on the same server as IIS to work as it uses a web-interface to manage and run the reports through. If you can I'd look at using 2005 (SP2) as the eariler versions of RS where a bit flaky.

akakjs
 
Yeah, will probably have reporting services and IIS on a seperate server from the SQL Database.

I've struggled finding much information on this to be honest, I think i'll probably get a book to help me learn how to use it.
 
It is possible on 2005.
You can specify which database to use in the configuration manager for 2005, not sure on 2000 though.
 
From what i've read you can do the same in 2000 :)

Many organizations will probably find that they need to split Reporting Services off to its own server. This means buying another server, licensing SQL Server (the full product; Reporting Services doesn't work with MSDE), and of course setting everything up - costs that can easily run into four or five figures. So keep an eye on memory and CPU utilization, as well as statistics within SQL Server, as you evaluate this software for actual production use.
Click to expand...

http://www.developer.com/db/article.php/3323401
 
You must log in or register to reply here.
Back
Top Bottom