Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jpotucek
Constraint Violating Yak Guru
273 Posts |
 Posted - 2006-08-09 : 09:17:35
|
| Anyone running Reporting Services? I need to get it deployed and but I'm having trouble getting my brain around how it gets installed. We have a Production SQL Server instance (2000 Standard Edition) running our Main APPS and then a Sharepoint Instance on another box. Today I'm installing yet another Instance on the Shareport Database Server for CRM - I am going to want to report against Sharepoint, CRM and Probably Exchange.. Where would Reporting Services Server get installed? On one of my SQL Servers? on a Seperate Admin Server? on my Web Server? Do I need a seperate Instance for my Reporting Services Backend Database?Also, I have Reporting Services 2000 Developer Edition on our MSDN Subscription CDs.. Is this what I use in my Production Environment and if not, where can I download Reporting Services from? I can't find it on the MS Site.. Thanks for your help! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-09 : 13:04:02
|
| It just depends what you want. The license is free if you install it on the database server, but that means you'd need IIS on it. Due to this, we don't allow RS on the database servers, so instead we install it on the web servers. We purchase additional licenses due to this. No you don't use developer edition for a production environmnt. Developer edition is only for development purposes, hence its name. You can get the other editions from your MSDN CDs. But keep in mind that you'll still need to purchase the licenses if you don't install it on the database server. Check out the MS site for details as this is thoroughly explained there.Tara Kizer |
 |
|
|
|
|
|
Deploying Reporting Sevices