May 16, 2016 at 9:37 am
I would like to ask other DBA, if you have two servers, one for DB server, the other for Reporting server, how do you usually install?
What I do is:
1. install DB engine and SSIS one Server 1, the DB engine hosts all application related databases.
2. On Server 2 which is reporting server, I install DB engine and reporting services. The DB engine on this server only hosts databases of reportServer and ReportServerTempdb.
of course both servers hosts system db as well.
3. My question is on server2, is it a third method to install only SSRS service on server 2 no db engine, and put reporting dbs on Server 1, I never did this option before, is it better or not than no.2?
Thanks
May 17, 2016 at 7:34 am
sqlfriends (5/16/2016)
3. My question is on server2, is it a third method to install only SSRS service on server 2 no db engine, and put reporting dbs on Server 1
yes this is a valid configuration
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply