Changes don't appear in Nav RTC with query notification

PureHeart

Hi guys I've opened a new post continuing this one viewtopic.php?f=32&t=31338
that has been marked as solved...
My problem is that i cannot see the changes applyed to object without restarting the NAV server if I have enabled the query notification...
I can see this error message in the event application log:

"An exception occurred while enqueueing a message in the target queue. Error: 15404, State: 19. Could not obtain information about Windows NT group/user 'NT AUTHORITY\NETWORK SERVICE', error code 0x54b."

but I don't really know how to fix it!!!!
Help please!!!
p.s.
I'm testing this feature even If I don't know what it really changes enabling query notification anyone could explain?

THANKS

kine

Ad the query notification: se e.g. this: http://www.simple-talk.com/sql/sql-serv ... ification/

PureHeart

Thanks Kine!
I'm going to read that all now!

kine

PureHeart wrote:

Thanks Kine!
I'm going to read that all now!
p.s.
on another matter your NAV 2009 Management application is very nice but on my machine crash as soon as I open it?do you want the error message?

Try to download the newer version from my blog...

PureHeart

Ok I've read it all but I can't see what I am missing... this is the result querying exec sp_helprotect NULL, [NT AUTHORITY\NETWORK SERVICE] on my db...

dbo Object Tracking NT AUTHORITY\NETWORK SERVICE dbo Grant Select (All+New)
dbo QueryNotificationErrorsQueue NT AUTHORITY\NETWORK SERVICE dbo Grant RECEIVE .
. . NT AUTHORITY\NETWORK SERVICE dbo Grant CONNECT .
. . NT AUTHORITY\NETWORK SERVICE dbo Grant Create Procedure .
. . NT AUTHORITY\NETWORK SERVICE dbo Grant CREATE QUEUE .
. . NT AUTHORITY\NETWORK SERVICE dbo Grant CREATE SERVICE .
. . NT AUTHORITY\NETWORK SERVICE dbo Grant SUBSCRIBE QUERY NOTIFICATIONS .
. . NT AUTHORITY\NETWORK SERVICE dbo Grant VIEW DEFINITION .

Everything that should be there is there...Any Idea of what is missing? Does it matter that I am using SQL 2008 Express?
I'm keeing having this error on the event log:

The activated proc '[$ndo$navlistener].[SqlQueryNotificationStoredProcedure-cf0a3d07-3039-4421-a494-4308418de5e9]' running on queue 'Demo Nav 2009.$ndo$navlistener.SqlQueryNotificationService-cf0a3d07-3039-4421-a494-4308418de5e9' output the following: 'Could not obtain information about Windows NT group/user 'NT AUTHORITY\NETWORK SERVICE', error code 0x54b.'

Thanks

PureHeart

Could it be that if the NAV server service uses as logon [NT AUTHORITY\NETWORK SERVICE] then you can't use the query notifications?
Can someone please help?
I'm running SQL 2008 Express as LocalSystem and my pc is part of a domain....does that matter?

THANKS ](*,)

dmccrae

Query Notifications will work with the NAV Server using NETWORK SERVICE so that is not the issue.

Have you tried changing the account of your SQL Express service to something other than LocalSystem? Perhaps NETWORK SERVICE or a domain account. The error does not indicate a missing SQL permission but the inability to lookup the NETWORK SERVICE account for that machine.

Are you running the NAV Server and SQL Server on the same machine?

PureHeart

dmccrae wrote:

Query Notifications will work with the NAV Server using NETWORK SERVICE so that is not the issue.

Have you tried changing the account of your SQL Express service to something other than LocalSystem? Perhaps NETWORK SERVICE or a domain account. The error does not indicate a missing SQL permission but the inability to lookup the NETWORK SERVICE account for that machine.

Are you running the NAV Server and SQL Server on the same machine?

Same machine, Yes I understand that and I had already tried to change the SQL logon to the network service and also I've tried using my domain account!
but nothing has changed.... any help?

PureHeart

If I try to run this Query:

EXECUTE AS USER = 'NT AUTHORITY\NETWORK SERVICE'

I get the same error.... Any Ideas?
Am I the only one with this Problem????