Basic SQL – How to create a new NAV database for restoring a NAV backup

This post is part of “Overview of NAV-specific SQL features for application consultants”.    This post describes the steps needed to create a new NAV database from a NAV backup (.fbk) file. All the steps are done from a NAV client: 1)     Start a NAV client (finsql.exe), then go to File -> Database -> New….

2

Basic SQL – Enable trace flag 4616 on SQL Server

This post is part of “Overview of NAV-specific SQL features for application consultants”.   The newest versions of Microsoft Dynamics NAV require trace flag 4616 to be enabled on SQL Server. If not, then you will get this error message when you try to connect: === The trace flag 4616 is not set on the…

2

Basic SQL – Creating Extended Stored Procedure / xp_ndo.dll

This post is part of “Overview of NAV-specific SQL features for application consultants”.    Microsoft Dynamics NAV requires two extended stored procedures from xp_ndo.dll to exist on SQL Server if Windows logins are used. If these extended stored procedures do not exist, you will get this error when trying to log on using Windows Authentication:…

0

Basic SQL – Installing SQL Server 2005 / 2008

This post is part of “Overview of NAV-specific SQL features for application consultants”. It describes the simplest way to get SQL Server installed in a test environment. It only mentions the changes to the default installation options that you need to make to get SQL Server running for NAV. Needless to say that for installing…

0

Basic SQL – Overview of NAV specific SQL features for application consultants

As the title says, this post is not really for NAV developers, but for application consultants who don’t use SQL Server every day but still need to know enough about SQL Server to at least get a Microsoft Dynamics NAV database to run on it. The challenge is, that even a basic SQL course or book will…

0

Tip 2: Fixing language issues when trying to setup the Outlook Synchronization in Dynamics NAV 5.0, Dynamics NAV 5.0 SP1 and Dynamics NAV 2009

If you are working in a localized release of Dynamics NAV with the redesigned Outlook Synchronization, I bet that you were dealing with a language issue. Perhaps you forgot to set the Regional Options for the NAS user account, perhaps you did not follow the Localization Tips of the Installation & Setup Whitepaper. Who does…

0

Tip 1: The related item for the synchronized Outlook item is not found in the specified folders. The following values were expected

When working with the Outlook Synchronization using Dynamics NAV 5.0, Dynamics NAV 5.0 SP1 and Dynamics NAV 2009 (present release: CTP4) in an Exchange Server environment, the following very annoying error may show up in the Outlook Addin. The related item for the synchronized Outlook item is not found in the specified folders. The following…

0

3D charts. Chart Generator tool II

One of the new features in NAV 2009 is the new chart (KPI) object, described in more details here: NAV 2009 – How to generate charts / KPIs This post describes how to make 3D rotatable charts, and includes an update to the Chart Generator Tool which makes is simple to make your own 3D…

1

Error – Cannot create more than one clustered index on table

This post describes one scenario in which this error occurs. There may be others. In the late 4.0 versions of the NAV executables, all tables in NAV had a clustered index created on SQL for the primary key (Index 0).However, the table objects in 4.0 versions did not have the Clustered property set on any…

0

RIM Tool on 5.0 SP1

Although the RIM tool was originally designed to assist in the setup of Master data; i.e. Customers, Vendors, Items, etc., the reality is that many are using the Data Migration tool to bring in journal lines to set up beginning balances and to bring over historical data from legacy applications. With the release of 5.0 SP1,…

0