Hello, I have NF 2.6 and I want upgradin to sql server I’m on a NT domain. It’s impossible to use Windows authentification on a NT domain ?? I receive an error with AD not disponible… (Ther isn’t AD on NT) Thx
I’m not sure I really understand the question, but… Naviison 2.60 on NT works fine with Windows logins. As for SQL, I would recommend that you upgrade to a newer version of the executables, 3.7 at the minimum. This of course would mean going to win2k.
with NF2.6 on sql server , I do : I create user oçn sql server Databse/Open, and select Windows authentification, NF respond that user/password is incorrect. I connect with database authentification and go to Tools/Security/Windows Connection. When I try to select an ID, I receive the error : “could not retrieve global catalog from AD …”
quote:
I receive an error with AD not disponible… (Ther isn’t AD on NT)
Just to make sure: Have you installed Active Directory and configured it well? As far as I know, Windows Authentification with NAVISION and NT only works with Active Directory …
I’m on a NT domain, so there isn’t AD
quote:
I’m on a NT domain, so there isn’t AD
… and that’s the problem! Look at the “Installation & System Management” documentation, here you will find a lot of info about Windows Authentification, NT and Active Directory! Regards,
Well, Navision doesn’t need AD to allow use windows authentication. When you login to your local computer domain, or a workgroup, there is no AD present at all. Windows is using the old NT4 mechanism for storing SIDs and user credentials, using the LSA in that scenario. The win32 functions LookupAccountSID() and LookupAccountName() work fine here, and Navision uses these for most SID resolution - and the authentication process itself is handled by NTLM or Kerberos. But where Navision needs AD (because it uses LDAPI) is for the Windows Object 2000000050 virtual table. If you dont lookup into this but type the domain/user do you still get the error?
You absilutely do NOT need Active Directory to use windows logins. I use windows logins on my local computer, so that I don’t have to keep entering the password for all the multiple databases I have. Just go into the Windoes Logins, and create a user ID. For example, I have a user Id dsingleton on the computer \MyServer01\ so I just create a windows login user MyServer01\dsingleton this works fine for me. I think the problem is that you have not gone and created the Windows Logins. The advantage of AD, is that all that mainitnece is done on the AD server, if you just have a domain controller, then you have to create them manually on the Navsion server.
Hey Robert, you beat me, my comments were to the post one before yours.
Hi David … yes, and beating you is not easy these last few days with the traffic you’re generating 
I had wondered where you disappeared to - anyway good to see you’re back.
I was talking with Erik two weeks ago, ad told him that I would come back and get active again. I’ve got both hands back now, so I cantype at a reasonable rate now.