Change listener connetion error

“The Microsoft Dynamics NAV Server cannot connect the Change Listener to SQL Server because of the following error: user ‘NT AUTHORITY\NETWORK SERVICE’ failed when log in”.

This error may happen when you are attaching the database manually, or if database and NAV service is on two different machines. A variation of this may also happen if you setup NAV server to user domain user account. Luckily the solution is the same for all problems

Enabling the Object Change Listener
1. Open “SQL Server Management Studio” and then connect to your SQL Server instance.
2. On the File menu, point to New, and then click Query with Current Connection.
3. Type the following SQL statements.

USE MASTER
CREATE LOGIN [ReplaceWithNAVServerAccount] FROM WINDOWS;
GO

4. Highlight the lines that you typed and, on the Query menu, click Execute.
5. Now type these lines below the existing lines.

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

6. Highlight the lines that you just typed and, on the Query menu, click Execute.
7. Now type these lines below the existing lines.

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

8. Highlight the lines that you just typed and, on the Query menu, click Execute.
It’s very possible that you will see an error stating that the schema in question already exists. This is not a problem.
9. Now type these lines below the existing lines.

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

10. Highlight the lines that you just typed and, on the Query menu, click Execute.

This could probably be combined to a simple script.

5.00 avg. rating (93% score) - 1 vote

About Peter Wibeck

Comments

5 Responses to “Change listener connetion error”

Trackbacks

Check out what others are saying about this post...
  1. NAV Change Listener is not always listening…..

    Since NAV 2009 RTC, live has become .. let's say .. more challenging regarding "installations"…

  2. […] Quite a similar blog from Peter Wibeck […]

  3. NAV Change Listener is not always listening…..

    Since NAV 2009 RTC, live has become .. let's say .. more challenging regarding "installations"…

  4. […] already quite some info out there to fix it: An MSDN article from Microsoft A blog of Saurav Dhyani Quite a similar blog from Peter Wibeck Of course also something on the Dynamics Team blog The one from the Team Blog is quite complete, […]



Speak Your Mind

Tell us what you're thinking...
and oh, if you want a pic to show with your comment, go get a gravatar!

*