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” AdvertisementsRead More Adding Windows User to Microsoft Dynamics NAV using Powershell
Open Dynamics NAV Administration Powershell type the fallowing company to change the name of the nav company Rename-NAVCompany -ServerInstance DynamicsNAV100 -CompanyName “CRONUS UK Ltd.” -NewCompanyName MyCompanyRead More Renaming Dynamics NAV company using Powershell
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.
Solution developers will often have different versions of Dynamics NAV installed on a single machine for their development environment. The way this is often implemented is to fully install the latest version and simply copy the Classic Client binary files for earlier versions into separate folders so you have something like this: NAV 2009 R2 […]Read More It is not possible to instantiate the Visual Studio Bridge
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
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
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