I have SQL 2008 R2 standard installed on Windows 2008 R2 server.
I do need to install SSRS . When I add SSRS it shoes me Web Addition is installed. getting S . I’ve downloaded fresh ISO of SQL 2008 R2 standard not WEB and removed SSRS and run 2008 R2 setup and when install SSRS still indicate that it is Web addion.
How can I install SSRS standard instead of WEB without destroying my SQL server instance as I have few important DB running.
I would appreciate the answer from someone who has experience with this type of problem without wild guessing.