Saturday, May 28, 2011

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

1 comment:

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

    ReplyDelete

Popular Posts