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

NoteNote

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.

Instances

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 Configuring Database Components.

Server Configuration

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.

NoteNote

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.

See Also