NAV Server Service is Suddenly Stopped Every Day

johanna

Dear all,

I have installed NAV 2009 R2 Build 33319 with 3-tier architecture:
-Server 1 : Database server
-Server 2 : NAV server (middle server)
-Client

My NAV server service can be started successfully. I can run RTC successfully too. But, every 3:16 AM, my NAV server service is suddenly stopped.

This is the event viewer :
Type: Microsoft.Dynamics.Nav.Types.Exceptions.NavNCLChangeListenerConnectionFailedException
SuppressMessage: False
FatalityScope: None
Message: The Microsoft Dynamics NAV Server cannot connect the Change Listener to SQL Server because of the following error: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
StackTrace:
at Microsoft.Dynamics.Nav.Runtime.NavDatabaseChangeListener.SetupListener()
at Microsoft.Dynamics.Nav.Runtime.NavDatabaseChangeListener.TimerHandler(Object param)
Source: Microsoft.Dynamics.Nav.Ncl

Please help to solve this issue. Thank you very much.

sudhakarsv

My NAV server service can be started successfully. I can run RTC successfully too. But, every 3:16 AM, my NAV server service is suddenly stopped.

Is the issue is sorted after restarting NAV Server Service ? or still facing the same problem ?

johanna

Hi sudhakarsv,

Thanks for your response
I have restarted the NAV server service and got the same result..
Please help.. Thank you..

sudhakarsv

Please follow the below process
Walkthrough: Installing the Three Tiers on Three Computers
The below link will help you configuring the 3 tier architecture.
http://msdn.microsoft.com/en-us/library/dd301254.aspx

johanna

Thank sudhakarsv,

I have followed the step in the article you given..
Please help.. Thank u..

Peter_Wibeck_[MSFT]

Have you check that SQL server is up and running correct? Does NAV work again if you restart SQL server?

johanna

Thanks Peter,

I have check and found that SQL server is up and running correct. Yes, NAV work again if I restart SQL server..
NAV can run successfully. But, every morning the NAV server service is suddenly stopped.

skulla

Did you check the Recovery Options of Microsoft Dyanamics NAV Server service. You can get to it from Services --> Right click properties and there is a tab for Recovery.

johanna

Thanks Suresh Kulla

I have checked it and this is the result :
1. First Failure : Take No Action
2. Second Failure : Take No Action
3. Subsequent Failure : take No Action
4. Reset Fail Count After : 0 days
5. Enable actions for stop with errors : False (Unchecked)

Any suggestion ? Thank you.

MrJackal

Check that you can login to a server using the accounts used by all areas of your services ?

Thanks

johanna

Thank you MrJackal..

Yes, I can login to a server using the accounts used by all areas of my services..

David_Singleton

When there is some regular shut down of a service like this, very often it is because of backup or anti virus software. Take a look at those.

johanna

Thanks David..

I have checked and there is no antivirus software. What backup do you mean?
Thank you..

David_Singleton

johanna wrote:

Thanks David..

I have checked and there is no antivirus software. What backup do you mean?
Thank you..

Often the Administrator will have anti virus and/or backup software that runs at the server level (OS) it may try to scan or backup sql or the database, and not understanding what SQL is it will take it off line to perform the task. These days most software is SQL aware, but there are still programs out there that are not.

Speak with the site administrator and ask them

spider1269

Also check the event viewer on the SQL server to see if it's rebooting nightly. I've had systems where the dba would reboot the SQL server nightly.

-Jon

David_Singleton

spider1269 wrote:

Also check the event viewer on the SQL server to see if it's rebooting nightly. I've had systems where the dba would reboot the SQL server nightly.

-Jon

:thumbsup: