You’re offline. This is a read only version of the page.
4
Is it possible to install the Data Connector on a server that has SSRS but with SQL on a different server.
A bit of back ground. V9 will run in SQL 2019. SQL 2019 has SSRS as a separate install and it can be installed on a different server that SQL.
What I'm try to accomplish is moving to an On Premise install in a cloud environment.
I am too heavily modified to use the Cloud version of CRM so that is simply not an option.
I'm thinking Azure with the SQL server in their environment and a Azure server to run my custom code.
Thanks in Advance for any replies.
Hi BBuchanan.
Yes, you can and I would say it's also the preferred way if you e.g. intend on setting up multiple CRM Server installations and host each of them on SQL Named Instances on the same SQL Server.
This scenario, even thou I would say that it's not that common would fail as you can only have one SSRS Connector installed and connected to a one SQL instance, not multiple.
Also, it's not always the same persons managing CRM as the SQL and they aren't usually that keen on installing software on the SQL servers e.g. like the Dynamics CRM SSRS connector.
I can't recall a single installation of the ones I managing/setup that we run Reporting Services on the same machine as the SQL Server, but ofc we host the RS databases on it.
Hope this helps
/Philip
#1
Daniyal Khaleel
141
#2
DAnny3211
134
#3
Abhilash Warrier
70
Super User 2025 Season 2
Share
Report
All responses (
Answers (
