NAV Web Service intermittent connection

francisharvey · 2012-05-01

Hi,

It is not the first time I set up web service for NAV2009R2 server,
But i got a strange intermittent error,

If i try to connect to web service with internet explorer from another machine it didn't work,
When I connect by remote desktop on and try it locally, it works, I see the xml page,
And when i return to my other machine and try it again, it works too

If I wait some time, it stop working...
It seem to close the connection, so i need to go again on the server to reactivate it.

I've remove the frendly error from internet option, so now i see there is a error on user / password with sql server 2008 when it show http error 500

Anyone has seen something like that before ?

Thanks
Francis Harvey

ara3n · 2012-05-01

Hello.
You need to setup delegation. What you are experiencing, I can try to explain.

When you login in locally, NAV service tier connects to Active directory using kerberos authenication and get a ticket.

This ticket stays for 24 hours on the computer so that NAV doesn't need to authenicate again.

So when you connect from another pc it uses the ticket. When the ticket expires NAV goes to AD again for authenication and fails.

please read this blog on how to setup it SPN

http://mibuso.com/blogs/peik/2012/04/08 ... gurations/

kine · 2012-05-02

We had a simlar problem. It is as ara3n described, but I recommend to use latest build, because we had still problem with this even when the SPNs were correctly set. In most cases it was connected to the build and that we were using NTLM. When Kerberos auth. was used and newest build, we had no problems.

francisharvey · 2012-05-02

Thanks you guys,

I check the link you provide, it seem to give all the information to configure spn correctly, but i already have this information, as i said, it was not the first time i configure that things.

http://mibuso.com/blogs/peik/2012/04/08 ... gurations/

But here's the part I've missed, I forgot to create the SPNs for the SQLServer:1433
I only did it one time on my test environnement, every new server i created, it was already configured...
And I think it set it during the installation of sqlserver if you select a domain user but i'm not sure at all. :-k

I finally found it when i succeed to analyse the Nav2009 best practices,
I've put "DynamicsNAV" as the instance the first time, instead of nothing, so the analyser said no server was installed...

So now, aftrer reboot of every server, it is working. \:D/

Thanks again ara3n for you extremely meaningfull explanation of my problem. :thumbsup:
Francis Harvey

ara3n · 2012-05-02

You are welcome.

NAV Web Service intermittent connection

Comments

Categories