I am looking to introduce reporting services on a small scale to the company I work at. This is a large undertaking on my part in an effort to further my knowledge in SSIS, SSAS and SSRS. So far I have a large SSIS job that I developed with some help that inports 47 tables from an access connected database to SQL Server on a nightly basis. Now that I have completed that, I am ready to move on to the next step. To me this would be setting up the web server that the company would access reports on. After this is set up, I want to develop reports and this will entail using SSAS but I will get to that point later on. right now I have been trying to look for a walkthrough to get the web service and GUI for SSRS up and running without success. IT seems the deeper I get into this, the less people are around in this field(or just highly in demand).
Thanks in advance to all who can help. Thanks
Please refer to the following articles:
Report Server Web Service: http://technet.microsoft.com/en-us/library/ms152787.aspx
Report Server Web Service Methods: http://technet.microsoft.com/en-us/library/ms155071.aspx
TechNet Community Support
To me this would be setting up the web server that the company would access reports on
Which version of SSRS are you going to use? If its 2008 or higher, then you don't need a "web server" = IIS, because SSRS uses it's own HTTP.SYS to host the web gui "Report Manager" and the SSRS web service (SOAP).
Olaf HelperBlog Xing