Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

NAV2016 Installation & Configuration

Posted on by 1,112

Dear Sir,

I've installed NAV 2016 (All the Tiers in a Single PC) successfully in a single stand computer,but when I try to access the database thru RTC, it's showing the below error message...


Microsoft Dynamics NAV
The server "DynamicsNAV90" was unable to process the request. The application will close.
OK



And When I restart the NAV service, the below warning message is found in the Event Viewer..

DynamicsNAV90
The service could not add service principal names because the service account could not be found in Active Directory.
Account: NT AUTHORITY\NETWORK SERVICE
Service principal names:
DynamicsNAV/PC:7046
DynamicsNAV/PC:7046


Service is running bt the account NT AUTHORITY\NETWORK SERVICE with having enough privileged in SQL Server as well as the DB.

Kindly help me to solve this issue.

Thanks & regards,

Subrata

*This post is locked for comments

  • Javier Blanco Profile Picture
    Javier Blanco 5 on at
    RE: NAV2016 Installation & Configuration

    This issue is also present on my PC. I installed one of the recent big windows update last week. My NAV service is up and running from the NAV Administrator Tool, however, I am not able to connect to the RTC due to the following error: Cannot establish a connection to the SQL Server/Database. This could be caused by one of the following reasons: * The SQL server is not started. * The database does not exist. * Proper permissions have not been given to the NAV Server Account.

    I have  noticed that when I start the service the below message is displayed:

    - The service could not add service principal names because the service account could not be found in Active Directory. Account: Domain\xxx.xxx

    - Cannot open database "db_name" requested by the login. The login failed. Login failed for user 'Domain\xxx.xxx'

    This service was working correctly before the Windows Update.

    The service status is running however the connection to the database can not be establish. I have also changed Service Account to a local account and either work. 

    Is there any solution for this error?

    Thank you,

  • Suggested answer
    santhanak Profile Picture
    santhanak 360 on at
    RE: NAV2016 Installation & Configuration

    Hi Subrata,

    If Service is working, then try running the development environment and try to run the Chart of account page (it will open up RTC) or atleast throws an error with Select server page. Check you have valid path of Servername:7046/Instance name (Dynamics90).  if this works then change your custom config file

    thanks

    Santhana

  • PhilDOakley Profile Picture
    PhilDOakley 222 on at
    RE: NAV2016 Installation & Configuration

    Preben Borg it is not possible to run the sync process if the service tier will not start

  • subrata.bauri Profile Picture
    subrata.bauri 1,112 on at
    RE: NAV2016 Installation & Configuration

    @Preben Borg

    Service is running, but client(RTC) unable to connect the DB.

  • ManishS Profile Picture
    ManishS 6,578 on at
    RE: NAV2016 Installation & Configuration

    Agreed Perben, but I tried that also.

    Previously it was working fine, few days back windows update happened, after that it is not starting.

    For this problem there is no solution till available.

    Only solution is to format the System and do a fresh installation till it works.

  • Preben Borg Profile Picture
    Preben Borg 80 on at
    RE: NAV2016 Installation & Configuration

    @Manish Sharma conflicting Port no's was my initial response. This has nothing to do with being on domain. But I cannot see that anyone has got the solution yet.  On a standalone full servicetier installation conflicting port no. is the most typical mistake (multiple versions installed).

    I suspect that this is a typically demo database installation (I cannot see anything about witch database is in use and where it is installed). So try to Sync and Compile database objects - but remember "Run as Administrator" on startup of the development client - this is also weak OS spot (meaning poor user notification of missing permissions witch goes back to UAC introduction into Win-OS)     

  • ManishS Profile Picture
    ManishS 6,578 on at
    RE: NAV2016 Installation & Configuration

    Type: Microsoft.Dynamics.Nav.Client.NavClientClosingException

    Fatal: False

    ShowError: True

    Message: The server "XXXX" was unable to process the request. The application will close.

    StackTrace:

        at Microsoft.Dynamics.Nav.Client.WinClient.ExceptionHandler.DoExecute(Func`1 execute)

        at Microsoft.Dynamics.Nav.Client.WinClient.ExceptionHandler.DoRethrowWithCatchException(Exception exception, Boolean designMode)

        at Microsoft.Dynamics.Nav.Client.WinClient.ExceptionHandler.DoHandleThreadException(Exception exception, Boolean designMode)

        at Microsoft.Dynamics.Nav.Client.WinClient.ExceptionHandler.WinFormsDispatcherUnhandledException(Object sender, DispatcherUnhandledExceptionEventArgs eventArgs)

        at Microsoft.Dynamics.Framework.UI.WinForms.WinFormsDispatcher.HandleDispatcherException(Object sender, Exception e)

        at Microsoft.Dynamics.Framework.UI.WinForms.WinFormsDispatcher.OnThreadException(Object sender, ThreadExceptionEventArgs eventArgs)

        at System.Windows.Forms.Application.ThreadContext.OnThreadException(Exception t)

        at System.Windows.Forms.Application.ThreadContext.PreTranslateMessage(MSG& msg)

        at System.Windows.Forms.Application.ThreadContext.System.Windows.Forms.UnsafeNativeMethods.IMsoComponent.FPreTranslateMessage(MSG& msg)

        at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)

        at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)

        at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)

        at System.Windows.Forms.Application.RunDialog(Form form)

        at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)

        at System.Windows.Forms.Form.ShowDialog()

        at Microsoft.Dynamics.Framework.UI.WinForms.Controls.BusinessForm.ShowDialog(Form form, IWin32Window owner)

        at Microsoft.Dynamics.Nav.Client.NavWinFormsChangeServiceTierProvider.OpenChangeServiceTierPage(UISession uiSession, IService service)

        at Microsoft.Dynamics.Nav.Client.ConnectionStateListener.ConnectFailed(Object sender, ConnectFailedEventArgs e)

        at System.EventHandler`1.Invoke(Object sender, TEventArgs e)

        at Microsoft.Dynamics.Nav.Client.ConnectionEstablisher.ConfirmOpenConnectionRetry(ConnectFailedEventArgs connectFailedArgs, Exception exception)

        at Microsoft.Dynamics.Nav.Client.ConnectionEstablisher.TestSpnSettings(ConnectFailedEventArgs connectFailedArgs)

        at Microsoft.Dynamics.Nav.Client.ConnectionEstablisher.OpenConnection[TChannel](ConnectionRequest connectionRequest, ConnectionOptions connectionOptions, UserSettings& userSettings)

        at Microsoft.Dynamics.Nav.Client.ServiceConnection.OpenConnection()

        at Microsoft.Dynamics.Nav.Client.ServiceConnection.Initialize()

        at Microsoft.Dynamics.Nav.Client.FormBuilder.BuilderSessionInitializer.InitializeService(IService service)

        at Microsoft.Dynamics.Nav.Client.FormBuilder.BuilderSessionInitializer.OpenConnectionToServer()

        at Microsoft.Dynamics.Nav.Client.WinClient.NavWinFormsClientSession.OpenServerConnectionCore()

        at Microsoft.Dynamics.Nav.Client.WinClient.NavWinFormsClientSession.OpenServerConnectionWithOneLoginAttempt()

        at Microsoft.Dynamics.Nav.Client.WinClient.NavWinFormsClientSession.InitializeUISession()

        at Microsoft.Dynamics.Framework.UI.Windows.ClientSessionBase.SetupSessions()

        at Microsoft.Dynamics.Framework.UI.Windows.ClientSessionBase.InitCore()

        at Microsoft.Dynamics.Nav.Client.WinClient.NavWinFormsClientSession.InitCore()

        at Microsoft.Dynamics.Framework.UI.ClientSessionCore.Init()

        at Microsoft.Dynamics.Framework.UI.Windows.ClientSessionBase.Run()

        at Microsoft.Dynamics.Nav.Client.WinClient.NavClientErrorHandler.ExecuteAndCatchExceptions(Func`1 execute)

    Source: Microsoft.Dynamics.Nav.Client.WinClient

    HResult: -2146233088

    ----------------------------------

    Type: Microsoft.Dynamics.Nav.Types.Exceptions.NavServerSessionException

    Message: The server "XXXX" was unable to process the request. The application will close.

    StackTrace:

        at Microsoft.Dynamics.Nav.Client.WinClient.ExceptionHandler.<>c__DisplayClass6.<DoRethrowWithCatchException>b__4()

        at Microsoft.Dynamics.Nav.Client.WinClient.NavClientErrorHandler.ExecuteAndCatchExceptions(Func`1 execute)

    Source: Microsoft.Dynamics.Nav.Client.WinClient

    HResult: -2146233088

    ----------------------------------

    Type: Microsoft.Dynamics.Nav.Types.Exceptions.NavServerSessionException

    Message: The server "XXXX" was unable to process the request. The application will close.

    StackTrace:

        at Microsoft.Dynamics.Nav.Client.ConnectionEstablisher.OpenConnection[TChannel](ConnectFailedEventArgs connectFailedArgs, ConnectionRequest connectionRequest, ConnectionOptions connectionOptions, SpnSetting spnSettingToTry, Boolean allowSpnSettingsSwap, UserSettings& userSettings)

        at Microsoft.Dynamics.Nav.Client.ConnectionEstablisher.OpenConnection[TChannel](ConnectionRequest connectionRequest, ConnectionOptions connectionOptions, UserSettings& userSettings)

        at Microsoft.Dynamics.Nav.Client.ServiceConnection.OpenConnection()

        at Microsoft.Dynamics.Nav.Client.ChangeServiceInstanceManager.Connect(ICredentialProvider credentialProvider)

        at Microsoft.Dynamics.Nav.Client.ChangeServiceInstanceManager.Connect(String serverAddress, ICredentialProvider credentialProvider)

        at Microsoft.Dynamics.Nav.Client.Forms.ChangeServiceTierForm.RetrieveCompaniesList()

        at Microsoft.Dynamics.Nav.Client.Forms.ChangeServiceTierForm.ProcessCmdKey(Message& msg, Keys keyData)

        at System.Windows.Forms.Control.ProcessCmdKey(Message& msg, Keys keyData)

        at Microsoft.Dynamics.Framework.UI.WinForms.Controls.DirectionalLayoutPanel.ProcessCmdKey(Message& msg, Keys keyData)

        at System.Windows.Forms.Control.ProcessCmdKey(Message& msg, Keys keyData)

        at Microsoft.Dynamics.Framework.UI.WinForms.Controls.DirectionalLayoutPanel.ProcessCmdKey(Message& msg, Keys keyData)

        at System.Windows.Forms.Control.ProcessCmdKey(Message& msg, Keys keyData)

        at Microsoft.Dynamics.Framework.UI.WinForms.Controls.DirectionalLayoutPanel.ProcessCmdKey(Message& msg, Keys keyData)

        at System.Windows.Forms.Control.ProcessCmdKey(Message& msg, Keys keyData)

        at System.Windows.Forms.Control.PreProcessMessage(Message& msg)

        at System.Windows.Forms.Control.PreProcessControlMessageInternal(Control target, Message& msg)

        at System.Windows.Forms.Application.ThreadContext.PreTranslateMessage(MSG& msg)

    Source: Microsoft.Dynamics.Nav.Client.ServiceConnection

    HResult: -2146233088

    ----------------------------------

    Type: Microsoft.Dynamics.Nav.Types.Exceptions.NavServerSessionException

    Message: The server "XXXX" was unable to process the request. The application will close.

    HResult: -2146233088

    ----------------------------------

    Type: System.BadImageFormatException

    Message: An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B)

    StackTrace:

        at Microsoft.Dynamics.Nav.Runtime.NavLicense.NativeMethods.UnpackLicense(Byte[] license, Int32 licenseSize, StringBuilder header, Int32 headerSize)

        at Microsoft.Dynamics.Nav.Runtime.NavLicense.Create(Byte[] license, LicenseExpiredHandler licenseExpiredHandler)

        at Microsoft.Dynamics.Nav.Runtime.NavDatabaseSecurityAndLicense.get_License()

        at Microsoft.Dynamics.Nav.Runtime.NavSession.get_License()

        at Microsoft.Dynamics.Nav.Runtime.NavSession.GetAllCompanies(Boolean useSecurityFilter)

        at Microsoft.Dynamics.Nav.Runtime.NavSession.GetAllowedCompanies()

        at Microsoft.Dynamics.Nav.Runtime.NavSession.GetPersonalization()

        at Microsoft.Dynamics.Nav.Runtime.NavSession.Open(Boolean useUserPersonalization, Byte[] licenseToUse)

        at Microsoft.Dynamics.Nav.Service.NSService.OpenConnection(ConnectionRequest connectionRequest)

        at SyncInvokeOpenConnection(Object , Object[] , Object[] )

        at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs)

        at Microsoft.Dynamics.Nav.Service.ServiceOperationInvoker.ErrorMappingCombinator(ServiceOperation innerOperation, NSServiceBase serviceInstance, Object[] inputs, Object[]& outputs)

    Source: Microsoft.Dynamics.Nav.Ncl

    HResult: -2147024885

  • Suggested answer
    RockwithNav Profile Picture
    RockwithNav 6,562 on at
    RE: NAV2016 Installation & Configuration

    And what's logged there in Event Viewer??

  • ManishS Profile Picture
    ManishS 6,578 on at
    RE: NAV2016 Installation & Configuration

    @Preben Borg, if the Computer is not in domain then how do you go with it.

  • Suggested answer
    Preben Borg Profile Picture
    Preben Borg 80 on at
    RE: NAV2016 Installation & Configuration

    The behavior sounds like conflicting port no.'s. You typically get this error when you try to install and start new NST instance and you forget to set new port no's.

    Else I would look for the SPN Provisioning the Microsoft Dynamics NAV Server Account:

    msdn.microsoft.com/.../hh166150(v=nav.90).aspx  

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans