Dynamics NAV: Get SQL Server Name for current installation

I recently wrote a little blog on how to determine, if the current installation is a multitenant installation. 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.

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=
2013 R2

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=, Culture=neutral, PublicKeyToken=31bf3856ad364e35′

GetSQLServerName() : Text
ServerUserSettings := ServerUserSettings.Instance();
IF FORMAT(ServerUserSettings.DatabaseInstance) <> '' THEN


The first line instantiates the .NET variable, which is one of the DLLs that Microsoft ships with Dynamics NAV. And the next lines get the server name and the SQL instance name. If there is no instance, only the server is returned, otherwise the server\instance are returned.

1 ping

  1. […] Bron : Peter’s Blog/a> Lees meer… […]

Leave a Reply

Your email address will not be published.

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