migrating Windows logons to new server

logdog

Hello wise ones & happy New Year. I have a problem with a Navision 4.0, native database, just moved to new server, database logins work properly as does database, however Windows logins no longer work. How do I update so that they do?

Thank you

garak

is this a new AD (domain)?

logdog

Yes, it is a SBS 03 server. Can I update the SID by opening Object Designer in Navision and running Table 'Windows Objects' and pointing the Login ID field to the user account on the server?

kine

1) If you already moved to the new domain, you will not know which SID was for which User.
2) Common way> before shift to new AD, export the data from Windows User table including SID and USERID.
3) Move to the new AD
4) Read the data exported in point 2 and based on that add users again and assign them sam roles as there are for the old SID.
5) After that you can remove all old accounts.

It means you need to have info about mapping of USERID and old SID to do oldSID -> USERID -> newSID conversion.

logdog

Thank you. I exported to USB drive, and things are good