web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

The server "DynamicsNAV80" was unable to process the request. The application will now close.

(0) ShareShare
ReportReport
Posted on by

Hello everyone,

It is now two days I am trying to install my NAV 2015. Everything was fine for the last two years. Then, not sure why, I can't make it work.

1. The installation completes fine

2. Service is running fine

3. Management Studio can connect to the database without issues.

4. NAV repair "run as administrator" completes fine.

5. I tried re-installing multiple times, after uninstalling everything related to SQL, with removing registry keys, deleting NAV and SQL directories, reading related forums.

Again, after fresh complete install, when I am trying to open the application, I get "The server "DynamicsNAV80" was unable to process the request. The application will now close." error message.

I get two error messages in the Even Log, which are below. Please help!

Error #1

Server instance: DynamicsNAV80

User: **\***********

Type: System.InvalidOperationException

Message: Invalid operation. The connection is closed.

StackTrace:

at System.Data.SqlClient.SqlConnection.GetOpenConnection()

at System.Data.SqlClient.SqlConnection.BeginTransaction(IsolationLevel iso, String transactionName)

at Microsoft.Dynamics.Nav.Runtime.NavSqlConnection.ExecuteFunction[T](Func`1 function, NavSqlCommand command)

at Microsoft.Dynamics.Nav.Runtime.NavSqlConnection.ExecuteFunctionWithTrace[T](EventTask task, Func`1 function, NavSqlCommand command)

at Microsoft.Dynamics.Nav.Runtime.NavSqlConnection.BeginTransaction(IsolationLevel newIsolationLevel)

at Microsoft.Dynamics.Nav.Runtime.NavSqlConnectionScope..ctor(NavDatabase database, Boolean requireNewConnection, TransactionType transactionType, NavSqlConnection lastUsedSqlConnection)

at Microsoft.Dynamics.Nav.Runtime.NavSqlConnectionScope.Create(NavDatabase database, TransactionType transactionType, IReference`1& lastUsedSqlConnection)

at Microsoft.Dynamics.Nav.Runtime.NavUser.GetAllUsers(NavDatabase database)

at Microsoft.Dynamics.Nav.Runtime.NavUserCache.RefreshList()

at Microsoft.Dynamics.Nav.Runtime.NavUserCache.TryGetNavUser(Func`2 match, NavUser& user)

at Microsoft.Dynamics.Nav.Runtime.NavUserAuthentication.InternalAuthenticate()

at Microsoft.Dynamics.Nav.Runtime.NavUserAuthentication..ctor(NavTenant tenant, NavClientCredentialType credentialType, Object token)

at Microsoft.Dynamics.Nav.Service.NSServiceBase.ValidateAndCreateSession(ConnectionRequest connectionRequest, Boolean requireNavUser, Int32 newSessionId)

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

Source: System.Data

HResult: -2146233079

...................................

Error#2

Type: Microsoft.Dynamics.Nav.Client.NavClientClosingException

Fatal: False

ShowError: True

Message: The server "DynamicsNAV80" 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.StartWinFormsClient.RunCore()

Source: Microsoft.Dynamics.Nav.Client.WinClient

HResult: -2146233088

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

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

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

StackTrace:

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

at Microsoft.Dynamics.Nav.Client.ConnectionEstablisher.OpenConnection(ConnectionRequest connectionRequest, 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.ServiceConnection

HResult: -2146233088

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

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

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

HResult: -2146233088

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

Type: System.InvalidOperationException

Message: Invalid operation. The connection is closed.

StackTrace:

at System.Data.SqlClient.SqlConnection.GetOpenConnection()

at System.Data.SqlClient.SqlConnection.BeginTransaction(IsolationLevel iso, String transactionName)

at Microsoft.Dynamics.Nav.Runtime.NavSqlConnection.ExecuteFunction[T](Func`1 function, NavSqlCommand command)

at Microsoft.Dynamics.Nav.Runtime.NavSqlConnection.ExecuteFunctionWithTrace[T](EventTask task, Func`1 function, NavSqlCommand command)

at Microsoft.Dynamics.Nav.Runtime.NavSqlConnection.BeginTransaction(IsolationLevel newIsolationLevel)

at Microsoft.Dynamics.Nav.Runtime.NavSqlConnectionScope..ctor(NavDatabase database, Boolean requireNewConnection, TransactionType transactionType, NavSqlConnection lastUsedSqlConnection)

at Microsoft.Dynamics.Nav.Runtime.NavSqlConnectionScope.Create(NavDatabase database, TransactionType transactionType, IReference`1& lastUsedSqlConnection)

at Microsoft.Dynamics.Nav.Runtime.NavUser.GetAllUsers(NavDatabase database)

at Microsoft.Dynamics.Nav.Runtime.NavUserCache.RefreshList()

at Microsoft.Dynamics.Nav.Runtime.NavUserCache.TryGetNavUser(Func`2 match, NavUser& user)

at Microsoft.Dynamics.Nav.Runtime.NavUserAuthentication.InternalAuthenticate()

at Microsoft.Dynamics.Nav.Runtime.NavUserAuthentication..ctor(NavTenant tenant, NavClientCredentialType credentialType, Object token)

at Microsoft.Dynamics.Nav.Service.NSServiceBase.ValidateAndCreateSession(ConnectionRequest connectionRequest, Boolean requireNavUser, Int32 newSessionId)

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

Source: System.Data

HResult: -2146233079

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Jens Glathe Profile Picture
    6,092 on at

    Hi,

    does the user (of the service tier service) have dbowner rights on the database?

    with best regards

    Jens

  • Community Member Profile Picture
    on at

    Hi Jens.

    Hope you are doing well!

    Yes, it has DBOWNER rights. Thanks.

    Tigran

  • Suggested answer
    keoma Profile Picture
    32,729 on at

    does the nav service user has the permission "run as service"?

    where there changes in the AD (active directory)?

    remove the complete installation, then install with demo option. check, if that works.

  • mmv Profile Picture
    11,471 on at

    Hi,

    Please check Login Account on the NAV instance and check whether it has the appropriate permission in the SQL.

  • Verified answer
    Community Member Profile Picture
    on at

    Thanks for your answers!!

    To resolve the issue, I did another complete uninstallation and installed SQL Server Standard.

    The SQL Service was still having issues and wasn't running properly (would stop after 5-10 seconds).

    What resolved the issue is changing the SQL Server Service Log-On to Local System Account.

    Regards,

    Tigran

  • Dilanka H. Profile Picture
    116 on at

    Hi Tigran,

    This may not be your case but I'd express it here since the thread is related.

    I am having this issue for several NAV instances which are from several NAV versions and builds. Honestly speaking I am using SQL Queries to add my user to those DBs (which are duplicated from live clients) which violates NST's (NAV Service Tier) default user credential type where the client server was using. It's the easiest method rather than installing self-signed certificates each and every time I have work with a new client.

    I have observed that only the clients who didn't had NST Credential Type as Windows (which is the one I added to the Users Table by-force) opted this error. Simple re-open did the trick but it kept coming whenever I restarted the service. In order to verify that I have changed about two clients with self-signed certificated user credentials (which is the correct way) and woala it worked as a charm. I hope that's the permanent solution rather than using shortcuts.

    If I am wrong please enlighten me. This is only based on my experimentation.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
HoangNam Profile Picture

HoangNam 7

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans