I have SQL SERVER 2008 in my server. I want to find the script which create my ReportingServer and ReportingServerTemp databases.Where can i find it. Thanks for Advance...

Hi Berkehan, When you install SQL server it will automatically install ReportserverDb and ReportServerTempDb in your Default\Named instance of your SQL Server. If you want to have just the Script of your Reportserver it can be obtained by right click ScriptDatabase-->Createto-->New Query File. Is this what you are looking for? if you need a reportserver Db ,Report Server temp Db template Script you can install the Same SQL server edition on your local machine and crete the script as stated above. I am not sure you can get the Reportserver,ReportserverTempDb scripts online.Rakesh M J Dont forget to mark it as Answered if found useful MCTS,MCITP,MCSS http://mycubeandreports.blogspot.com/

Hi Berkehan, Thanks for your question and Rakesh’s reply. According to your description, another understanding is you would like to find a sample script to help you creating the ReportingServer and ReportingServerTemp databases, right? If I misunderstand your question, please don't hesitate to let me know. Actually, as Rakesh said, if you checked Reporting Services when you installed the SQL Server 2008, the ReportingServer and ReportingServerTemp databases had been installed in the instance of SQL Server, you just need to configure it by the Reporting Services Configuration Manager. For detail steps, please follow below, 1. Click Start, select All Programs, Microsoft SQL Server 2008, Configuration Tools, and finally Reporting Services Configuration Manager. 2. If you installed Reporting Services as the default instance on your local computer, in the Reporting Services Configuration Connection dialog box, click Connect. Otherwise, change the Server Name and the Report Server instance to the application server and instance, and then click Connect. 3. In the Reporting Services Configuration Tools dialog box, click Database in the left pane, the Current Report Server Database information being displayed on the window. You can click Change Database button to change the Database. Hope it helps you, if your issue still exists, please feel free to let me know. Thanks, Sharp Wang Please remember to mark the replies as answers if they help you and unmark them if they provide no help.

Hi Sharp This is what i exactly looking for thanks for your response. I solve my problem. And Rakesh thanx to you as well.