I need an installer that will install reporting services for SQL server 2008 or 2008 R2 and configure it.
First, it will need to check if reporting services are already installed, if it is not installed then it should install it. The normal situation where reporting services is not installed would be when a version of SQL Server 2008 R2 express edition is installed (without reporting services of course) and with an instance name called DEMSSQLEXPRESS. So basically, what needs to be done is upgrade this SQL Server to add the reporting service feature to the existing instance, which is DEMSSQLEXPRESS, or a new instance if it fails to add it to this instance (I’ve seen that happen to me before when I tried to add this feature to this instance manually). In case that Reporting services is already installed then there is a very good chance that the instance name is not DEMSSQLEXPRESS so I would like to provide the option to choose another instance.
Second thing that needs to be done is to configure the reporting services and to create a new report server database and point it to the existing DEMSSQLEXPRESS instance (or the user selected one).
The last thing to do is to create a new folder on the SQL Server Reporting Services web portal (which is basically the web page that you use to load\view the added reports) and to add a new data source and point that to the DEMSSQLEXPRESS instance (or the user selected one) and to a certain database, called DEMS by default, but I would like to give the user the option to choose another one (so maybe provide a drop down list of existing databases under this instance?).
I have already created a sort of step-by-step installation guide to manually perform the steps outlined above. The installer that I need would automate these steps so the user will start with step 7 in page 12 of that manual. I have added this manual to attached documents in this project. You will find the script mentioned in this manual in the attached documents as well.
Please Quote: “DEMS Reporting Service” so I know you are serious about this.
11 freelancers are bidding on average £109 for this job
DEMS Reporting Service We have an experienced team ready to begin this project. Rest assured your project will be completed by professional, qualified engineers, and delivered on time.