October 27, 2008 at 5:23 pm
Hi All,
We have 3 production servers, which need reporting services.We have decided to go for a separate 4th server to install Reporting Services(in order to improve performance)
My question is while installing the reporting services in the 4th server do we need to choose the database engine option?
If we need to choose database engine where will be the report server database created?
If we do not need to choose database engine where will be the report server database created?
3 production servers need to use the 4 th server as reporting server?
considering all what is the way to configure 4th server?
October 27, 2008 at 9:04 pm
You can choose which server you wish to use for the ReportServer and ReportServerTempdb databases.
You do not need to install SQL Server (database engine) on your 4th server if you don't want to. If this is what you want, the installation of Reporting Services will install everything needed but will not configure the installation. You will then need to run the "Reporting Services Configuration" utility which you can find in the SQL Server 2005 program group. This utility will ask you for the name of the SQL Server instance that will be used.
October 27, 2008 at 9:26 pm
Thank You,
We do not want to install the report server on any of the production servers. In that case I need to install the database engine along with reporting services in 4th server?
and one of the production servers is hosting sharepoint apllication so I need to configure the reporting services in sharepoint mode. The other production will use native mode. So my question is can we use the report server database installed on 4th server for both production server as the one is in sharepoint mode n the other is native mode?
and how will be the growth of the report database on 4th server? I need to give the space requirements to build the 4th server
is this a good approach? plz advice me
Thanks in advance
October 28, 2008 at 10:32 am
I may have misunderstood at some point so apologise if this is wayyyyyy off track.
If you want to have the 4th server as the RS server, that is actually the best way and I will explain why. You say you have two RS requirements, SharePoint and Normal, can I assume for a moment that these are on separate SQL servers. If this is the case you will need two instances of RS, one for SharePoint and one for the other.
Two instances of RS will be required with two sets of RS databases (one for each server), this will need to be configured from your 4th server.
The RS configuration process creates the database specific RS databases for you (eg. Northwind would have ResportServer$Northwind and ReportServer$NorthwindTempDB). So you would end up with ReportServer$Sharepoint(and TempDB) and ReportServer$Other(and TempDB).
I would personally base these database on the specific remote servers, for performance as well as budgetary constraints.
Don’t forget that the RS server (4th server) needs a full SQL Server licence (if you are only installing RS Standard licence will do even if you have enterprise on the other servers) BUT you will also need the CAL's as well (to allow connectivity to your source databases) (assuming you dont have CPU licenses.
Hope this has been of help (as long as I didn’t go off o n a tangent). We recently went through a predicament like this. 🙂
Adam Zacks-------------------------------------------Be Nice, Or Leave
October 28, 2008 at 12:33 pm
thanks a lot Schadenfreude,
Could you plz me provide me document that supports, the way we are approaching is a best practice. Because I suggested the one you explained me, but my boss wants the document that supports the scenario.
thank You
October 28, 2008 at 1:23 pm
I think it is more like client - server for reporting services. The client you then connect to the MAIN SQL which creates the databases mentioned.
The 4th box you configure the IIS and where to run the reports from but the database configuration is on the MAIN SQL box.
Well that my understanding.
October 29, 2008 at 3:08 am
TRACEY (10/28/2008)
The 4th box you configure the IIS and where to run the reports from but the database configuration is on the MAIN SQL box.Well that my understanding.
Thats correct. Though in this case there are two SQL boxes with two core applicationce, hence the requirement for two RS instances.
It just makes good sence to have the RS services on the 4th box and then have the RS databases stored remotely. Otherwise you need to think about proper licensing for the 4th box and CALS for users who use it.
I will try and track down a best practice doc for you.
Adam Zacks-------------------------------------------Be Nice, Or Leave
October 29, 2008 at 4:43 am
Schadenfreude-Mei (10/29/2008)
I will try and track down a best practice doc for you.
Ok so if you have a read of: http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/rsdepgd.mspx it explains some key considerations. Figure 4 gives you a diagram of the proposed structure and a little explanastion (from an MS point of view).
Other then storage considerations, I always keep an eye on the license and overall cost to the business as well.
Hope it helps. 😉
Adam Zacks-------------------------------------------Be Nice, Or Leave
October 29, 2008 at 10:56 am
That means not to store the Report server n reportservertempdb database on 4th server(RS server)?
then why we need the 2 database engines installation on 4th server?
or do we need to place 1 set of the report server n tempdb on Production server 1(for sharepoint) and other report server n tempdb on Production server 2(Native mode reports) and just reporting services installation on 4th server(No database engine)
Iam confused....
plz advice me..
Thank You
October 29, 2008 at 11:03 am
madhu.arda (10/29/2008)
do we need to place 1 set of the report server n tempdb on Production server 1(for sharepoint)and other report server n tempdb on Production server 2(Native mode reports)
and just reporting services installation on 4th server(No database engine)
Correct as above. Only RS serices go on 4th server. All databases to be hosted on the seperate database servers (SharePoint and Other). 😎
Adam Zacks-------------------------------------------Be Nice, Or Leave
October 29, 2008 at 11:12 am
Could you plz explain me why this approach is better?
any performance gain?
October 29, 2008 at 11:25 am
madhu.arda (10/29/2008)
Could you plz explain me why this approach is better?any performance gain?
1. All data processing kept on an already active SQL server (no need to install, configure and maintaine new server).
1a. Cost saving in licenses (assuming CPU licence on PROD SQL) no additional CAL's required. Just SQL Server Standard (required for RS).
2. Ease of maintenance and admin. By not having an extra SQL server you dont have to configure, backup and maintain the extra server and all the BAU tasks that entails.
3. Linked Servers, Cross authentication and all that entails (having an extra server adds to required security and permission configuration requirements).
Basically having the Report databases on the RS server will add complexity and hassle which you dont really need.
But its up to you. Going home now. Night night. 🙂
Adam Zacks-------------------------------------------Be Nice, Or Leave
October 30, 2008 at 10:51 am
I think we can not configure one reporting server(4th) for 2 different production servers...because once you configured in sharepoint mode by using report server configuration manager, how can we configure the same report server for the 2nd production server in nativemode?
Iam not sure...correct me if Iam wrong..
October 31, 2008 at 3:05 am
Like I have siad in recent posts, you need to have two instances of RS.
Adam Zacks-------------------------------------------Be Nice, Or Leave
November 9, 2008 at 3:37 pm
Thank You
Is the performance will be improved if the 4th server(reporting server) having installed 2 instances with database engine and reporting services and placing report server db as follows:
1.server\ins1 for sharepoint integration mode
Report server n report server tempdb will be placed in server\ins1 instead of placing them in actual production instance.
2.server\ins2 for native mode for 'K2'
Report server n report server tempdb will be placed in server\ins1 instead of placing them in actual production instance
The reason for going this approach is, in my opinion, if we place the report server database and report servertemodb in actual production instance it will decrease performance..plz correct me if Iam wrong.
And also how can we know what is the license method the organization has?
and do we need to pay for the license if we want to install the 2 database engine n reporting services in the 4th server?
and if we want to install only reporting services without database engine also need to pay for the license?
Thanks
Viewing 15 posts - 1 through 15 (of 16 total)
You must be logged in to reply to this topic. Login to reply