When you try to open Microsoft Dynamics NAV Web client or Microsoft Dynamics NAV SharePoint client, you get the following error:
A fatal error occurred. The connection to SQL server cannot be established or is no longer usable.
There can be various causes of this error. The most common causes are that Microsoft Dynamics NAV Server has stopped or the connection to SQL Server is not configured correctly.
Resolution
This error occurs when Microsoft Dynamics NAV Server cannot connect to SQL Server or to the Microsoft Dynamics NAV database. To resolve this error, verify that the following conditions are met.
- Microsoft Dynamics NAV Server connects to the
correct database by using the correct login account.
You can do this by using the Microsoft Dynamics NAV Server Administration tool. For more information, see Microsoft Dynamics NAV Server Administration Tool. - Login account has the following
permissions:
- Permission to log on as a service on the
computer that is running SQL Server. For more information, see
Provisioning the
Microsoft Dynamics NAV Server Account.
- Set up as a user in the Microsoft Dynamics
NAV database on SQL Server with the following role memberships:
db_datareader, db_datawriter, and db_ddladmin. For more
information, see Setting
Database Owner and Security Administration Permissions
- Permission to log on as a service on the
computer that is running SQL Server. For more information, see
Provisioning the
Microsoft Dynamics NAV Server Account.
- SQL Server has the following
configurations:
- TCP/IP protocol is enabled.
- SQL Server executable file is allowed through
the Windows Firewall.
- SQL Server Browser Service is running. This
is required only when Microsoft Dynamics NAV used a named database
instance, such as NAVDEMO, and Microsoft Dynamics NAV Server is on
a different computer than SQL Server. For more information, see
How to: Start SQL Browser
Service.
- TCP/IP protocol is enabled.
See Also
Tasks
How to: Install the Web Server Components for the Microsoft Dynamics NAV Web ClientWalkthrough: Installing the Microsoft Dynamics NAV Web Client Tiers on Three Computers
How to: Install Microsoft Dynamics NAV Portal Framework
Concepts
Deploying the Microsoft Dynamics NAV Web ClientTroubleshooting the Microsoft Dynamics NAV Web Client Installation
Deploying Microsoft Dynamics NAV Portal Framework