Enabling Premium Experience in Business Central Sandbox Containers
A few people have discovered that manufacturing, production, and other functionality which only is available when using Premium Plan is not available when running a Business Central Sandbox Container.
The reason for this is, that this is controlled by the User Plan and by default the admin user has the essential plan. In Business Central, the plan is something that is controlled by what plan you purchase and you will not be able to add or modify records in the User Plan table.
Business Central Sandbox Containers are for development and test and of course we need to be able to develop and test against Premium – but it is also important to be able to run with essentials.
This blog post will describe how to assign the premium plan to your default super user in the NavContainer. It will also describe how you can create a number of test users and assign user groups and permissions to these users, so that you can test your app using the different users.
Username User Groups Permission Sets EXTERNALACCOUNTANT D365 EXT. ACCOUNTANT D365 BUS FULL ACCESS D365 EXTENSION MGT D365 EXTENSION MGT D365 READ LOCAL PREMIUM D365 BUS PREMIUM D365 BUS PREMIUM D365 EXTENSION MGT D365 EXTENSION MGT LOCAL ESSENTIAL D365 BUS FULL ACCESS D365 BUS FULL ACCESS D365 EXTENSION MGT D365 EXTENSION MGT LOCAL INTERNALADMIN D365 INTERNAL ADMIN D365 READ LOCAL SECURITY TEAMMEMBER D365 TEAM MEMBER D365 READ D365 TEAM MEMBER LOCAL DELEGATEDADMIN D365 EXTENSION MGT D365 BASIC D365 FULL ACCESS D365 EXTENSION MGT D365 RAPIDSTART D365 FULL ACCESS D365 RAPIDSTART LOCAL
and… – I will describe how to do this, whether you use Azure VMs, navcontainerhelper or docker run.
Azure VMs
If you use http://aka.ms/bcsandbox to create your Business Central Sandbox Container Azure VM, you will find two new options in the Azure Resource Manager template, which by default are set to yes.
The first option is whether or not your admin user should be assigned a premium plan. The second is whether or not you want the setup to include the test users described above – that’s it – by default you get premium plan and test users, as of today.
NavContainerHelper
If you are using New-NavContainer to create your Business Central Sandbox Container, you should upgrade to version 0.2.8.3.
Now you will have a new switch called assignPremiumPlan on New-NavContainer, use it like this:
New-NavContainer -accept_eula -assignPremiumPlan -containerName test -imageName microsoft/bcsandbox
Adding this option will assign the premium plan to your default admin user. Internally this just adds a record to the User Plan table.
In order to create the test users you will have to call a function called
Setup-NavContainerTestUsers containerName test -tenant default -password $securePassword
and specify the container and the password you want to use for the new users.
Internally, the Setup-NavContainerTestUsers downloads a codeunit with ID=50000, imports it and run an external function called CreateTestUsers with the password needed. After this you can delete or overwrite the codeunit, it is not needed anymore. The implementation might change.
If you want to see the codeunit, or if you need to modify the codeunit for your needs, you can download it at http://aka.ms/createtestusersfob.
Docker run
When you are using docker run to run your containers, you have a little more work to do.
First of all, you need to override the SetupNavUsers.ps1 by sharing a local folder to c:\run\my in the container and place a file called SetupNavUsers.ps1 in that folder with this content:
# Invoke default behavior . (Join-Path $runPath $MyInvocation.MyCommand.Name) Get-NavServerUser -serverInstance NAV -tenant default |? LicenseType -eq "FullUser" | % { $UserId = $_.UserSecurityId Write-Host "Assign Premium plan for $($_.Username)" sqlcmd -S 'localhost\SQLEXPRESS' -d $DatabaseName -Q "INSERT INTO [dbo].[User Plan] ([Plan ID],[User Security ID]) VALUES ('{8e9002c0-a1d8-4465-b952-817d2948e6e2}','$userId')" | Out-Null }
This will assign the premium plan to the admin user in the database.
In order to setup test users, you should download the codeunit from http://aka.ms/createtestusersfob import it using the classic development environment and run the CreateTestUsers function in the codeunit with the password you want to set for the users.
Enjoy
Freddy Kristiansen
Technical Evangelist