SQL Server installation and configuration
To plan your use of Microsoft SQL Server with Microsoft Dynamics CRM, you must understand how Microsoft Dynamics CRM uses SQL Server, and what Microsoft Dynamics CRM Server Setup does and does not do:
Microsoft Dynamics CRM requires SQL Server 64-bit versions for storing the databases that contain Microsoft Dynamics CRM data and metadata. For specific details, see SQL Server editions in this guide.
Reports in Microsoft Dynamics CRM depend on Microsoft SQL Server Reporting Services, a feature in SQL Server. Reporting Services includes two server components that are used to store, display, and manage reports: Report Server and Report Manager. A third component, Report Designer, is used to customize reports and write new reports. The Report Designer component is available with Microsoft Visual Studio and is typically installed on a workstation, instead of on the computer that is running SQL Server.
Microsoft Dynamics CRM Server Setup does not install SQL Server or Microsoft SQL Server Reporting Services.
There are many configurations possible based on your expected usage of Microsoft Dynamics CRM. For information about the licensing implications when you install Microsoft SQL Server Reporting Services on a separate computer, see SQL Server 2008 R2 Licensing.
Although we do not recommend it, you can install SQL Server on the same computer as Microsoft Dynamics CRM Server 2011. For better performance, install and run SQL Server on a separate dedicated computer. For better performance and improved availability, install and run SQL Server on separate multiple dedicated computers in a clustered configuration.
You can install Microsoft SQL Server Reporting Services on the computer that stores the Microsoft Dynamics CRM databases, or on a separate report server that is running SQL Server.
Multiple Microsoft Dynamics CRM front-end servers that run in a network load balancing cluster can use the same computer that is running SQL Server.
The following information describes:
SQL Server requirements common to most scenarios.
Considerations about how to use one computer that is running SQL Server with multiple computers that are running Microsoft Dynamics CRM Server 2011.
For more information about SQL Server, see Additional resources for SQL Server in this guide.
Send comments about this article to Microsoft.
© 2012 Microsoft Corporation. All rights reserved.