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

Encryption Key

(0) Share

Report

Posted on by VP-14050725-0

Hi guys,

I have a problem when i try to create and import an encryption key.

Enviroment Structure:

Database: Azure SQL
Busines Central: OnPrem v20
2 Azure Active Directory login and 2 NavUserPassword

I am using this commands:

New-NAVEncryptionKey -KeyPath C://Keys//BC20_OGOZA_PRE_NUP.key

Import-NAVEncryptionKey -ApplicationDatabaseName BC20_OGOZA_PRE_NUP -ApplicationDatabaseServer srv-backendbbdd-pro.database.windows.net -KeyPath C://Keys//BC20_OGOZA_PRE_NUP.key -ApplicationDatabaseCredentials $credObject

$credObject is a variable of the type pscrendential

This is the error:
Import-NAVENcryptionKey : Unable to establish a connection to the SQL Server or database.
This could be due to the following reasons, among others:
* SQL Server did not start.
* The database does not exist.
* The NAV Server account was not granted proper permissions.

Thank you very much

Regards

Vicente

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

KasparsSemjonovs 4,764 Super User 2025 Season 2 on at

Like (0)

Report

Most probably the database is called differently. Could be that You are using the Instance (service) name instead of database?

Was this reply helpful? Yes No
YUN ZHU 95,329 Super User 2025 Season 2 on at

Like (0)

Report

Hi, I hope the following information can also help you.

https://github.com/Microsoft/nav-docker/issues/114

https://learn.microsoft.com/en-us/powershell/module/microsoft.dynamics.nav.management/new-navencryptionkey?view=businesscentral-ps-22

Thanks.

ZHU

Was this reply helpful? Yes No
VP-14050725-0 18 on at

Like (0)

Report

Hi,

The instance is configurated with network service user and the authentication to Database is SQL user authetication.

The instance (service) and the database name are the same to avoid confusion.

I don't understand what's happening.

Zhu i am a follower of your forum, i would appreciate it if you uploaded an example like this. In Spain we use this configuration a lot.

Thanks yo so much

Regards

Was this reply helpful? Yes No