January 28, 2009 at 11:03 am
Hi,
We have a separate reporting server, when installed reporting services, I had choose install but do not configure, so we do not have a report server database created.
Now the development team wants deploy their rdl files into this reporting server.
Inorder to deploy rdl files what I need to do? do I need to create a report serverdb and reportservertempdb prior to this rdl deployment?
How actually it works?
January 28, 2009 at 1:38 pm
There is no valid reason for your assumptions because you can give your developers the developer edition and ask the developers to just upload ready for deployment code to your server.
So you need to rerun setup and install and configure SSRS so your developers can copy their reports RDL and solutions to your reports manager so you can run the reports. The reason when reports are executed the SQL Server relational engine stores the RDL files in the ReportserverDB catalog table.
That is the reason when you move reporting services from one server to the other if you did not configure it right SQL Server will tell you the relational engine does not know about you new ReportServerDB and TempReportServerDB.
Kind regards,
Gift Peddie
January 28, 2009 at 1:53 pm
That means, I need create the report server database using report server configuration manager before the developers deploy their rdl files into report server right?
correct me If I understand wrong?
January 28, 2009 at 1:57 pm
I think you need more than that so rerun setup so you can be sure you have added all you need to run the rdl and solution files.
Kind regards,
Gift Peddie
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply