Proper Setup Navision 2013 R2

JodelPascual
JodelPascual Member Posts: 5
in NAV Three Tier
Hello NAV Users,

Im currently trying to setup Navision 2013 R2 Three Tier Architecture.
Credentials setup is NavUserPassword

When im doing this credentials in Two Tier Archi, the NAV is working, but when im trying to do the three tier
navision can't connect.

My Question, what is the proper setup for NAV 2013 R2 using three tier and NavUserPassword?

Please help me guys!

Thanks!

Jodel Pascual

Answers

  • defiant701
    defiant701 Member Posts: 79
    That does not sound necessarily like a setup fault for NavUserPassword. Do you get any error message? You'll find also general information on this link: https://msdn.microsoft.com/en-us/library/dd301130(v=nav.70).aspx
    Debuggers don't remove bugs, they only show them in slow-motion

    LinkedIn
    XING
  • JodelPascual
    JodelPascual Member Posts: 5
    defiant701 wrote: »
    That does not sound necessarily like a setup fault for NavUserPassword. Do you get any error message? You'll find also general information on this link: https://msdn.microsoft.com/en-us/library/dd301130(v=nav.70).aspx

    Im using NAV 2013 R2, and setup has no AD.

    What would be the proper setup?

    Thanks Defiant
  • JodelPascual
    JodelPascual Member Posts: 5
    This is from Event viewer:

    Server instance: DynamicsNAV71 User: Type: Microsoft.Dynamics.Nav.Types.Exceptions.NavCSideException Remappable: True ErrorCode: 22924076 ErrorNumber: 52012 ModuleNumber: 93 SuppressMessage: False SuppressExceptionCreatedEvent: False FatalityScope: None Message: 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. Try again later or contact your system administrator. StackTrace: at Microsoft.Dynamics.Nav.Runtime.NavSqlConnection.OpenConnection() 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, NavSqlConnection& lastUsedSqlConnection) at Microsoft.Dynamics.Nav.Runtime.NavSqlMetadataCommands.TableExists(NavDatabase database, String tableName) at Microsoft.Dynamics.Nav.Runtime.NavSqlDatabaseProperties.ReadDatabasePropertiesIfNotAlreadyRead() at Microsoft.Dynamics.Nav.Runtime.NavSqlDatabaseProperties.CheckDatabaseVersion() at Microsoft.Dynamics.Nav.Runtime.NavDatabase.TryVerifyConnection(Int32 attemptCount, String& errorMessage) Source: Microsoft.Dynamics.Nav.Ncl HResult: -2146233088

    Server instance: DynamicsNAV71 Fatal Sql error. The connection can no longer be used

    Server instance: DynamicsNAV71 User: Type: System.Data.SqlClient.SqlException ClientConnectionId: 89329d87-ad1b-4395-b1e4-11ba3772d0a6 Class: 14 LineNumber: 65536 Number: 18456 Server: NAVAPP State: 1 Source: .Net SqlClient Data Provider ErrorCode: -2146232060 Message: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. StackTrace: at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean withFailover) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.Dynamics.Nav.Runtime.NavSqlConnection.ExecuteAction(Action action, NavSqlCommand command) HResult: -2146232060

Categories