Skip to main content

Change Listener Error in Microsoft Dynamics NAV 20009 RTC and ahead

Hi Readers,

A common error faced most of time while trying to start Microsoft Dynamics Navision 2009 Role Tailored Client is of Change Listener with username in the database.


For resolving the issue follow the below given steps.

Open SQL Server Management Studio. and then connect to your SQL Server instance.

On the File menu, point to New, and then click Query with Current Connection.

Type in these commands one by one and then selecting the whole query and click Execute button-


USE MASTER
CREATE LOGIN [ReplaceWithNAVServerAccount] FROM WINDOWS;
GO


USE [ReplaceWithYourDatabaseName]
CREATE USER [ReplaceWithNAVServerAccount] FOR LOGIN[ReplaceWithNAVServerAccount];


CREATE SCHEMA [$ndo$navlistener] AUTHORIZATION[ReplaceWithNAVServerAccount];
GO


ALTER USER [ReplaceWithNAVServerAccount] WITH DEFAULT_SCHEMA = [$ndo$navlistener];
GRANT SELECT ON [Object Tracking] TO [ReplaceWithNAVServerAccount];
GO


That's it. The Object Change Listener is configured on the desired username for the database.

You might get some error while executing these queries but don't worry, it is because you have already created and synchronized the Windows user from the FinSQL Client.

Regards,
Saurav Dhyani
www.sauravdhyani.com

Comments

  1. Cannot find the object 'Object Tracking', because it does not exist or you do not have permission

    ReplyDelete

Post a Comment

Popular posts from this blog

Send Mail with Attachment From Navision.

Hi all, We have seen how to save a report into PDF and how to send mail to a customer. Let's link these two post in one i.e. Mailing statement to a customer into PDF Format. This article is part of the Series. Please Refer  Table of Content here . If you have the old objects set let me brief you what I will be changing - 

Microsoft Dynamics NAV 2016 - How to Configure Phone Client.

Hi All, In this article we will discuss how we can connect Microsoft Dynamics NAV 2016 with New Client Launched i.e. Phone Client. This Article Contain Steps for a Android Phone as I have Only Android Phone. I am doing it having all tiers on my windows 8 machine, steps remain same for multiple servers but issues might be different. What we Need (Other what we discuss in this article) -  The Service Tier should be on Public IP . Some of the Data-card does not Provide you Public IP. check it for sure.

Download Microsoft Dynamics Business Central on Premises 2020 Wave 2 Release.

 Hi Readers, As Expected Microsoft have released #msdyn365bc 2020 wave 2 is available.  This article provides details of the new release. The 2020 release wave 2 for Business Central delivers a wealth of new features. Read What's new in 2020 Release Wave 2 here .  Dynamics NAV Customers upgrading to Business Central on Prem will be able to run business central on premises, move to cloud or choose a hybrid approach.