net.tcp://localhost:7046/DynamicsNav/Service

DHendriksen

Hi all,

There are some more topics about net.tcp errors, but none of these solutions is the correct one for me.

After starting the RTC it takes about 10 seconds and then the error below occures:
'The server net.[url=tcp://localhost:7046/DynamicsNav/Service]tcp://localhost:7046/DynamicsNav/Service[/url] will be shut down. The client will be closed.'
(I run a Dutch OS, so the error is translated by myself into English )
But what is the reason for this error?

- It's the default Cronus SQL database running on SQL server 2008.
- I can access the database by windows logon in the calssic SQL client, but also in the RTC (but in the RTC an erroro occures after 10 seconds)
- On SQL I do have DBO owner rights on the database, and I do have the sysadmin server role.
- The Extended stored procedures are available, and I read a topic about the permission on the 2 procedures, these settings are correct (execute on public)
- I can also access i.e. NAV4 databases on this SQL server by windows logon.
- The trace flag 4616 is also set.
- The Microsoft Dynamics NAV Server service is running.

After the RTC is closed the messages below are in the Event viewer;

Message 1:
SQL Query Notifications are unavailable on SQL Server 'LT-CONDOR-DH\SQL2008DH' in Database 'Demo Database NAV (6-0)'. The Object Change Listener has switched to polling.
Message 2:
Object Change Listener is listening on SQL Server 'LT-CONDOR-DH\SQL2008DH' in Database 'Demo Database NAV (6-0)'.
Error:
The SELECT permission was denied on the object 'Object Tracking', database 'Demo Database NAV (6-0)', schema 'dbo'.


Does anybody have any idea. I'm lost now!!!

Thanks in advance

manisharma31

hey,check these..

viewtopic.php?t=37249

http://msdn.microsoft.com/en-us/library/dd301254.aspx

DHendriksen

Hi manisharma31,

It wasn't that easy, but you helped me with your suggestions, because I didn't found these topics.

But when I wanted to delete the user I got a strange error about a schema dat couldn't be deleted. What the hack.... After some trying and trying and more trying it all worked. My RTC is working and I can run a page or report 'stand alone'.

Thanks again!

Regards,
Don

Elber

So how did you solve this issue?

Thx in advance!

Elber

Or can somebody help me to resolve issue :bug: listed above? :thumbsup:

krasi_varna_77

Hi,
look at permission of Account which start Nav Service. These acount must right to the databse too