I'm working with a team that's trying to get a new set of development servers working and have run into all sorts of issues, mostly w/ Team Foundation Server and RS, but it has caused to us to ask a number of questions about the use of RS.
All our servers are virtual servers, running W2003. We have:
+ one SQL 2005 server installed w/ SSIS, SSAS, and just the RS databases.
+ one Web server (IIS6) hosting multiple websites. I installed the RS server components on this server as well.
+ [attempting to get working] on Team Foundation Server (TFS) using the previously mentioned SQL Server as its data tier; Report Server installed on this box too, by TFS.
Getting the SQL and Web server boxes installed and running was a snap, no problems there. TFS, on the other hand, has been a nightmare. So here's my question, based on various incongruent feedback from tech support...
Can there be multiple applications (like mulitple different web servers (not a web farm, but say 2 distinct and different web server boxes, and something like a TFS server) all use one SQL Server's Reporting Server databases on the backend?
It seems as if we're being told that either it can't be done or perhaps we need to use SQL Server Enterprise edition... which would blow out our expenses considerably.
Can anyone shed light on this? Thanks in advance.
If you have 2 RS instances (web servers) connecting to the same RS database, it is a web farm scenario and requires enterprise edition.
On the other hand, you can have 2 RS instances (web servers) each connecting to its own database. If the RS instance and its database is on different servers, you will need enterprise or standard edition. If they are on the same server, you can use any edition.
|||"each connecting to its own database"... OK, I might need some more help on that. So, I run SQL Server setup on WebServer1. OK, that's fine so far. Does that create the ReportServer and ReportServerTempDB databases on my single SQL Server box?
Now, I run the SQL Server setup disc on WebServer2, do I need to tell it to use different database names at some point?
Sorry for the confusion, just trying to get clarity around all this. I have two separate web servers and one sql server, 3 all told (actually 1 physical box, 3 virtual servers, but that shouldn't matter should it?). WebServer1 and WebServer2 are running different websites altogether. I want each web server to be able to use Reporting Services technology as needed and I want to only have one Sql Server box, preferably Std Edition. I guess that's what I'm trying to find out if it's feasible.
Thanks again.
|||Virtual server makes no different in the argument.
Do you need the 2 web sites to share content? (i.e. you upload a report to website1, and it shows up on website2) If so the 2 websites need to point to the same RS databases on your SQL machine, and it's a web farm scenario.
If the websites can be independent, then you can use standard edition. You install RS on webserver1, using the "file-only" install option. Post-install you use the configuration tool and create RS databases for webserver1. You do the same for webserver2, but the database will be different. There will be a total of 4 databases on the SQL machine, 2 for webserver1, and 2 for webserver2.
No comments:
Post a Comment