Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Lewis Rosenberg]

Has anyone turned this setting on for their NAV instance?   I was asked to see what the result would be and once I turned it on (for our test system), I could no longer connect my client.  Each time I tried, the server instance stopped running.

——————————
Lewis Rosenberg
IT Manager
Mars Fishcare
Chalfont PA

NAVUG Board of Advisors, Programming
NAVUG Programming Committee
NAVUG Membership Committee
——————————

[Ian Ray]

You will need to install the encryption key from the NAV Powershell cmdlet, e.g. New-NAVEncryptionKey  -KeyPath “C:UserDataSQLKeyMySQLKey” -Password (Get-Credential).Password

Full instructions
Configuring SQL Server Authentication in Microsoft Dynamics NAV 2016 – Part-1

——————————
Ian Ray
Cypress Grove
Arcata CA
——————————
——————————————-

[Mark Miranda]

Hi Lewis,

You should not need an encryption key to encrypt the connection, but you do need to have SSL enabled on the protocols for the server in the SQL Configuration Manager.

https://technet.microsoft.com/en-us/library/ms189067(v=sql.105).aspx

Once enabled, you can test this with SQL Server Management Studio to see if it’s working before you attempt to have NAV connect to it.  On the Connect to Server window when SSMS starts up, click on Options, and then on the Connection Properties tab, check the “Encrypt Connection” box.

——————————
Mark Miranda
Director of Information Technology
Western Computer
——————————
——————————————-