Dynamics NAV: Get Database Name for current installation

I started writing a couple blogs to determine, if the current installation is a multitenant installation or how to get the name of the current SQL Server. There are a few more useful things that you can do with the DLLS that are shipped with Dynamics NAV. I am going to add some more with different blog posts and hope that you will find them useful and don’t have to spend as much time as I needed until I found this. You might also look a bit more into this DLL, since you have access to all of the configuration settings that you have in the NAV Administration Console or the actual .config file.

I have tested this with NAV versions 2013 R2 and higher, it works in all versions. There are slight differences in the different versions, since you will have to reference the proper DLL for your version. The “Version=” part of the DLL listed below must be replaced with the following for each version.

NAV Version Version=
2018 11.0.0.0
2017 10.0.0.0
2016 9.0.0.0
2015 8.0.0.0
2013 R2 7.1.0.0

I wrapped this is a function shown below. The function declares the following local variable:

Name: ServerUserSettings
Type: DotNet
Subtype: Microsoft.Dynamics.Nav.Types.ServerUserSettings.’Microsoft.Dynamics.Nav.Types, Version=10.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35′

The first line instantiates the .NET variable, which is one of the DLLs that Microsoft ships with Dynamics NAV. And the next line returns the database name. Very easy, isn’t it?

1 comment

    • Paolo Titta on April 30, 2018 at 5:52 am
    • Reply

    Hello it seems not works anymore in NAV 2018… The Dll changed?
    There is another way to obtain the name of the instance?
    thanks
    Paolo

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.