0

can not login with authentication type=User Name

Jet Reports Historic Posts

September 24, 2014 09:07

None

Follow

I have setup a NAV 213R2 NAV Server with authentication type=Windows, which is available over WAN on port 7047

On a machine outside the domain
If i browse to http://MyServerIP:7047/B2B1000190/WS/SystemService, i receive a prompt and i can put in my windows login (domain\userid) and password and the wsdl is returned (and i can see Jet_Data_Source as an endpoint)

I can connect via the RTC Client to the NAV Service, by specifyng in the clientsettings config file, that i would like to connect with UserName:

<configuration>
<appSettings>
<add key="ClientServicesProtectionLevel" value="EncryptAndSign" />
<add key="ClientServicesCredentialType" value="UserName" />
<add key="ServicesCertificateValidationEnabled" value="true" />
<add key="DnsIdentity" value="NavServiceCert" />
</appSettings>
</configuration>

The Problem
If i launch jetreports express and connect to the same NAV Webservice instance and select windows authentication it will fail, as the machine is outside the domain. If i select NAVUser as authentication type, then it fails with '401 Unauthorized' - I assume it is because it expects that the NAV Service is setup with authentication type=NavUser.

The reason for this setup, is that for machines inside the domain we would get "automatic login", while machines outside will be prompt for username/passwrd, but we only need to maintain one NAV Instance.

Any advise on how to eliminate the error ?

• Facebook
• Twitter
• LinkedIn

8 comments

• 0
  
  Jet Reports Historic Posts September 24, 2014 19:11

  Hello mjanum,
  
  The likelihood is that you will need a separate instance for Windows Authentication and a separate instance for UserName Authentication.
  I have attached a guide that details how to enable the UserName authentication for the instance, these are settings that you would want to perform with your NAV partner.
  
  Regards,
  
  MWilson

  • NAV 2013 WebServices UserName Authentication.docx
• 0
  
  Jet Reports Historic Posts October 27, 2014 13:36

  Hi MWilson - thanks i will take a look

• 0
  
  Jet Reports Historic Posts October 27, 2014 16:07

  Hi mwilson
  
  would it be on the roadmap to support my scenario outlined, as it works with the webclient and/or the rtc windows client ?

• 0
  
  Jet Reports Historic Posts August 22, 2015 11:37

  Hello
  
  Seems this bit old post , I too face the same issue as some users are outside the domain.
  
  Did you finally managed to setup two separate instances and get the jet reports worked for all the nav users inside and outside the domain?
  
  Best regards
  
  Ravi - Hong Kong

• 0
  
  Jet Reports Historic Posts August 24, 2015 16:02

  Hello Ravi,
  
  There are many Jet Express/Essentials users who utilize Jet in this environment successfully with the Web Services Data Source.
  There is a new connection available now which is called the "Jet Remote Data Service" Data Source which is available in Jet Express/Essentials 2015 Update 1.
  This Data Source type was specifically created for hosted/cloud based environments where the local PC with Excel/Jet and NAV are in two different domains.
  This new connection requires a valid SSL certificate.
  The Jet Remote Data Service Data Source - Admin Guide: http://kb.jetreports.com/article/AA-01053
  
  A typical set of PowerShell commands would look like this:
  New-JetRemoteDataService -Port "8084"
  
  New-JetNavRemoteDataServiceInstance -InstanceName "JRDS" -Server "servername\instancename" -Database "Demo Database NAV (7-1)" -AuthenticationType 2 -UserID "sa" -Password "password"
  
  Best regards,
  MWilson

• 0
  
  Jet Reports Historic Posts September 04, 2015 21:15

  Hello Wilson
  
  Thanks for for the information, we tried hard to setup JRDS unfortunately we could not succeed.
  
  We would highly appreciate if you could help us remotely in this regard, we could go through via remote viewer etc to setup the same quickly , your help in regard highly appreciated. We have struggling for this for almost over 9 months even before JRDS was setup by Jet Reports , I know before Jet Suggested creating two separate instances in navision application for two different type of user viz. users inside domain and outside the domain , our ERP implementation partner from India is not capable to do this for us and also unfortunately we bought jet essential again thru them there again they are of no help to setup this JRDS FOR US.
  
  
  Please see if you could help us for setting up this JRDS for us.
  
  Best regards
  
  Ravi- Hong Kong

• 0
  
  Jet Reports Historic Posts September 04, 2015 21:57

  Hello Ravi,
  
  I am not certain that we would be able to connect via a remote session as our time zones may not permit it.
  I am on the PDT time zone in the United States which is a 15 hour time difference.
  I would suggest contacting your regional Jet Reports department to see if they can assist you via a remote session to configure the JRDS.
  Another option would be to configure an RDP to a terminal server or workstation that is on the domain and have your remote (non-domain) users login to that machine to utilize Excel/Jet Express where the connection would be configured locally.
  
  Best regards,
  MWilson

• 0
  
  Jet Reports Historic Posts September 05, 2015 14:35

  Dear Wilson
  
  Absolutely no worries I can get connected during your working hours only never mind even if it's night time for us.
  
  I would not mind taking help from your Singapore office but it seems they do not have experience in this regard that's they have directed me to USA team in the first place.
  
  Please let me whatever convenient time to you during your regular working hours.
  
  Thanks in advance
  
  Best regards
  
  Ravi