tag:blogger.com,1999:blog-28669706.post7480895511435586142..comments2024-03-25T08:33:57.056+01:00Comments on Gustaf's Microsoft Dynamics CRM Blog: How to get the URL to the reportserver programmaticallyGustaf Westerlundhttp://www.blogger.com/profile/02522937600083440624noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-28669706.post-72417784879000683122008-11-06T10:35:00.000+01:002008-11-06T10:35:00.000+01:00Neither of these solutions are supported and it wo...Neither of these solutions are supported and it would be very nice if there was a supported way of getting the reporting services url.<BR/><BR/>According to a colleague of mine who works with installations and configurations it is not supported (yet anyway) to have one CRM installation with multiple SSRS servers where the different tenants use different servers. That doesn't mean that it cannot be done, just that it isn't supported at the moment. He believes that it might be supported in future servicepacks of SQL-Server or Dyn CRM.<BR/><BR/>Any more input on the subject is greatly appreciated.Gustaf Westerlundhttps://www.blogger.com/profile/02522937600083440624noreply@blogger.comtag:blogger.com,1999:blog-28669706.post-16879431132806723492008-11-06T10:07:00.000+01:002008-11-06T10:07:00.000+01:00Hi,Right you are. Thanks for the input.However, I'...Hi,<BR/>Right you are. Thanks for the input.<BR/><BR/>However, I'd like to avoid the management of connection strings to databases (since that will complicate deployment) which of course is possible by reading the value:<BR/>"configdb" from the MSCRM key in the registry aswell.<BR/><BR/>If you can decide on a strict setup of one multitenant CRM server and only one SSRS then you could probably manage generating the path using the org-name from the discovery service and the value "SQLRSServerURL" in the registry.<BR/><BR/>I think consideration also has to be made if the solution is to be offline available. Any inputs on that topic Shai?Gustaf Westerlundhttps://www.blogger.com/profile/02522937600083440624noreply@blogger.comtag:blogger.com,1999:blog-28669706.post-13936612497190631292008-11-06T07:57:00.000+01:002008-11-06T07:57:00.000+01:00Your solution will not work in multi tenet environ...Your solution will not work in multi tenet environment.<BR/>You need to read from MSCRM_CONFIG , from the organization table the organization record and get the info from SRSURL column.Shaihttps://www.blogger.com/profile/17635349408782053835noreply@blogger.com