Can not connect RTC to tree tiers installation

Hi all,

I am having a great deal of problems installing the tree tier installation.

I have installed a SQL server, jl-lab-sql
Windows Server 2003 R2 (with all the latest updates)
SQL Server 2005 (with all the latest updates)
Set the SQL server services to use the NAV2009 account to run
Installed the database option from the NAV 2009 SP1 disk

I have installed a NAV server, jl-lab-nav
Windows Server 2003 R2 (with all the latest updates)
Installed the NAV server option from the NAV 2009 SP1 disk
Set the Microsoft Dynamics NAV Server service to use the NAV2009 account to run

On the NAV2009 account I have set the following Service Principal Names:
http/jl-lab-nav
http/jl-lab-nav.xx.xx (yes I have replaced the real name)
jl-lab-nav_DynamicsNAV/jl-lab-nav.xx.xx:7046
jl-lab-nav_DynamicsNAV/jl-lab-nav:7046
mssqlserver/jl-lab-sql.xx.xx:1433
mssqlserver/jl-lab-sql:1433

I have also set “Trust this user for delegation to any service (Kerberos only)” on the NAV2009 account.

In the SQL server I have added NAV2009 as a user on the Demo Database NAV (6-0) and put $ndo$navlistener as the default schema and also grant select on the Object.Tracking schema.

The domain function level is at Windows Server 2003.

The firewalls on the servers is off.

The firewall on the XP machine has port 7046 and 7047 open and also an exeption for Microsoft Dynamics NAV Client.
I have added the line " to the ClinetUserSettings.config file.

On the SQL Server I can run the Classic client with SQL

On the NAV Server I can run the Classic client with SQL and the RTC

On the XP Client I can run the Classic client with SQL but not the RTC. When I start the RTC I get an error message that says “The login failed when logging in to SQL Server jl-lab-sql”.

What have I missed?
Please help me.

//Pierre

Hi!

The Server Principal Names is this and nothing else:

http/jl-lab-nav
http/jl-lab-nav.xx.xx (yes I have replaced the real name)
jl-lab-nav_DynamicsNAV/jl-lab-nav.xx.xx:7046
jl-lab-nav_DynamicsNAV/jl-lab-nav:7046
mssqlsvc/jl-lab-sql.xx.xx:1433
mssqlsvc/jl-lab-sql:1433

When connecting from the XP client I get this error message in the Application log on the SQL server:

Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’. [CLIENT: (ip adress)]

Hi all!

The SPN has changed in NAV 2009 SP1 so what it says now is:

DynamicsNAV/jl-lab-nav.xx.xx:7046
DynamicsNAV/jl-lab-nav:7046