Is it Possible to have two Different Reportserver Databases and Two Different Virual Directory for each Reportserver databases ?
Hi, Is it Possible to have two Different Reportserver Databases and Two Different Virual Directory for each Reportserver databases ? I have two Reportserver databases .i.e. Reportserver1 & Reportserver2 and i have created two Virtual DIrectories for the same Reportserver1 & Reportserver2 . However now thers s a problem , both my Virtual Directories point to the Last Reportserver Database that was created. Is it Possible to have Both my Reportserver Virtual Directoies locate different datsbase. Any other info needed let me know Any help would be great. Thanks
October 12th, 2010 8:38am
Hi Pritam_Shetty, If I understand correctly, you created two ReportServer Virtual Directoried manually, and you wanted each Virtual Directory to have each ReportServer database. By design, the connection to the ReportServer database is stored in the rsreportserver.config, and it is encrypted. That is why the two directories point to the same database. Additionally, creating two ReportServer instances manually is undocumented. It is not tested. If we do, there should have other issues might be found. I would suggest you installing a new ReportServer instance, and then use the Reporting Services Configuration Manager to fix the issue. For more information about how to install Reporting Services, please see: http://msdn.microsoft.com/en-us/library/bb522676.aspx If you have any more questions, please feel free to ask. Thanks, Jin ChenJin Chen - MSFT
October 13th, 2010 3:13pm
Hi Jin, Thanks for the Info. The solution is something what was initially in My Mind . But probably i cant create two seperate Instances for Reportserver, Clients Demand :)... Thanks Anyways.. Thought it would be Possible.. My Luck :(... Regards, PS
October 20th, 2010 10:56am