We have SQL 2005 server with RS already installed and being used by an app (Noetix if it matters) and now we have another app that needs to use RS.
I ran into this before when my manager wanted Team Foundation Server installed and I found that even if I installed RS on another server and used a different database, it still clobbered the original reporting config on the SQL server.
I'm just a sysadmin and don't know what I'm talking about so be gentle. ;)
is there some way that we can have 2 different apps that need RS hosted on the same SQL server without them using the same RS instance (if that's the right term)?