I am new to Reporting Services, so this may be a simple question. I want to try and download the evaluation copy of Microsoft's RS from their website, however, they require you to have a SQL Server db setup. I have one, but it is remote. I do all my development in Visual Studio on Server A and have my db setup on Server B. I want to be able to use RS within Visual Studio, so I am assuming I need to install RS on Server A. Or do I need to just install on Server B with the database (or both)?
Thanks for your help...
MS SQL Reporting Services is just an ASP.NET web application. You can install it on IIS servers that have .NET 1.1. You do not have to install it on the DB server. The MS SQL reporting services application stores its catalog in the db and thus you need to have a SQL server when installing it. The MS SQL reporting services installation has two components: the server component (to be installed on the web server) and the developer component (to be installed on developer workstation that has the Visual Studio). Using Visual Studio, you can build reports and then publish tem to the web server where you installed the MS SQL Reporting Services server component. In your case, you can install both components on Server A.
Hope this helps
No comments:
Post a Comment