NAV 2009 - Access to Public Web Services Password Exception

tiagofrancis

Hi all.

We're having troubles setting up external connection to NAV Web Services through public IP.

We have no errors in the BPA.

Does anyone knows if there is a particularly setting or configuration to achieve this?

Currently, if we access, we've the following error:

<s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/"&gt;
<s:Body>
<s:Fault>
<faultcode xmlns:a="urn:microsoft-dynamics-schemas/error">
a:Microsoft.Dynamics.Nav.Types.NavDatabasePasswordException
</faultcode>
<faultstring xml:lang="pt-PT">
The login failed when connecting to SQL Server SRVVMCDFPDB01.
</faultstring>
<detail>
<string xmlns="http://schemas.microsoft.com/2003/10/Serialization/"&gt;
The login failed when connecting to SQL Server SRVVMCDFPDB01.
</string>
</detail>
</s:Fault>
</s:Body>
</s:Envelope>

Thanks in advance.

Juhl

Missing SPN i think.
2009 is a nightmare when coming to rights.
And in all other aspects, but that’s my view ;-)

tiagofrancis

Ok. Thanks for your reply. But do I need to have a SPN for the public address? Like: 92.11.200.12:7090?

Thanks in advance.

Juhl

Have a look at these, and see if it helps.

https://dynamicsuser.net/nav/b/kine/posts/dynamics-nav-2009-and-spns
https://msdn.microsoft.com/en-us/library/ee414212.aspx
https://blogs.msdn.microsoft.com/nav_developer/2009/01/16/nav-2009-web-services-on-a-three-machine-setup/