NAV 2016 supports SQL Server Authentication

There are lot of exciting features added to Navision 2016, and one of the feature  they added is support to the SQL Server Authentication, in previous versions we can access Navision using the below four credential types

• Windows
• UserName
• NavUserPassword
• AccessControlService

To learn more about these credential types please refer to the following link

https://msdn.microsoft.com/en-us/library/hh169371%28v=nav.80%29.aspx?f=255&MSPPError=-2147217396

Microsoft Dynamics NAV 2016 supports SQL Server authentication between the Microsoft Dynamics NAV Server instance and the Microsoft Dynamics NAV database in SQL Server. Previously only Windows authentication was supported, but to configure this we need to do the following procedures

1. Set Up an Encryption Key
2. Configure SQL Authentication on the Database
3. Configure SQL Server Authentication on Microsoft NAV Server Instance (Non-Multitenant) or Configure SQL Server Authentication on Microsoft NAV Server Instance in a Multitenant Deployment

All the details about the above procedures can be found at the below link

https://msdn.microsoft.com/en-us/library/dn951464(v=nav.90).aspx

Please leave your comments, feedback or any suggestions you have for me to improve me my blog and also if you have any questions, feel free to post..

Share: