Small and medium business | Business Central, N...

Moving Navision DB to Azure

(0) Share

Report

Posted on by Navision

Hi ,

We want to deploy navision 2017 database to azure sql as a service , so I managed to extract the Schema and data and moved them to Azure .

My problem now is User access is denied .

Even I tried to connect with the Database owner I always have the same problem which is access denied and couldn't find source of help .

All responses (5)

Answers (0)

Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

RE: Moving Navision DB to Azure

Is this error thrown by the RTC client?

By default the database where the RTC tries to connect is stored in a config file called ClientUserSettings.Config.

The path for the ClientUserSettings.Config file is:

C:\Users\<username>\AppData\Local\Microsoft\Microsoft Dynamics NAV

Check the below 3 keys and point them to the right db:

<add key="Server" value="localhost" />

<add key="ServerInstance" value="DynamicsNAV" />

<add key="ServerPort" value="7076" />

If this doesn't work, you can remove all user's personalization by executing the following sql queries:

USE [Database Name]

GO

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]

then access the database again.
Navision 5 on at

Like (0)

Report

RE: Moving Navision DB to Azure

I have created a new user :

New-NAVServerUserPermissionSet -PermissionSetId SUPER -ServerInstance DynamicsNAV100 -WindowsAccount "chris1"

New-NAVServerUserPermissionSet -PermissionSetId SUPER -ServerInstance DynamicsNAV100 -UserName "chris1"

In my DB credential here , I used the owner of the Server admin and it's password

But :

Did I miss something here ?
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

RE: Moving Navision DB to Azure

You can use New-NavServerUser cmdlet with Powershell to create a new user:

docs.microsoft.com/.../new-navserveruser

To assign permissions:

docs.microsoft.com/.../new-navserveruserpermissionset
Navision 5 on at

Like (0)

Report

RE: Moving Navision DB to Azure

I have a sql user ,and those are the users I have inside nthe User table in Navision , but how to give them super permission or how to create one using sql with super permission ?
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (1)

Report

RE: Moving Navision DB to Azure

Is there a valid user in SQL Server? Do you have a user inside the User table in NAV (SUPER permission set)?