Our workplace plans to use SSRS 2008 (Not R2) and Visual Studio to develop online reporting for public access. We have never done this before so the question may be easy for you all: our database will be on the SQL server, Visual Studio will be installed on our desktop for development purposes, what about web server setup? If it's a separate server, do we need to have .Net framework installed on it to make everything work? And what will be the costs for that piece? (we already got the quote for Visual Studio on our desktop.) Thank you very much!

Hi Sharp, Thank you for your reply. It's good to know that we don't need to purchase anything else on the web server side. Both our data and report are simple and the viewer will be public. Can you tell me whether we shall place everything on one server, or one for database and the other for web server? If the second case, do we need SQL server license on both server? I assume only one for database server is suffcient, based on your previous answer? Thank you for your patience!

Hi Learning101, Thanks for your question, I will separately answer your questions. 1. What about web server setup? SSRS 2008 is one of the features included in SQL Server 2008 and is included in all editions of the software expect SQL Server 2008 Express and SQL Server Compact. It means that if you checked it when you installed SQL Server2008, after successfully installed it, you can use it. Then, you should use Reporting Service Configuration Manger to configure the report server, you can direct to it by these steps: Click Start, select All Programs, Microsoft SQL Server 2008, Configuration Tools, and finally Reporting Service Configuration Manger. By default, after the previous steps, you can visit the Report Manager by typing in browser with URL: http://ReportServerName/reports, visit the Report Server by typing in browser with URL: http://ReportServerName/reportserver. 2. Do we need to have .Net framework installed on it to make everything work? From SSRS 2008, one of the features is eliminated Internet Information Services, generaly speaking, you have not to install .Net framework to make the SSRS work. 3. What will be the costs for that piece? As Dan said in your last thread, Visual Studio 2010 does not currently support BI project types so you'll need either Visual Studio 2008 or SQL Server 2008 BIDS for SSRS 2008 report development. BIDS is also one of the features included in SQL Server 2008, so you should pay for SQL Server2008 and Visual Studio 2010. Hope it helps you, if your issue still exists, please feel free to let me know. Thanks, Sharp Wang Best Regards. Sharp Wang