Error The user ID and password are invalid. (3 Tier)

tonypang

Below is the error message when run in 3 tier. Hope master can help me. Thanks

Type: Microsoft.Dynamics.Nav.Types.NavClientTerminatingException
Message: The user ID and password are invalid. Try again.
StackTrace:
at Microsoft.Dynamics.Nav.Client.ConnectionStateListener.HandleConnectErrors(Exception ex, ConnectionStateNotificationBase notification)
at Microsoft.Dynamics.Nav.Client.FormBuilder.BuilderSession.InitializeCore()
at Microsoft.Dynamics.Nav.Client.FormBuilder.BuilderSession.Initialize()
at Microsoft.Dynamics.Framework.UI.UISession.Initialize()
at Microsoft.Dynamics.Framework.UI.Windows.ClientSessionBase.SetupUISession()
at Microsoft.Dynamics.Framework.UI.Windows.ClientSessionBase.Init()
at Microsoft.Dynamics.Nav.Client.WinClient.RunCore()
at Microsoft.Dynamics.Nav.Client.ExceptionHandler.ExecuteAndCatchExceptions(Func`1 execute)
Source: Microsoft.Dynamics.Nav.Client.UI

---

Type: Microsoft.Dynamics.Nav.Types.Exceptions.NavSCOpenConnectionException
SuppressMessage: False
FatalityScope: None
Message: The user ID and password are invalid. Try again.
StackTrace:
at Microsoft.Dynamics.Nav.Client.ServiceConnection.OpenConnection()
at Microsoft.Dynamics.Nav.Client.FormBuilder.BuilderSession.InitializeCore()
Source: Microsoft.Dynamics.Nav.Client.ServiceConnection

---

Type: Microsoft.Dynamics.Nav.Types.NavDatabasePasswordException
SuppressMessage: False
FatalityScope: None
Message: The user ID and password are invalid. Try again.
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()
Source: Microsoft.Dynamics.Nav.Client.ServiceConnection

---

Type: Microsoft.Dynamics.Nav.Types.NavDatabasePasswordException
SuppressMessage: False
FatalityScope: None
Message: The user ID and password are invalid. Try again.
StackTrace:
at Microsoft.Dynamics.Nav.Runtime.NavRuntimeAdapter.ErrorHandler(Int32 errorCode, Int32 errorNumber, Int32 moduleNumber, String errorText)
at Microsoft.Dynamics.Nav.Runtime.NativeMethods.AdapterOpenConnection(IntPtr databaseHandle, String serverName, NetProtocolType netType, String databaseName, Int32 clientConnectionType, DeadConnectionHandler deadConnectionHandler, String userTempDirectory, Printer[] printers, Int32 numberOfPrinters)
at Microsoft.Dynamics.Nav.Runtime.NavRuntimeAdapter.OpenConnection(IntPtr databaseHandle, NetProtocolType netType, String serverName, String databaseName, Int32 clientConnectionType, DeadConnectionHandler deadConnectionHandler, String userTempDirectory, Printer[] printers)
at Microsoft.Dynamics.Nav.Runtime.NavConnection.Open(Boolean useUserPersonalization)
at Microsoft.Dynamics.Nav.Runtime.NavConnection.Open()
at Microsoft.Dynamics.Nav.Service.NSService.<>c__DisplayClass4.<OpenConnection>b__2(Connection connection)
at Microsoft.Dynamics.Nav.Service.NSService.ExecuteOperation[T](String operationName, ServiceOperation`1 operation, Connection connection, Boolean revertLanguageChanges, WindowsIdentity impersonationIdentity)
Source: Microsoft.Dynamics.Nav.Ncl

mohana_cse06

Did you setup proper Windows Authentications?

kine

1) Correct authentication must be used (Kerberos or NTLM)
2) Delegation must be working correctly (check this article: http://feedproxy.google.com/~r/Microsof ... shell.aspx)

tonypang

In the service Tier when i run RTC is worked ? but when i run from Client machine is prompt me the error message.
I already follow all the step, but still error. Do you have method how to trouble shooting ?
"NAV 3-tier troubleshooting with PowerShell" method i already try out but still the same.
Hope the master here give me some guideline.

thanks

mohana_cse06

You can try with this tool
http://dynamicsuser.net/media/p/192857.aspx

You didnt answer to my question that did you setup Windows Authentication?

kine

Than yould you send the reslts gathered by the tool? If it is working from the machine itself and not from another, than the issue is delegation... or wrong authentication method...

tonypang

Hello mohana_cse06 i got set it up windows Authentication but still get the error message.

tonypang

Hello kine,
Below is the result gathered by tools
Hope you can correct be if my setting is wrong.
thanks

Administrator.txt

name : {Administrator}
UserAccountControl : {66048}
SAMAccountName : {Administrator}
msDS-AllowedToDelegateTo : {MSSQLSvc/192.168.1.66:1433}
objectCategory : {CN=Person,CN=Schema,CN=Configuration,DC=aisbdomain,
DC=com}

Administrator.txtSPN.txt
Registered ServicePrincipalNames for CN=Administrator,CN=Users,DC=aisbdomain,DC=com:
MSSQLSvc/AI-DBSERVER
MSSQLSvc/AI-DBSERVER:1433
MSSQLSvc/AI-DBSERVER.aisbdoamin
MSSQLSvc/AI-DBSERVER.aisbdoamin:1433
MSSQLSvc/AI-DBSERVER.aisbdomain.com:1433
MSSQLSvc/AI-DBSERVER.aisbdomain.com
MSSQLSvc/192.168.1.66:1433
MSSQLSvc/192.168.1.66.aisbdomain
http://AI-WSServer.AISBDOMAIN.com:7067
DynamicsNAV/AI-WSServer.AISBDOMAIN.com:7067
http/AI-WSServer.AISBDOMAIN.com
http/AI-WSServer
http/AISBDOMAINPC.AISBDOMAIN.com:7046
DynamicsNAV/AISBDOMAINPC.AISBDOMAIN.com:7047
DynamicsNAV/AISBDOMAINPC.AISBDOMAIN.com:7046
MSSQLSvc/AI-DBSERVER.AISBDOMAIN.DEMO Malaysia Sdn. Bhd. (R2).com:1433

navservice.txt
name : {NAVSERVICE}
UserAccountControl : {17367552}
SAMAccountName : {navservice}
msDS-AllowedToDelegateTo : {DynamicsNAV/192.168.1.77:7096, DynamicsNAV/192.168.
1.77.aisbdomain:7096}
objectCategory : {CN=Person,CN=Schema,CN=Configuration,DC=aisbdomain,
DC=com}


navservice.txtSPN.txt
Registered ServicePrincipalNames for CN=NAVSERVICE,CN=Users,DC=aisbdomain,DC=com:
DynamicsNAV/AI-WSServer.AI-WSServer:7106
DynamicsNAV/AI-WSServer:7106
DynamicsNAV/NAVSERVER.192.168.1.77.aisbdomain:7096
DynamicsNAV/NAVSERVER.192.168.1.77:7096
DynamicsNAV/192.168.1.77.aisbdomain:7096
DynamicsNAV/192.168.1.77:7096
DynamicsNAV/192.168.1.77.aisbdomain:7046
DynamicsNAV/192.168.1.77:7046


Servers.txt

name : MicrosoftDynamicsNAV$ServiceNFKSGII
startname : AISBDOMAIN\navservice
pathname : \RTC Service\ServiceNFKSG (33116) II\Microsoft.Dynamics.Nav.Ser
ver.exe
status : OK
displayname : Microsoft Dynamics NAV Server R2 NFKSG II
Description :
status : OK
servicetype : Own Process
started : True
state : Running
startmode : Manual
systemname : AI-WSSERVER
__SERVER : AI-WSSERVER


SetSPNX.txt
Checking domain DC=aisbdomain,DC=com
Processing entry 0
Processing entry 0
Processing entry 0
Processing entry 0
Processing entry 0
Processing entry 0
Processing entry 0
Processing entry 0
Processing entry 0
Processing entry 0
Processing entry 0
Processing entry 0
Processing entry 0
Processing entry 0
Processing entry 0
Processing entry 0
Processing entry 0

found 0 group of duplicate SPNs.

kine

the NAV service account must have delegation enabled to the SQL service, not on itself... that's what I have noticed at first sight...