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

tonypang
tonypang Member Posts: 101
edited 2012-04-20 in NAV/Navision Classic Client
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
NAV

Comments

  • mohana_cse06
    mohana_cse06 Member Posts: 5,506
    Did you setup proper Windows Authentications?

    -Mohana
    http://mohana-dynamicsnav.blogspot.in/
    https://www.facebook.com/MohanaDynamicsNav
  • kine
    kine Member Posts: 12,562
    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)
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • tonypang
    tonypang Member Posts: 101
    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
    NAV
  • mohana_cse06
    mohana_cse06 Member Posts: 5,506
    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?

    -Mohana
    http://mohana-dynamicsnav.blogspot.in/
    https://www.facebook.com/MohanaDynamicsNav
  • kine
    kine Member Posts: 12,562
    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...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • tonypang
    tonypang Member Posts: 101
    Hello mohana_cse06 i got set it up windows Authentication but still get the error message.
    NAV
  • tonypang
    tonypang Member Posts: 101
    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 : D:\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.
    NAV
  • kine
    kine Member Posts: 12,562
    the NAV service account must have delegation enabled to the SQL service, not on itself... that's what I have noticed at first sight...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.

Categories