Adding Windows User to Microsoft Dynamics NAV using Powershell

1. Open Powershell as Administrator. 2. Import Navision Cmdlet, if you are using the Powershell ISE import-module “C:\Program Files\Microsoft Dynamics NAV\100\Service\NavAdminTool.ps1” 3.New-NAVServerUser -ServerInstance <<NAV Server Name>> -WindowsAccount <<Domain\UserName>> -LicenseType Full -State Enabled 4.New-NAVServerUserPermissionSet -PermissionSetId SUPER -ServerInstance <<NAV Server Name>> -WindowsAccount “Domain\UserName” Advertisements

Read More Adding Windows User to Microsoft Dynamics NAV using Powershell

Metadata for object of type Table with id 20000000xx is in a failed state. This is caused by a previous exception: Object of type Table with id 20000000xx could not be found.

Hi all, Metadata for object of type Table with id 2000000073 is in a failed state. This is caused by a previous exception: The specified path is invalid. Metadata for object of type Table with id 20000000xx is in a failed state. This is caused by a previous exception: Object of type Table with id […]

Read More Metadata for object of type Table with id 20000000xx is in a failed state. This is caused by a previous exception: Object of type Table with id 20000000xx could not be found.

SQL SERVER – Find Most Expensive Queries

Some times using wrong keys while coding will result in the performance ,to find out such expensive queries in sql SELECT TOP 10 SUBSTRING(qt.TEXT, (qs.statement_start_offset/2)+1, ((CASE qs.statement_end_offset WHEN –1 THEN DATALENGTH(qt.TEXT) ELSE qs.statement_end_offset END – qs.statement_start_offset)/2)+1), qs.execution_count, qs.total_logical_reads, qs.last_logical_reads, qs.total_logical_writes, qs.last_logical_writes, qs.total_worker_time, qs.last_worker_time, qs.total_elapsed_time/1000000 total_elapsed_time_in_S, qs.last_elapsed_time/1000000 last_elapsed_time_in_S, qs.last_execution_time, qp.query_plan FROM sys.dm_exec_query_stats qs CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) qt CROSS APPLY sys.dm_exec_query_plan(qs.plan_handle) qp ORDER BY qs.total_logical_reads DESC — logical reads — ORDER BY qs.total_logical_writes DESC — logical writes — ORDER BY qs.total_worker_time DESC — CPU time You can change the ORDER BY clause to order this table with different parameters. I […]

Read More SQL SERVER – Find Most Expensive Queries

Upgrade Toolkit for Upgrading Data from Microsoft Dynamics NAV 2009 R2 or SP1 to Microsoft Dynamics NAV 2015

The cumulative update 1 of NAV2015 includes an upgrade toolkit for upgrading a Microsoft Dynamics NAV 2009 R2 or Microsoft Dynamics NAV 2009 SP1 database to Microsoft Dynamics NAV 2015. The upgrade toolkit includes several application objects in FOB files that simplify the upgrade process for those of you coming from Microsoft Dynamics NAV 2009 […]

Read More Upgrade Toolkit for Upgrading Data from Microsoft Dynamics NAV 2009 R2 or SP1 to Microsoft Dynamics NAV 2015

How to get Microsoft Dynamics NAV for tablets to connect using a self-signed certificate

Overview This blog post helps you connect Microsoft Dynamics NAV for tablets using a self-signed certificate. The targets for the blog post are the following apps: Dynamics NAV for iPad Dynamics NAV for Android Dynamics NAV for modern Windows The Internet Information Services Manager (IIS) needs a trusted certificate that holds the private key for […]

Read More How to get Microsoft Dynamics NAV for tablets to connect using a self-signed certificate