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
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,
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
Preben Borg it is not possible to run the sync process if the service tier will not start
Service is running, but client(RTC) unable to connect the DB.
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.
@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)
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
And what's logged there in Event Viewer??
@Preben Borg, if the Computer is not in domain then how do you go with it.
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:
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156