Microsoft.Dynamics.Nav.Types.NavDatabasePasswordException

tiagofrancis

Hi Folks,

I've have installed nav 2009 on 3 tiers.
I have this proxy web service that is refering the Nav 2009 Web Services.

I would say that everything is installed correctly, even the SPN's cause i can consume the proxy web service and create customers and do other stuff as well on the local network.

When i invoke methods that use pages (GET*) i've this weird exception:

(Microsoft.Dynamics.Nav.Types.NavDatabasePasswordException The login failed when connecting to SQL Server GM-SQL\SQLNAV)

Does anyone know how to handle this error?

If you need more info, just ask.

Thanks in advance.

Tiago

tiagofrancis

SPN'S issue.

Maci

Hi tiago, I have same error, with a 3 tier installation.
The question is, the domain user that starts services has acces to the SQL server and in Navision too!. And the RTC environment with other users works fine, so I think SPN is correct.

My error is
<faultcode xmlns:a="urn:microsoft-dynamics-schemas/error">a:Microsoft.Dynamics.Nav.Types.NavDatabasePasswordException</faultcode>
<faultstring xml:lang="es-ES">The login failed when connecting to SQL Server MySQLServerName.</faultstring>

I try to start RTC with the domain account who start service, and RTC works fine. But if I try to acces xxx:7047/DynamicsNAV/WS/Services I get that error

Any suggestion would be appreciate, thanks!