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 .

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (1)

Report

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

Was this reply helpful? Yes No
Navision 5 on at

Like (0)

Report

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 ?

Was this reply helpful? Yes No
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
Navision 5 on at

Like (0)

Report

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 ?

Was this reply helpful? Yes No
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No