Error while opening RTC Dynamics 365 Business Central: You do not have the following permissions on CodeUnit ApplicationManagement: Execute

Dear Readers,

This blog is a summary to resolve this step and it is fine with all RTC Clients available from NAV 2013.

Step 1.

Use this query in SQL.

Use [DATABASE]
DELETE FROM [dbo].[User];
DELETE FROM [dbo].[Access Control];
delete From [dbo].[User Property];
delete FROM [dbo].[Page Data Personalization];
Delete FROM [dbo].[User Default Style Sheet];
Delete FROM [dbo].[User Metadata];
DELETE FROM [dbo].[User Personalization];

Step 2.

Open Administration Shell of NAV version which you are using via Run as Administrator

Type these 3 Commands.

Command 1

Import-Module "${env:ProgramFiles}\Microsoft Dynamics NAV\80\Service\NavAdminTool.ps1"

Command 2

New-NavServerUser -WindowsAccount 'domain\user' -ServerInstance InstanceName

EG. New-NavServerUser -WindowsAccount "xyz\user name" -ServerInstance DynamicsNav90

Command 3

New-NavServerUserPermissionSet -WindowsAccount 'domain\user' -ServerInstance
InstanceName -PermissionSetId SUPER

EG. New-NavServerUserPermissionSet -WindowsAccount "domain\user name" -ServerInstance DynamicsNav90 -PermissionSetId COST

Step 3.

Execute the SQL Command written below you need to change Domain\User.

SET NOCOUNT ON

GO

USE [DATABASE NAME]  -- NAV 2013 database you want to use

GO

DECLARE @UserID varchar(100)

SET @UserID = 'domain\Username'  -- Windows Login you want to add

-- Get security identifier (SID) for specified user.  Login must be setup in SQL Server first.

DECLARE @BinarySID binary(100)

SELECT @BinarySID = sid FROM sys.syslogins WHERE name = @UserID

IF @BinarySID IS NULL

  RAISERROR('SQL Server login not found for User %s.', 10, 1, @UserID)

-- SID is stored in the User table as a formatted string.  Need to convert it.

DECLARE @StringSID varchar(238)

DECLARE @i AS int

DECLARE @j AS int

DECLARE @Grp AS int

SELECT @StringSID = 'S-'

    + CONVERT(VARCHAR, CONVERT(INT, CONVERT(VARBINARY, SUBSTRING(@BinarySID, 1, 1))))

SELECT @StringSID = @StringSID + '-'

    + CONVERT(VARCHAR, CONVERT(INT, CONVERT(VARBINARY, SUBSTRING(@BinarySID, 3, 6))))

SET @j = 9

SET @i = LEN(@BinarySID)

SET @Grp = 1

WHILE (@j < @i) AND (@Grp <= 5) BEGIN

  SET @Grp = @Grp + 1

  DECLARE @val BINARY(4)

  SELECT @val = SUBSTRING(@BinarySID, @j, 4)

  SELECT @StringSID = @StringSID + '-'

    + CONVERT(VARCHAR, CONVERT(BIGINT, CONVERT(VARBINARY, REVERSE(CONVERT(VARBINARY, @val)))))

  SET @j = @j + 4 

END

-- Check to see if User record already exists

DECLARE @UserGUID uniqueidentifier

SELECT @UserGUID = [User Security ID]

FROM [User] WHERE [Windows Security ID] = @StringSID

IF @UserGUID IS NOT NULL

  PRINT 'User ID ' + @UserID + ' already exists in User table.'

ELSE BEGIN

  -- Generate new GUID for NAV security ID

  SET @UserGUID = NEWID()

  -- Create User record

  INSERT INTO [User]

  ([User Security ID], [User Name], [Full Name], [State], [Expiry Date], [Windows Security ID], [Change Password],[License Type],[Authentication Email],[Contact Email])

  VALUES(@UserGUID, @UserID, '', 0, '1/1/1753', @StringSID, 0, 0 ,'VE00AC832@yamaha-motor-india.com','') 

  PRINT 'Created User record for User ID ' + @UserID + '. - ' + CAST(@@ROWCOUNT AS varchar) + ' row(s) affected.'

END

-- Check to see if user is assigned to SUPER role 

IF EXISTS(SELECT * FROM [Access Control] WHERE [User Security ID] = @UserGUID AND [Role ID] = 'SUPER' AND [Company Name] = '')

  PRINT 'User ID ' + @UserID + ' is already assigned to SUPER role.'

ELSE BEGIN 

  -- Create Access Control record to add user to SUPER role

  INSERT INTO [Access Control]

  ([User Security ID], [Role ID], [Company Name],[App ID],[Scope])

  VALUES(@UserGUID, 'SUPER', '','2de23703-bbb9-4542-970d-84b6e5597f53','0')

  PRINT 'Added User ID ' + @UserID + ' to SUPER role. - ' + CAST(@@ROWCOUNT AS varchar) + ' row(s) affected.'

END

-- User Property record required to allow login

IF EXISTS(SELECT * FROM [User Property] WHERE [User Security ID] = @UserGUID)

  PRINT 'User Property record already exists for User ID ' + @UserID + '.'

ELSE BEGIN

  INSERT INTO [User Property]

  ([User Security ID], [Password], [Name Identifier], [Authentication Key], [WebServices Key], [WebServices Key Expiry Date],[Authentication Object ID])

  VALUES(@UserGUID, '', '', '', '', '1/1/1753','')

  PRINT 'Created User Property record for User ID ' + @UserID + '. - ' +  CAST(@@ROWCOUNT AS varchar) + ' row(s) affected.'

END

SET NOCOUNT OFF

GO

How to create New Nav Company using powershell?

Hi All,

Today I got one situation where we need to create a new NAV database from database itself and add the FOB and when we try to open it.

NAV will give us the ERROR 'No Company is found' or something like that.

So I interacted with powershell and sharing the basic steps to create Company in powershell if my nav developers get stuck in between.

SO lets start with powershell.

Step 1.

Open MS DYNAMICS NAV 2018 Administration Shell with Administrator Mode (Very important)

Import the Module using this command.

Import-Module "${env:ProgramFiles}\Microsoft Dynamics NAV\80\Service\NavAdminTool.ps1"

Step 2 .

Once it is imported Follow below screenshot :

It will take a while , if instance is running and everything works fine you can proceed with running your new company in RTC.

Top Secrets You Will Not Want To Know About Creating Multiple Users With Powershell By Blogs.anandnavconsultant.com

Microsoft Dynamics Navision: Adding Users in NAV 2016 Database using powershell.

Requirement :-

Creating User with Powershell is needed when we require to add multiple users in NAV specially in RTC Client.

1.We can create multiple users with there Permissions on User Card Page.

2.While setting up new Company and also in upgrade project we can use this command to create all users in a on single Command.

3.When we dont have access to DB and When you try to access the Client (Windows / Web / Tablet / Phone) System generates the Error Message.

1. You do not have access to Microsoft Dynamics NAV. Verify that you have been set up as a valid user in Microsoft Dynamics NAV.

Solution :

1.Open Dynamics Nav 2016 Administration Shell from Start Menu.



2.After Opening , wait and Paste this Command by changing your domain and instance name.

New-NavServerUser -WindowsAccount 'domain\user' -ServerInstance InstanceName

EG. New-NavServerUser -WindowsAccount "xyz\user name" -ServerInstance DynamicsNav90

New-NavServerUserPermissionSet -WindowsAccount 'domain\user' -ServerInstance
InstanceName -PermissionSetId SUPER

EG. New-NavServerUserPermissionSet -WindowsAccount "domain\user name" -ServerInstance DynamicsNav90 -PermissionSetId COST

3.Press Enter and check your user name in User Table your user will be created with this command and you will be able to connect with the database.

Please Note: You must be administrator of your System.I hope this would surely help you. If you are still facing any issue then please comment in below section.

You can also refer
Saurabh Dhyani Sir Blog At :
Refer Here to Saurav Sir Blog
Also Magno's Blog At:
Waldo's Blog