NAV 3 Tier Architecture

myanilkumar

Hi All,

I had installed SQL Server & Dynamics NAV Server in different Machines.

When I start roletailored Client from NAV Server It is connecting to SQL Server fine No issue.

But when I Start Role Tailored Client from Client machine It is giving error Login failed when connecting to SQL SERVER "SQL SERVER NAME".

Please advise.

Regards,
Anil

mark_au

Hello Anil,

You can connect with the RTC successfully on the machine running the NAV Server service, but you can't connect on a client machine to the NAV Server service? Are you able to connect directly to the SQL Database using the classic client from the client machine?

Regards,

Mark.

myanilkumar

Hi,

Yes Correct. But I can connect using classic client from Client machine using the Windows Account. I only can't connect Role Tailored Client.

alok_dida

When the RoleTailored client, Microsoft Dynamics NAV Server, and SQL Server are installed on separate computers you have to set up delegation for it. Check it out following link.

http://msdn.microsoft.com/en-us/library/dd301254.aspx
http://msdn.microsoft.com/en-us/library/dd568720.aspx

myanilkumar

Hi,

I had setup the constrained delegations but still i am facing the same problem. Please advise.

Regards,
Anil

kine

Check event log on both machines for more info...

Reynold

This can help a lot in troubleshooting RTC connection issues:

http://blogs.msdn.com/b/nav_developer/a ... -2009.aspx

Regards,
Rey

TonyH

First thing if you delegation is set correctly I would say is to search for duplicate SPN's

t