Dear all,
I have tried to install NAV 2009 3-tier in 3 computer as guide in
http://msdn.microsoft.com/en-us/library/dd301254.aspx.
But, when I run the RTC, I got error message "The login failed when connecting to SQL Server <my_database_server_name>".
When I go to SQL Server Log, I got this information :
Source : Logon
Message : Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Reason: Token based server access validation failed with an infrastucture error. Check for previous errors. [CLIENT: <my_service_ip_address>
Previous Error : 18456, Severity:14, State:11.
I used domain user account to login to RTC computer and as logon in Microsoft Dynamics NAV Server service and MSSQL Service.
Could anyone tell me how to solve this problem? Thanks before..
Answers
After many searching through internet, I got this link http://blogs.msdn.com/b/nav_developer/archive/2009/06/12/setting-up-nav-2009-on-three-machines.aspx to Setting UserAccountControl flag. After apply that setting, make sure the "Net.Tcp Port Sharing" service in middle tier is started.
So, the error "Login Failed" is not happen anymore.
Johanna