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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Navision Domain
Small and medium business | Business Central, N...
Suggested answer

Navision Domain

(2) ShareShare
ReportReport
Posted on by WH-17051047-0 41
Our instance of Navision is linked to a domain for single sign on. How easy is this to remove? We have the server running in Azure now and want to disassociate this with the domain now but want to allow occasional user access for historical access.
Categories:
Microsoft Dynamics NAV
I have the same question (0)
  • MichaelTorres Profile Picture
    MichaelTorres 86 on at
    Navision Domain
    Hello,

    it's possible, but there are a few things to consider. Since your server is running in Azure, the simplest way is to remove the domain dependency while keeping local user accounts for access.

    1. Backup. Always take a full backup before making any changes, just in case

    2. Before removing the domain, ensure you’ve created local Windows user accounts and assigned them the necessary Navision permissions. Otherwise, you might lock yourself out

    3. If Navision is using Windows Authentication for SQL access, you’ll need to switch to SQL authentication and update connection settings

    4. Once local accounts are in place, disjoin the server from the domain via System Properties -> Change Settings and reboot

    5. If some users still need occasional access, you can set up a simple VPN or Azure Bastion for secure RDP connections

    Hope this helps!
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 92,578 Super User 2025 Season 2 on at
    Navision Domain
    Hi, use the following command to clear the user, and the next login user will be the super user. 
     
    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]
     
     
    Hope this helps.
    Thanks.
    ZHU

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

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

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 4,160

#2
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 2,943

#3
Sumit Singh Profile Picture

Sumit Singh 2,823

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans