NAV 2016 supports SQL Server Authentication

October 10, 2015     less than 1 minute read

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</font></p> 1. 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](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](https://msdn.microsoft.com/en-us/library/dn951464(v=nav.90).aspx#SetEncryptionKey)

[Configure SQL Authentication on the Database](https://msdn.microsoft.com/en-us/library/dn951464(v=nav.90).aspx#ConfigSQL)

[Configure SQL Server Authentication on Microsoft NAV Server Instance (Non-Multitenant)](https://msdn.microsoft.com/en-us/library/dn951464(v=nav.90).aspx#ConfigNavServer) or [Configure SQL Server Authentication on Microsoft NAV Server Instance in a Multitenant Deployment](https://msdn.microsoft.com/en-us/library/dn951464(v=nav.90).aspx#ConfigNavServerMT)

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](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..