Dynamics User Group
Dynamics User Group
  • Site
  • User
  • Site
  • Search
  • User
Dynamics 365 Business Central/NAV User Group
Dynamics 365 Business Central/NAV User Group
Dynamics NAV urpok
  • Forums
  • Blogs
  • Resources
  • Wikis
  • Events
  • Leaderboards
  • Members
  • Mentions
  • Tags
  • More
  • Cancel
  • New
Dynamics 365 Business Central/NAV User Group requires membership for participation - click to join (it's free)
Dynamics NAV urpok
Urpo Kotipalo's blog about Dynamics NAV

  • Home
  • Subscribe by email
  • More
  • Cancel
  • Posts RSS
  • Atom
  • More
  • Cancel
Monthly archive list
  • September 2020 (3)
  • August 2020 (2)
  • July 2020 (2)
  • June 2020 (1)
  • May 2020 (1)
  • April 2020 (2)
  • March 2020 (2)
  • December 2019 (1)
  • September 2019 (3)
  • June 2019 (1)
  • May 2019 (3)
  • April 2019 (4)
  • March 2019 (1)
  • February 2019 (2)
  • January 2019 (2)
  • December 2018 (1)
  • November 2018 (1)
  • October 2018 (4)
  • September 2018 (2)
  • August 2018 (1)
  • July 2018 (2)
  • April 2018 (2)
  • March 2018 (1)
  • February 2018 (1)
  • January 2018 (2)
  • December 2017 (3)
  • September 2017 (1)
  • August 2017 (1)
  • February 2017 (2)
  • January 2017 (4)
Related
Related Tags
  • Best Practises
  • Business Central On Premises
  • ClickOnce
  • cumulative update
  • Data Export
  • Development
  • gdpr
  • License
  • Localisation
  • NAV Versions
  • NAV2016
  • NAV2017
  • nav2018
  • New Features
  • patterns
  • Performance
  • Powershell
  • RTC
  • Service Handling
  • TearDown
  • T-SQL
  • Update Experiences
  • VAT Rate Tool
  • Visual Studio Code
  • whats new
Blog post list
  • Tags
  • Subscribe by email
  • More
  • Cancel
  • How to access NAV 2018 database with RTC if you do not have user account set up?

    Urpo Kotipalo
    Urpo Kotipalo
    This question has arisen for earlier versions many times, and as many times it has been answered as well. In the old times it was easy enough, just delete contents of some tables and voilá, you are in. After three-tier architecture things got a tad bit more difficult. My answer has been for a long time to use a T-SQL script to add my AD account to all relevant NAV tables so I can just start the RTC client and start using the new database conveniently. The original script is stolen from Anonymous commenter in Waldo's blog , and during the years I have added all the new fields that have been…
    • 2017-12-28
    • Original post
    • SQL
    • nav2018
    • Access
    • T-SQL
    • 5043 views
    • 0 comments
    • over 3 years ago
    • More
    • Cancel
  • The Following SQl error was unexpected: Invalid object name 'master.dbo.$ndo$srvproperty'.

    Urpo Kotipalo
    Urpo Kotipalo
    I installed a new development server and a brand new MS SQL 2017 server. After installing all the NAV components to the NAV development server, I restored the demo database, run the script to add my AD user to NAV tables, started the service and tried to log in. Not so suprisingly, I received an error, but this time I had never seen it before. The error message is in the title and attached screenshot. After brief examination, I found out that this table is indeed missing from the NAV installation disk database backup. Luckily it is very easy to create: * Open the database with Development…
    • 2017-12-28
    • Original post
    • nav2018
    • SQL2017
    • 18098 views
    • 0 comments
    • over 3 years ago
    • More
    • Cancel
  • Dynamics NAV 2018 "The tenant 'default' is not accessible" when compiling a table

    Urpo Kotipalo
    Urpo Kotipalo
    I was doing some changes to NAV 2018 tables and run into this error after import + compile a table as a text file. The error is very confusing, since in this special case I do not have any kind of tenancy, it is just old plain familiar all-in-one solution with normal SQL, normal virtual machine as NAV Server and local development environment. I tried re-compiling, and the error went even wackier: "Unable to process table changes because the Microsoft Dynamics NAV Development Environment cannot connect to the specified Microsoft Dynamics NAV Server instance: <snip> Microsoft Dynamics NAV…
    • 2017-12-19
    • Original post
    • nav2018
    • 29898 views
    • 7 comments
    • over 3 years ago
    • More
    • Cancel
  • DUG Home
    • Contact DUG
  • Dynamics 365 for Finance and Operations/AX User Group
    • Forums
    • Blogs
  • Dynamics 365 Business Central/NAV User Group
    • Forums
    • Blogs
    • Wikipedia
    • Events
  • About DUG
    • Announcements
    • Frequently asked questions about DUG
    • Membership service
    • Advertise on DUG
    • Become a DUG sponsor
    • Follow us on LinkedIn
    • Follow us on Facebook
    • Follow us on Twitter
  • More
  • Cancel
  • Microsoft Dynamics 365 User Groups

  • Dynamics 365 Business Central
  • Dynamics 365 Customer Engagement
  • Dynamics 365 for Finance and Operations
  • Power Platform
  • Microsoft Dynamics User Groups

  • Dynamics AX
  • Dynamics CRM
  • Dynamics NAV
  • About
  • Contact us
  • Frequently asked questions
  • Terms of use
  • Privacy policy
Copyright 1995-2021 Dynamics User Group, all rights reserved.