This topic describes the requirements for installing and configuring Microsoft SQL Server to work with Microsoft Dynamics NAV 2009.
SQL Server Components to Install
Microsoft Dynamics NAV 2009 is compatible with SQL Server 2005 and SQL Server 2008.
SQL Server 2005 Components
If you are installing SQL Server 2005 to use with Microsoft Dynamics NAV, then install the following components:
SQL Server Database Services
Workstation components, Books Online, and development tools
After you install SQL Server 2005, you must also install Service Pack 2.
SQL Server 2008 Components
If you are installing SQL Server 2008 to use with Microsoft Dynamics NAV, then install the following components:
Database Engine Services
Client Tools Connectivity
Management Tools - Complete
Setup Options for Microsoft SQL Server
When you are running Microsoft SQL Server Setup, you must provide additional information. Your responses can affect how you use SQL Server with Microsoft Dynamics NAV 2009.
Use the default instance and Instance ID on the Instance Configuration page when you install SQL Server. If you are using a non-default instance, then you must specify the instance when you install Microsoft Dynamics NAV Database Components. See.
We recommend that you use a dedicated domain user account that you create specifically for the SQL Server service (MSSQLSVC) instead of a Local System account or the Network Service account.
For more information on service security, see the Microsoft Dynamics NAV 2009 Security Hardening Guide.
Data Encryption Between Microsoft Dynamics NAV 2009 Server and SQL Server
When SQL Server and Microsoft Dynamics NAV Server are running on different computers, you can make this data channel more secure by encrypting the connection. For information on how to do this, see the topic “Encrypting Connections to SQL Server,” which is part of SQL Server 2008 Books Online on the MSDN library. You can link to the SQL Server 2005 version here and the SQL Server 2008 version here.