Microsoft Dynamics CRM 2016 - Installation & Deployment -

Microsoft Dynamics CRM 2016 – Installation & Deployment

Locus IT ServicesMicrosoft Dynamics CRM 2016 – Installation & Deployment

Lesson 4: Supporting Technologies

Supporting Technologies

Supporting Technologies : The following topics describe the required and optional technologies for a Microsoft Dynamics CRM implementation. Detailed hardware and software requirements for each technology are described in other modules.

Microsoft SQL Server

Microsoft Dynamics CRM uses Microsoft SQL Server 2008 (or a later version) to store the databases that contain data for a Microsoft Dynamics CRM deployment and each of the organizations in a deployment.You must install or have a supported installation of Microsoft SQL Server before installing Microsoft Dynamics CRM. The Microsoft Dynamics CRM Server Setup program does not install Microsoft SQL Server.

SQL Server Reporting Services

The default reporting solution in Microsoft Dynamics CRM is SQL Server Reporting Services.

Several reports are included in Microsoft Dynamics CRM, which are published to the SQL Server Reporting Services server during the installation of Microsoft Dynamics CRM.

Additional reports can be created using a variety of tools. Microsoft Dynamics CRM provides filtered views in the SQL database for all records types in the organization. The filtered views include a security check so that only records to which a user has access are returned when they are used in a query. The views also de-normalize Microsoft Dynamics CRM data to simplify querying. For more information on filtered views and report writing, refer to the Microsoft Dynamics CRM Software Development Kit (SDK). Any OLE DB (Object Linking and Embedding, Database) or ODBC (Open Database Connectivity) compliant third-party reporting tools can use the filtered views to generate reports.

The system does not support querying the tables in the organization database for reporting. You must install or have a supported installation of SQL Server Reporting Services before installing Microsoft Dynamics CRM. The Microsoft Dynamics CRM Server Setup program does not install SQL Server Reporting Services.

SQL Server Configurations

A number of Microsoft SQL Server configurations are possible depending on your expected usage of Microsoft Dynamics CRM:

  • Microsoft Dynamics CRM can be installed on a computer that is running Microsoft SQL Server or on a separate computer.
  • Microsoft SQL Server can be installed on multiple computers in a cluster configuration.
  • Microsoft SQL Server Reporting Services can be installed on the same Microsoft SQL Server computer that has the Microsoft Dynamics CRM databases or on a separate report server that is running Microsoft SQL Server.
Locus IT Project Management Office
What’s it?