Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Lohndorf   (RSS)
Thursday, November 05, 2009 8:12 AM

Duplicate SPNs in a 3-tier setup and how to locate them

One of the problems when troubleshooting why a 3-tier setup of NAV 2009 doesn't work is, that the same error - typically this one on the SQL Server: "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'" can be caused by any number of problems between
Posted by Lohndorf | 0 Comments
Filed under: ,
Monday, October 26, 2009 12:45 PM

Doing upgrades to NAV 2009 SP1

When doing an upgrade - even when not touching the database and application objects - to NAV 2009 SP1, remember to also compile all objects for the new version of executables. Compiling all objects must be done when doing an update from NAV2009 RTM (No
Posted by Lohndorf | 1 Comments
Filed under: , ,
Tuesday, October 20, 2009 1:17 PM

Creating a web service manually, the importance of the name you give it, and a few small things to remember

When you use the SC command line command to create a new NAV 2009 Service, how does the new service know whether it is a middle tier for RTC to connect to, or whether it is supposed to handle web service calls? In other words, what decides whether the
Posted by Lohndorf | 1 Comments
Friday, September 18, 2009 3:14 PM

How using SQLIndex property can affect which index NAV uses

The usual rule for specifying a key in NAV is, that it will chose the first key that matches all the fields specified by SETCURRENTKEY, RunformLink, etc. Example: Table 21 "Cust. Ledger Entry" has the following keys (not all of them listed): - Entry No.
Posted by navblog | 1 Comments
Filed under: ,
Tuesday, August 25, 2009 3:09 PM

Table Information including Index information (Usage, Blocks and Reads)

== Nov 9 update == In some cases we got integer overflow when running this query. So the table definitions in the query have now changed from using int to bigint to avoid this. == end of update == The query below combines these three queries into one:
Posted by navblog | 0 Comments
Filed under: , ,
Thursday, July 16, 2009 2:34 PM

Index Usage Information Tool

Attached at the end of this post is a set of NAV objects that collects index usage information, and displays it in a NAV client so that you can sort tables by no. of Indexes / Index Reads / (Index) Block wait time, etc.: The tool is using these three
Posted by navblog | 0 Comments
Filed under: ,

Attachment(s): iuit.fob
Tuesday, July 07, 2009 2:28 PM

How to read a SQL Profiler trace file into a SQL table

Just a small tip that I use often when I have a large SQL Profiler trace. Rather than reading through trace files line by line, you can read it into a table and then query it. This syntax creates a new table in SQL Server and loads your trace file into
Posted by navblog | 0 Comments
Filed under: ,
Wednesday, July 01, 2009 2:23 PM

Where is the zup file again?

I keep forgetting where the CustomSettings.config, ClientUserSettings.Config etc files are. So I keep looking it up again in "Where is the zup file" . This time, I collected the location of these files in a NAV form so I don't have to look them up anymore.
Posted by navblog | 0 Comments
Filed under: ,

Attachment(s): zup.fob
Monday, June 15, 2009 2:14 PM

What do SPNs actually do - NAV 2009

Three terms keep coming up when setting up NAV 2009 when NAV-server (middle tier) runs on a different machine than SQL Server: - Delegation / Impersonation - Kerberos - SPN Delegation / Impersonation is what it says it is. Kerberos is handled more or
Posted by navblog | 0 Comments
Filed under: , ,
Friday, June 12, 2009 2:07 PM

Setting up NAV 2009 on Three machines

Setting up delegation and SPNs for NAV 2009 on three machines (when the NAV Server and SQL Server are on two seperate machines) is described in "Walkthrough: Installing the Three Tiers on Three Computers" . But in addition to this, also be aware of the
Posted by navblog | 0 Comments
Filed under: ,
Thursday, June 04, 2009 2:05 PM

SQL Query to show tables, their indexes and index usage

The SQL query below shows a list of tables sorted by the largest tables first. For each table, the indexes in the table are shown. For each index it shows when the index was last used. The query is designed to collect various pieces of information in
Posted by navblog | 0 Comments
Filed under: ,
Tuesday, May 19, 2009 2:02 PM

How to use WCF Performance Counters with NAV 2009 Server

NAV Server (middle tier) utilises Windows Communication Foundations (WCF), which includes a number of performance counters that you can use to monitor NAV Server performance in real-time. This example shows how to monitor "Calls Per Second" for NAV Server
Posted by navblog | 0 Comments
Filed under: ,
Friday, May 08, 2009 1:32 PM

Running an older databases in NAV 2009 runtime

It's quite normal to upgrade the runtime (executables) to newer versions while leaving the database (application) as it is. This will enable the new runtime features such as Web Services. Recently we have seen a number of questions about whether you can
Posted by navblog | 0 Comments
Filed under: ,
Wednesday, April 22, 2009 1:23 PM

Dynamics NAV, customizing style sheets for export to MS Excel

A while a go we posted a blog decribing how to make some basic customizations to style sheets used for export to Excel. http://blogs.msdn.com/nav/archive/2009/02/18/customizing-style-sheets-for-ms-excel.aspx This is an update to that blog. You can download
Posted by navblog | 0 Comments
Attachment(s): xlt.fob
Thursday, March 12, 2009 1:18 PM

The physical location of .net components

The virtual table 2000000046 "Automation Server" shows you the physical location of the automation servers (.dll file). But a .net component is not an automation server, so is not listed here. One of the main benefits of .net is exactly to be able to
Posted by navblog | 0 Comments
Filed under: ,
More Posts Next page »
 
Page view tracker