NAV 2009 R2 Web Service, URL works only if it is launched in NAV Server first?

leesi01
leesi01 Member Posts: 1
in NAV Three Tier
We recently upgraded from 2009 SP1 to 2009 R2.

After NAV Server and Web Services are installed and configured in a 3-tier environment, we registered SPN using a Domain user account - stb4navwebsrvs.
C:\Users\silee>setspn -L stb4navwebsrvs
Registered ServicePrincipalNames for CN=stb4navwebsrvs,OU=Service Accounts,OU=IT
,OU=Locations,DC=stb,DC=com:
mssqlsvc/STBVMDEVNAVDB.stb.com:1433
mssqlsvc/STBVMDEVNAVDB:1433
MicrosoftDynamicsNavServer/STBVMDEVWEBSRVS.stb.com:7046
http/STBVMDEVWEBSRVS.stb.com:7047
http/stbvmdevwebsrvs
http/stbvmdevwebsrvs.stb.com

We also using "httpcfg set urlacl -u http://+:7047/DynamicsNAV/ -a D:^(A;^;GX^;^;^;..." command to add stb4navwebsvrs to URLACL,

We made stb4navwebsrvs the Local Administrator to both the SQL Server and the NAV Server.
We also grant SUPER right to stb4navwebsrvs

But still, when I test this URL http://stbvmdevwebsrvs:7047/DynamicsNAV/WS/1481STB/services any where, I am getting this page back
- <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="en-US">The login failed when connecting to SQL Server STBVMDEVNAVDB.</faultstring>
- <detail>
<string xmlns="http://schemas.microsoft.com/2003/10/Serialization/">The login failed when connecting to SQL Server STBVMDEVNAVDB.</string>
</detail>
</s:Fault>
</s:Body>
</s:Envelope>

But if I run this command in stbvmdevwebsrvs, it returns the correct result, only then, any other PC's logged on with my name is returning the same result, if I run this URL.
- <discovery xmlns="http://schemas.xmlsoap.org/disco/&quot; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance&quot; xmlns:xsd="http://www.w3.org/2001/XMLSchema"&gt;
<contractRef ref="http://stbvmdevwebsrvs:7047/DynamicsNAV/WS/1481STB/SystemService&quot; xmlns="http://schemas.xmlsoap.org/disco/scl/&quot; />
<contractRef ref="http://stbvmdevwebsrvs:7047/DynamicsNAV/WS/1481STB/Page/EmployeeQualification&quot; xmlns="http://schemas.xmlsoap.org/disco/scl/&quot; />
<contractRef ref="http://stbvmdevwebsrvs:7047/DynamicsNAV/WS/1481STB/Page/EmplQualAPIDev&quot; xmlns="http://schemas.xmlsoap.org/disco/scl/&quot; />
</discovery>

Could anyone advise, what seems to be the issue?

Incidentally, I also make computer account stb\stbvmdevwebsrvs$ the owner of the Database and assign it with SUPER permission.

Categories