View Server State Permissions Issue with Microsoft Dynamics NAV (Navision)
You cannot start Microsoft Dynamics because you do not have the VIEW SERVER STATE permission on SQL Server.
Starting with Dynamics NAV 4.0 SP3, NAV required the SQL Server trace flag 4616 to be active (turned on). This trace flag was required as SQL server 2005 introduced increased security protection for database metadata, which means that visibility is restricted by default for users so that they can no longer see connection details for other logins unless the user is granted VIEW SERVER STATE permissions.
With the release on NAV 5.0 SP1 Update 2, trace flag 4616 is no longer required, as the VIEW SERVER STATE permission enables visibility to the required connection information for each user.
Issues may occur during NAV installation, or setup of new users where the specific user is not granted the VIEW SERVER STATE permission. To resolve this issue:
1. Go to Microsoft SQL Server Management Studio
2. Go to server properties (Right click > Properties)
3. Find the user under Logins or Roles
4. Under Permissions, find the View server state permission and flag GRANT
This should resolve connectivity issues and allow the user to access NAV.
Written by: Mark Stept