web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Business Central v26 –...
Small and medium business | Business Central, N...
Answered

Business Central v26 – Two-Server Setup with Web Client Delegation

(5) ShareShare
ReportReport
Posted on by CU08070924-0 86
Hello all,
 
For a client project, I installed Business Central v26 (on premise) using the two-computer environment scenario 2 described in the Microsoft documentation (Installing Business Central in a Two Computer Environment).
Here's the setup I implemented:
  • Server 1: Business Central Server and SQL Server components installed.
  • Server 2: Only the Web Server component installed.
  • I configured Kerberos delegation and SPNs as per the documentation (Configure Web Client Delegation).
Additionally, instead of using the default NT AUTHORITY\NETWORK SERVICE, I used a domain service account for the Business Central service. I made sure to grant the necessary permissions in SQL Server Management Studio to allow access to the Business Central database.
 
I reconfigured the instance to point to a different SQL Server database (with a valid BClicence) using the following PowerShell commands:

Set-NAVServerConfiguration -ServerInstance BC_PRD -KeyName DatabaseServer -KeyValue "MLPRDDBS0003"
Set-NAVServerConfiguration -ServerInstance BC_PRD -KeyName DatabaseInstance -KeyValue "BUSCTLPRD"
Set-NAVServerConfiguration -ServerInstance BC_PRD -KeyName DatabaseName -KeyValue "BDD_BC26"
Restart-NAVServerInstance -ServerInstance BC_PRD
 
The service restarted successfully without errors.

Next, on the web client server, I opened the BC instance in Chrome via IIS. When prompted, I logged in using my Windows credentials. However, I received the following error:


This is unexpected because my Windows user has been granted SUPER permissions directly in the Business Central database.

Has anyone encountered this issue when pointing a BC instance to a different database?

Any suggestions, insights, or shared experiences would be greatly appreciated.

Thank you in advance!

Regards,
Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 95,763 Super User 2025 Season 2 on at
    Hi, Try clearing all users. It looks like your user name doesn't match the one added in the system, or there is a problem with the record you inserted directly into the database.
     
    Hope this helps.
    Thanks.
    ZHU
  • CU08070924-0 Profile Picture
    CU08070924-0 86 on at
    Hello,
     
    Thanks for your response, @Yan Zhu.

    I followed your suggestion and cleared the users, but unfortunately, I’m still getting the same error message.

    I’ve made sure that my username matches the one added in the system using this PowerShell command:
           New-NAVServerUser BC_ML_PRD -WindowsAccount 'DOMAIN\MY-USERNAME'
     
    This issue only happens in our production environment, which is set up on two separate servers.
    On my local single-computer installation (BC26 sandbox), I was able to add the same user to the same database without any problems.
     
    Also, to confirm that the Business Central instance is properly connected to the database, I ran these PowerShell commands and the results were positive:
           Get-NAVServerConfiguration -ServerInstance BC_PRD | Where-Object {$_.Key -match 'Database'}
           Get-NAVCompany -ServerInstance BC_PRD

    Any ideas on what else I could check?

    Thanks in advance!
  • Verified answer
    CU08070924-0 Profile Picture
    CU08070924-0 86 on at
    Hello,

    Since I couldn't find a solution for my problem. I used the other scenario of Microsoft to install BC26 (Installing Business Central in a Two Computer Environment - Business Central | Microsoft Learn) and it works for me.

    Regards,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,116

#2
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 764 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 635 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans