No Database Server Authentication on RTC

rgabriels

For a new customer I installed both the Classic as the RTC environment. In the classic environment I'm able to add Database Server logins. In the RTC Db Server logins don't work anymore, so my customer has to install a Windows domain.

alexpeck

You can also use Windows logins with workgroup authentication (no domain required) if the NAV service tier and SQL Server are on the same box. Each Windows account must exist both on the server and client machine with an identical user name and password (I think user names are case sensitive in this context).

Just remember to synchronize logins via C/SIDE running on the server box. This is because although the user accounts share the same name, they have different SIDs. If you add login entries to the database from the client machine you will add client SIDs which the server cannot resolve.

Alex