What SQL permissions do you need to upload a Dynamics NAV license file?

Whenever you get a new license file from your partner, in order to activate the new license file, you need to upload the license file to your server. However, sometimes, you may get an error when uploading the license file. So far, I have seen two error messages, that users usually get:

The following ODBC error occurred: Error: [Microsoft][ODBC SQL Server Driver] Database is invalid or cannot be accessed. State ID: HY024:

Error Database is invalid or cannot be accessed

This error means, that you have only “public” server role and “public” database role. You don’t have more permissions on SQL Server side.

The follow SQL Server error or errors occurred: 229,”42000″,[Microsoft][ODBC SQL Server Driver][SQL Server]The UPDATE permission was denied on the object ‘$ndo$srvproperty’, database ‘master’, schema ‘dbo’.

Error The UPDATE permission was denied

This error is different from the previous one, because you do have more sql permissions on the database from which you are trying to upload a license file. You have db_owner permission on the database side, but you still have only “public” Server Role.

Both of these errors mean that you lack permissions on SQL Server. So, what sql permissions do you actually need to upload a Dynamics NAV license file?

Well, firstly, you need to know what happens when you upload a license file. When you click Tools > License Information > Upload, system will upload the license file to the database you are connected to and then to the “master” database. Therefore, you need sql permissions on both of them.

This can be achieved one of the two ways:

1) You need to have “sysadmin” Server Role.
2) Or, you need to have “db_owner” role on database level for both your NAV database and master database. Then, from “Server Roles”, public role will be sufficient.

Having one of the two of the above, will allow you to upload the license file.

The server license was successfully uploaded

Error: The remote session was disconnected because there are no Terminal Server License Servers available to provide a license file

Once in a while when connecting to customer’s system using remote desktop published via Citrix, I get the following error message: The remote session was disconnected because there are no Terminal Server License Servers available to provide a license. Please contact the server administrator.

And because it doesn’t happen too often, each time I end up searching for a fix for this issue. Never again! 🙂 Let’s write it down, and let internet remember.

The Error: The remote session was disconnected because tehre are no Terminal Server License Servers available to provide a license. Please contact the server administrator.

The Fix:
2. Take a backup (Export) of folder [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSLicensing]
3. Delete [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSLicensing] folder
4. Reboot your computer
5. Run “Remote Desktop Connection” shortcut as Administrator (this will recreate MSLicensing folder in registry editor)

Book: Microsoft Dynamics NAV Financial Management

It’s interesting to work in a field where there are almost no books about it. Well, this is not true any more, as nowadays in Dynamics NAV field we have more books than ever before. However, just several years ago, when I first opened Dynamics NAV client, there were almost no books about it. The best you could get (if you worked for a partner) were technical training materials from Microsoft. And, if you work for end-user, then help files were your best friend. However, now (when product is changing so fast) it’s becoming easier to learn about Dynamics NAV. However, every time a new Dynamics NAV book is published, I try to get a hold of it.

And the latest book I’ve managed to get my hands (thank you, Tobin!) on is – Microsoft Dynamics NAV Finanacial Management. I would say the book is different from other Dynamics NAV books. What do I mean by saying that? All the previous books where designed by geeks for geeks (who not only work with NAV, but love it, and want to know every single detail of it). This book is different. It comes to you with a fresh approach – starting from the basics – Financial Management functionality in Dynamics NAV.

First time I have read it, I am not sure I liked it. I have read through all of it in one evening and thought – “what, that’s it“? Then I kept thinking for a few days, would I recommend this book to anyone? Where I work, everyone joining our team, need to take the financial exam in Dynamics NAV, because having the financial management knowledge, is one of the cornerstones of knowing and working with Dynamics NAV. So, would this book be a good place to start?

If you have started working with Dynamics NAV a few weeks ago, and don’t know what can be done with this product – this book will definitely give you an overview and examples of what is possible. If you have worked with Dynamics NAV as end-user for some time now, this book will confirm that you have been doing the tasks the right way. However, if you have worked with Dynamics NAV for a few years now, and you think that you really know ins and outs of the program – the book might give you “what, that’s it?” feeling.

Though, when reading a book for a second time (and third time), I’ve found a few more things that I liked about the book. There might be some things in NAV, which you understand  really well, but when in comes to explaining why this functionality works in particular way to a user who is less familiar with the product (for example, of why you need to nullify incorrectly posted invoice by raising a credit memo with incorrect data, and then raise a new invoice with correct data), this book can give you helpful insights.

If you have started working with Dynamics NAV recently, or if you have a new colleague, I would recommend to read this book. If you have been around for a few years, you might be able to pick up only a few little things, but it’s still worth going through the book.

So, have you read “Microsoft Dynamics NAV Financial Management“? What did you think of it?


Microsoft Dynamics NAV Financial Management @ PACKT Publishing.

Micosoft Dynamics NAV Financial Management

Microsoft Dynamics NAV 2013 Now Available

Dynamics 2013 is released!

I think the GAME has started on NAV techdays 2011 (yes, 2011!) – when I first saw the Dynamics NAV 2013 being presented. And it was awesome!

Today, is an AWESOME day as well –Microsoft officially released Dynamics NAV 2013.

Related Links

Zoom Function in Dynamics NAV 2013

About This Page
How many times have you used function Tools > Zoom? If you have, obviously, you know the keyboard shortcut for that – CTRL+F8, and you use it daily (or at least I do!).

I was watching Dynamics NAV 2013 training “Microsoft Dynamics NAV 2013 Finance New Features – Dimensions” today, and quite a few times Alessandro said “to Zoom in” click… CTRL+ALT+F1.

After a few times trying this keyboard shortcut, I would say, it is better – you can manage this combination with one hand, when for older one you needed two. However, it might be confusing for new Dynamics NAV users to understand “Zoom In” function – as it is no longer called that.

In Dynamics NAV 2013, it’s called “About This Page”. So, whenever, someone will tell you to Zoom In to page details, remember, to either go to Dynamics NAV > Help > About This Page, or CTRL+ALT+F1.

Related Links

Error when exporting budget to Excel – The call to member Add failed. Microsoft Office Excel returned the following message: That name is not valid.

Sometimes you get a question, which seems so easy, that you know the answer instantly. You need to follow simple steps and the issue will be resolved. However, just to be sure (before giving the answer) you try the solution yourself, and you bang your head into another, totally different issue.

Today, I was trying to answer how to export budgets that have been filtered by dimension to excel (with a possibility to modify the budget in excel and import it back to Dynamics NAV). Hint: it is not enough to apply a filter on Dimension Filter field, in Filters tab, in the Budget form. You need to select “Column Dimensions” on Options tab, in “Functions > Export to Excel” report’s request form. But, I will write about this some other time.

Today, when explaining, how to export the budget with “Column Dimensions” defined, I have encountered the error message: The call to member Add failed. Microsoft Office Excel returned the following message: That name is not valid.
Error when exporting Budget to Excel - The call to member Add failed

Firstly, I have checked, where the error message originates:
Error when exporting Budget to Excel - Function CreateRange

Secondly, I had a look if this code has been changed in later versions (I was getting error message in Dynamics NAV 5 SP1). Strangely, the function CreateRange in Dynmics NAV 2009 was exactly the same, but I wasn’t getting the error message in newer version.

After further analysis and research, I’ve worked out that this seems to be a known-issue for Dynamics NAV 5 SP1 (lately, I haven encountered quite a few “known-issues”) – the problem occurs when exporting a dimension code that contains blank space (or special characters) to Excel 2003/2007. This, however, works fine when exporting from Dynamics NAV 2009.

So, a workaround (until you will get upgraded to a newer version) would be to follow these steps:

1. Click Financial Management.
2. Expand General Ledger, and then click Budgets.
3. In the Budgets dialog box, click Functions, and then click Export to Excel.
4. In the Export Budget to Excel dialog box, click the Options tab.
5. In the Column Dimensions field, click the ellipsis button (…).
6. In the Dimension Selection dialog box, make sure that the dimension codes in the Code column do not contain a blank space or special characters.
7. If the dimension codes contain a blank space or special characters, rename the dimension codes. For example, if a dimension code is named “My Name,” you can rename the dimension code to “MyName” or “My_Name.”

Error: You do not have permission to read the 0 table.

There are quite a few error messages you can get when setting up Dynamics NAV security – database is invalid or cannot be access, you do not have permissions to read the table, etc, etc. And once you have seen them, next time you will know (more or less) possible solution for it. And I thought I have seen all of them by now. However, today, I’ve seen one more error, which I have seen before, but the cause of it was different! You do not have perission to read the 0 table (SUPER user was trying to create another SUPER user and received this error message).

You do not have permission to read the 0 table - Error

So, what could have caused this? Continue reading “Error: You do not have permission to read the 0 table.”

How to Create Additional No. Series For the Same Document?

Just a few days ago, I have written How to Create No. Series in Dynamics NAV, and today I got one more question about No. Series. How to create an use additional No. Series for the same document type?

For example, let’s say, that you want to use one number series, for most of your customers:
No. Series Relation - First No. Series

But for, other customers (specifically, customers who own factories), you would like to use another set of number series:
No. Series Relation - Second No. Series

How would you achieve that? Well, (as in most cases with Dynamics NAV setups) this is quite easy.
1. Firstly, you need to create both number series.
2. Secondly, you need to define the first number series in setup (as per our example, that would be in Sales & Receivables Setup, Numbering tab, “Invoice Nos” field, select “CSI” No. Series).
3. Go to Administration > Application Setup > General > No. Series and find “CSI” No. Series. Click Line > Relationships.
No. Series Relation - Series Relationships

4. In the opened form, define second number series (as per our example, that would be FSI):
No. Series Relation - Define Relationship to Second No. Series

And that’s it! Now, when creating sales invoices, all you need to do (after clicking F3, or Edit > New), is to drill down into “No.” field:
No. Series Relation - New Sales Invoice

And you will be able to select one of the two number series: CSI or FSI:
No. Series Relation - Select Second No. Series

No. Series Relation - Sales Invoice With Different No. Series

Application Method Field on Customer Card, Payments Tab

Recently, I have been asked what is the use of Application Method field on Customer card, on Payments tab? Without looking at the field, my initial response was Huh? (I have never used this field before).
Application Method Field in Customer Table

I quickly jumped into CRONUS UK database and filtered customer list setting Application Method <> Manual. The result – only 1 customer (20000 Selangorian Ltd). This would explain the reason, I’ve never seen this field – even in CRONUS there is only one example!

However, as always, Dynamics NAV help files can answer such straight-forward questions (no need to know everything, right?).

Application Method Field on Customer Card, Payments Tab
In Application Method field you can choose how the program will apply payments for this customer. To determine the application method, click the AssistButton in the field and select one of the two options:

  • Manual – If you select Manual, you must manually specify in the Apply Customer Entries window which sales document a payment applies to.
  • Apply to Oldest – If you select Apply to Oldest, the program will automatically apply the payment to the oldest of the customer’s open entries.

If you do not enter anything here, the application method will be Manual.