SystemService (Dynamics NAV Webservices)

In Microsoft Dynamics NAV the company name is part of the URL when you access published webservices. The ‘SystemService’ webservice allows you to retrieve the names of available companies. Even when you publish no webservices in Microsoft Dynamics NAV 2017 there is still this ‘builtin’ webservice that you can access. So let’s try it out!… Read More SystemService (Dynamics NAV Webservices)

Could not register the Service Principal Name (SPN)

Recently I checked my SQL Server Error Logs. Quite some interesting information in my opinion, however I also found this message: Date  25-7-2017 18:26:41 Log  SQL Server (Archive #3 – 25-7-2017 18:34:00) Source  Server Message The SQL Server Network Interface library could not register the Service Principal Name (SPN) [ MSSQLSvc/SQL01.contoso.lan:NAV ] for the SQL Server service. Windows… Read More Could not register the Service Principal Name (SPN)

ServerInstance Administration with PowerShell

In Microsoft Dynamics NAV 2017 there a  couple of Cmdlets to administer server instances: Get-NAVServerInstance New-NAVServerInstance Remove-NAVServerInstance Set-NAVServerInstance In order to run these Cmdlets we need to start ‘PowerShell ISE’ as an Administrator. Now import the NAV Administration module in order to use the NAV PowerShell Cmdlets. I will show you how to perform the… Read More ServerInstance Administration with PowerShell

Cumulative Update 3 for Microsoft Dynamics NAV 2017 has been released

Microsoft just released Cumulative Update 3. This update includes application and platform hotfixes that have been released for Microsoft Dynamics NAV 2017. This Microsoft Support page shows what has been fixed. You can download the update from KB 4011763 – Cumulative Update 3 for Microsoft Dynamics NAV 2017 (Build 15140) directly from Microsoft. Now you… Read More Cumulative Update 3 for Microsoft Dynamics NAV 2017 has been released

Company Administration in Powershell

In Microsoft Dynamics NAV 2017 there a currently five Cmdlets to administer companies: Copy-NAVCompany Get-NAVCompany New-NAVCompany Remove-NAVCompany Rename-NAVCompany In order to run these Cmdlets we need to start ‘PowerShell ISE’ as an Administrator. Now import the NAV Administration module in order to use the NAV PowerShell Cmdlets. I will show you how to perform the… Read More Company Administration in Powershell

Configuring Database Deadlock Detection and Monitoring

On NAV Techdays 2016 in Antwerpen (Belgium) Microsoft demonstrated a beautiful new feature. Microsoft Dynamics NAV 2017 now offers ‘Database Deadlock Detection and Monitoring’. If NAV 2017 detects a deadlock it will rollback one of the transactions. If you run the NST under a serviceaccount you need to apply some extra configuration to make this… Read More Configuring Database Deadlock Detection and Monitoring

Show OData webservice response directly in IE

As a Technical consultant I need to regularly install new NAV software for our customers. After installing I always try to check if web services are also working. In NAV 2017 I check at least three things: 1. Call the SOAP URL http://nav01:7047/NST2017-RTM/WS/CRONUS%20Nederland%20BV/Page/SalesOrder http://nav01.contoso.lan:7047/NST2017-RTM/WS/CRONUS%20Nederland%20BV/Page/SalesOrder First link contains the hostname. Second link contains the FQDN. Always… Read More Show OData webservice response directly in IE