Skip to main content

NAV Classic - Database Login To Windows Login.

Hi Readers,

Most of you may not want to see this, but I would like to keep this information for me.

As most of you know that I live and breath Upgrades for Dynamics NAV / Business Central.

Currently I am upgrading a customer from NAV 4 Native to Business Central. As its challenging there is so much learning too.


Customer is using database logins and they had so many users. As I knew that I will have to port them to windows login sooner than later so why not now.

I started thinking easy way to do it.

Here is the way - 

1. Asked Customer for User mapping - Database user name & Windows User Name.

2. Import that data in a temp table using Dataport and write a script to create windows account in database and also copy assigned Roles from database user to Windows User.

The only problem that I faced was - Windows Login (2000000054) have primary key SID.

I know I had done those conversions in future versions of the product, but how you do that in NAV 4.

To My surprise after little bit of searching I found out that there was a virtual table - "SID - Account ID".

With this virtual table you can get the SID for a Windows User Account (ID).

Sample Code - 

SIDAccountID.SETCURRENTKEY(ID); // This line is important. Set it to ID if you want to find SID
  MESSAGE('%1\%2', SIDAccountID.ID, SIDAccountID.SID);

Hope this article helps you.

I am sure I will have so many learnings with this project. If I find something useful, I will share that.

Read More about  SID- Account ID Virtual Table here.

Mibuso Article

Saurav Dhyani


Post a Comment

Popular posts from this blog

VIEW SERVER STATE permission on SQL Server?

Hi all, Sometime While trying to Login into a database we face an error message as shown below. --------------------------- Microsoft Dynamics NAV Classic --------------------------- You cannot start Microsoft Dynamics NAV Classic because you do not have the VIEW SERVER STATE permission on SQL Server. Contact your system administrator. --------------------------- OK    ---------------------------

NAV 2013 R2 - Cumulative update 12 Released.

Hi all, Please find below the details of  Cumulative Update 12 released for Microsoft Dynamics NAV 2013 R2. Title - Cumulative Update 12 for Microsoft Dynamics NAV 2013 R2 Build No. - 38053 Release Date - October, 2014 Local Version Included - AU, AT, BE, CH, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, SE, UK, RU Download Link Note: Implementing this cumulative update will require a database conversion unless you have already implemented update rollup 5.

NAV 2013 Upgrade Part III - Data Upgrading.

Hi all, As per agenda we need to discuss the data upgrade in NAV 2013. The process is similar to what used to be till NAV 2009 R2 but with some changes. Let's start the process. Remember -  1) You can only upgrade a database to NAV 2013 from NAV 2009 SP1 / R2 SQL Only. 2) The Synchronization of users with SQL Server is no more required.