More than one domain with WIndows Authentication

asmilie2b3

Hello all. Long time onlooker, first time posting.

I have an issue which may be more of a network one than Navision but would really appreciate any advice.
We wish to switch over to using Windows Authentication. However we have users running Nav (4.0 SP2) on two different domains. When they try to log in on the 2nd domain (that SQL is not sitting in) they receive an SQL error when running Nav that the user " does not exist. Can SQL be made to recognize two domains somehow?

asmilie2b3

My bad, this has already been discussed of course...
e.g.
viewtopic.php?f=23&t=38947&hilit=runas

It is almost there, but I wish to send parameters to Nav such as NTAuthentication=Yes. Unfortunately it seems the runas command does not accept any parameters. I wonder if anyone has found a workaround for that?

Sog

Runas does accept parameters, it is actually required (as one of the parameters is the domain\user or user@domain)
But I'm guessing you want to add parameters with the finsql.exe. Although I haven't tested it, it appears that those parameters can be added when adding quotes:

runas /user:navuser@otherdomain "finsql.exe ntauthentication=yes"

asmilie2b3

Hello Sog.

Many thanks for the reply.
I just tried inside two quotes, and interestingly it takes the first parameter, but not the following ones.

If I do the below, all of the parameters (in red) end up in the server name field in the client. So I need to seperate them somehow and I have tried commas, semi-commas, slashes etc to no avail.

runas /user:domain\username "C:\Program Files\Microsoft Business Solutions-Navision\Client\finsql.exe ServerName=MYCOMPDB01 NTAuthentication=Yes database=Mycomp ID=Mycomp company=Mycomp"

Sog

In that case, migth I suggest only to use the parameter for the zup-file. The zup file should contain all those settings. So you don't have to give those with the parameters.

asmilie2b3

Thank you. Yes I will go with that or perhaps just use the NTAuthentication. Whichever works best as there is only one shot with a parameter it seems. Many thanks for your help!