SQL Server Performance

Report server consolidatation

Discussion in 'SQL Server Reporting Services' started by junsql, Mar 30, 2008.

  1. junsql New Member

    Hi,
    In my orgnization we have 3 sql server running report service. My plan is consolidate all the 3 servers into 1 server under 1 instance. I'm new in sql env. and would like to know if this is possible and if yes what are step to do that
    Thanx in advance
  2. melvinlusk Member

    Not quite sure if I fully understand what you're trying to accomplish here. If all you want to do is consolidate the data, you could just move the databases to one server, and just run reporting off of that. Is this your situation?
    Mel
  3. junsql New Member

    Yes, I nned to move all DB into 1 serevr. my confusion is that I don't know report service, is it unique for one instance. is it I need to intsll this service for each instance or 1 is enough.
  4. melvinlusk Member

    I think you should be able to get by with just one instance for reporting. Should be easy enough to try if you have a spare machine or VM.

Share This Page