Dynamics User Group
Site
Search
User
Site
Search
User
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
By date
By view count
By comment count
Descending
Ascending
How to access NAV 2018 database with RTC if you do not have user account set up?
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
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
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