Very short questions about NAV - SQL Server Option

navvy

Hi,

Are this statements true:
1. If I have no Active Directory I can't use "Windows Logins"
2. If I use "Database Logins", I have to create the user logins in the SQL Server first

ara3n

1. False, you can use windows login without active directory. You can't lookup the list, you can just type the domaim/windowsuser
3. Yes. If you use windows login you don't need to.

kine

ara3n wrote:

1. False, you can use windows login without active directory. You can't lookup the list, you can just type the domaim/windowsuser

Are you sure? The NAV needs to translate the domain name into SID and this is not possible without AD. You can enter only user which you PC has cached... or local user...

kriki

[Topic moved from Navision forum to SQL General forum]

bbrown

kine wrote:

ara3n wrote:

1. False, you can use windows login without active directory. You can't lookup the list, you can just type the domaim/windowsuser

Are you sure? The NAV needs to translate the domain name into SID and this is not possible without AD. You can enter only user which you PC has cached... or local user...

It works if the workstations and server are in the same workgroup. However you must create the user on both the workstation and the server (also any other workstations that would be used). Not bad on a small system but a maintenance headache on larger systems with constant employee over-turn.

David_Singleton

kriki wrote:

[Topic moved from Navision forum to SQL General forum]

Hmm since this is clearly a question from exam MB7-517, shouldn't it be move to the exams forum?

Or maybe the poster was trying to sneak it in under the radar. 8)

navvy

Thanks for you answers

David Singleton wrote:

Or maybe the poster was trying to sneak it in under the radar. 8)

No, It should not be an exam question: I'm trying to setup NAV (SQL Server Option) with Windows Login and without AD, but it doesn't work. I think, the Windows Server is in a different Workgroup......

David_Singleton

navvy wrote:

Thanks for you answers

David Singleton wrote:

Or maybe the poster was trying to sneak it in under the radar. 8)

No, It should not be an exam question: I'm trying to setup NAV (SQL Server Option) with Windows Login and without AD, but it doesn't work. I think, the Windows Server is in a different Workgroup......

Ah OK, my bad, it just happens that they are both questions in that exam.

Hey does that mean that finally we have found an actual exam quesiton that has a connection to the real NAV world.

DenSter

That's assuming that this question is indeed an exam question, which I thought was established that it wasn't

David_Singleton

DenSter wrote:

That's assuming that this question is indeed an exam question, which I thought was established that it wasn't

You miss read. What I mean is that a/ these are exam questions in MB7-517, and b/ they are issues that some one has asked in real life. So here are exam questions that have a place in the real world. \:D/

DenSter

David Singleton wrote:

these are exam questions in MB7-517

I read your assertion, but wouldn't know how to verify that. I read it more as "that LOOKS like an exam question". When navvy said it was a real life experience, that means that the source of this particular question was not the exam. Even if the same question is asked during the exam it would still not BE an exam question. It still may LOOK like one though

Waldo

bbrown wrote:

kine wrote:

ara3n wrote:

1. False, you can use windows login without active directory. You can't lookup the list, you can just type the domaim/windowsuser

Are you sure? The NAV needs to translate the domain name into SID and this is not possible without AD. You can enter only user which you PC has cached... or local user...

It works if the workstations and server are in the same workgroup. However you must create the user on both the workstation and the server (also any other workstations that would be used). Not bad on a small system but a maintenance headache on larger systems with constant employee over-turn.

Indeed, I can confirm it. Plus, create the users with the same passwords...

garak

with \Userid you can insert al windows user from local system(s) without AD, but they need the same PW

navvy

...source of this particular question was not the exam

Thats true, the name of the workgroup on the server was wrong (it was WORKGROUP and should be SIMPSONS)

Ok, thank you guys !

Waldo

SIMPSONS ... in a live environment?

@Garak: isn't it .\Userid (with the ".")?

garak

SIMPSONS :?: Hehe :-D

if i enter .\ instead if \, the error message

---

Microsoft Business Solutions-Navision

---

Unknown Windows user.

---

OK

---

is displayed

Waldo

Ok, should have tried it myself ... never mind :oops:

navvy

Waldo wrote:

SIMPSONS ... in a live environment?

yes, and in this case it was also easy to find names for the PCs... \:D/