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.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Reporting Services

Author  Topic 

dbalearner
Constraint Violating Yak Guru

272 Posts

Posted - 2014-12-02 : 21:49:37

The Current SQL Server is 2008 R 2 Version is already possesing with 3 Database Engine based SQL Instances and 1 SSIS are residing on the server.

However to install a REPORTING SERVICES on this server will there be any problem?

Is REPORTING SERVICES needs Installation done while Server is up & Running?

Is it just run the SOFTWARE CD to install?

Please suggest.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-12-03 : 12:35:19
If it were me, I would not install it. I don't mix database engines with SSIS or SSRS. I rarely would even recommend multiple instances. I'm of the opinion that you should have 5 different servers for what you described above. But I don't pay for your hardware or licenses...

I haven't installed SSRS in a while, but I don't believe it needed a reboot last time I installed it.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

dbalearner
Constraint Violating Yak Guru

272 Posts

Posted - 2014-12-04 : 18:50:47
Thanks Tkizer.

However, as you say dont pay for Hardware and Licenses is the motto of my company(Stinzy)

However, Could you please give some tips

Current Server is SQL Server 2008 R2 Version;

It has god 4 Instances for the SSMS (Including 2005 Instance as well)

Now going to have 5th Instance (2008 R 2) SSMS is going to be installed and also REPORTING SERVICES.

Now this 5th Instance would be pointed from REPORTING SERVICES.

My question is what sort of problems that might arise?


As you have mentioned "not required REBOOT' on Reporting Services being installed - is this Right Please clarify.

Thanks
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-12-04 : 19:17:40
What sorts of problems with all of these instances? Performance.

I can't clarify the SSRS install if it requires a reboot or not. I am going by my memory. You will need to research it or test it out on another server.



Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -