NAV 2009 error please help me

Hi All,

Okay what i do i show you.

Following is the recommendations from official document:

Enabling the Object Change Listener

The Object Change Listener (OCL) component of Microsoft Dynamics NAV Server monitors the database for changes that are made to application objects, such as adding a new field to a page. When the OCL detects that a change has been made to an application object, it flushes the application object from the server-side cache, which causes clients to get a newer version from the database. OCL requires that the SQL Service Broker is enabled and that Microsoft Dynamics NAV Server has permissions to the SQL Server database. If OCL cannot start because of permissions errors, then you cannot connect any clients to the server.

For certain installation configurations, you must manually enable OCL. In addition, for all installation configurations, you can optionally enable query notification to improve performance. The following table explains the configuration options.

Account choice Microsoft Dynamics NAV Server and database on same computer Microsoft Dynamics NAV Server and database on different computers


Network Service account


- No additional configuration is required.


- You can optionally enable query notification to improve performance.



- OCL configuration is required.


- You can optionally enable query notification to improve performance.


- In the following procedures, specify YourNAVServerMachineName\Network Service for ReplaceWithNAVServerAccount.




Domain user account


- OCL configuration is required.


- You can optionally enable query notification to improve performance.


- In the following procedures, specify the domain user account for ReplaceWithNAVServerAccount.



- OCL configuration is required.


- You can optionally enable query notification to improve performance.


- In the following procedures, specify the domain user account for ReplaceWithNAVServerAccount.


To enable and assign minimum permissions for the Object Change Listener

  1. Open SQL Server Management Studio and 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.

    CREATE LOGIN [*ReplaceWithNAVServerAccount*] FROM WINDOWS;
    CREATE USER [*ReplaceWithNAVServerAccount*] FOR LOGIN [*ReplaceWithNAVServerAccount*];
    CREATE SCHEMA [$ndo$navlistener] AUTHORIZATION [*ReplaceWithNAVServerAccount*];
    ALTER USER [*ReplaceWithNAVServerAccount*] WITH DEFAULT_SCHEMA = [$ndo$navlistener];
    GRANT SELECT ON [*ReplaceWithYourDatabaseName*].[**Object Tracking**] TO [*ReplaceWithNAVServerAccount*];
    GO
    
    Note


    The Object Tracking table name may be a different language than English. You must specify the actual name that is used in your database.

  4. On the Query menu, click Execute.

To enable query notification for the Object Change Listener

  1. Open SQL Server Management Studio.

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

  3. Type the following SQL statements:

    ALTER DATABASE [*ReplaceWithYourDatabaseName*] SET ENABLE_BROKER;
    GRANT CREATE PROCEDURE TO [*ReplaceWithNAVServerAccount*];
    GRANT CREATE QUEUE TO [*ReplaceWithNAVServerAccount*];
    GRANT CREATE SERVICE TO [*ReplaceWithNAVServerAccount*];
    GRANT VIEW DEFINITION TO [*ReplaceWithNAVServerAccount*];
    GRANT SUBSCRIBE QUERY NOTIFICATIONS TO [*ReplaceWithNAVServerAccount*];
    GRANT RECEIVE ON QueryNotificationErrorsQueue TO [*ReplaceWithNAVServerAccount*];
    GRANT REFERENCES ON CONTRACT::[http://schemas.microsoft.com/SQL/Notifications/PostQueryNotification] TO [*ReplaceWithNAVServerAccount*];
    GO
    
  4. On the Query menu, click Execute.

Please see nav_install.chm file in the Documentation folder of NAV2009 Installation DVD.

Pink;

In last screenshot of your post is err message, where one of possible causes is “SQL Server doesn’t allow remote connections”.
To check this, from SQL Management Studio:

right-click on your servername in Obj.Manager, choose Properties, then page Connections - and look if Allow remote conns to this server is checked…

Upon installing SQLServer, default setting is NOT allowing remote access as security issue. That means, you can connect to SQL ONLY from the same PC, even through TCP/IP protocol, but not over the network - what is needed For Navision Client on another PC to connect.

Thank u all. your reply very helpfully for me.

Regards PNK