Normally you need to have an Active directory server running to use multi-tier of NAV 2009 R2. But in some cases this is not possible or existing. In NAV 2009 R2 we got an new configuration option called ClientCredentialType that is meant to be used over WAN. But I will in this blog post show one simple way to get this up and running for development and test purpose, in a LAN environment
In a developer or test environment 1. Install Service, Database and Classic client on the server machine.2. Create the needed windows users on the server machine3. Add the newly created window users to NAV in classic client, under Tools->Security->Windows Logins4. Now sync all new logins in classic client, under Tools->Security->Synchronize All Logins5. Install RTC on client machine6. Update ClientCredentialType in C:\ProgramData\Microsoft\Microsoft Dynamics NAV\ClientUserSettings.config (path is for Windows 7 and Windows 2008) to "UserName" on client machine. Also update the server key to server machine name. It’s important that you have never started RTC on this machine before to make this working.7. If you have started RTC earlier on the client machine you also need to update ClientCredentialType in C:\Users\[user name]\AppData\Local\Microsoft\Microsoft Dynamics NAV\ClientUserSettings.config to "UserName" on client machine. Replace [user name] with your user name. Also update the server key to server machine name.8. Start RTC and you will get a popup box asking for credential. For user name type "[server machine name]\[user name on server machine]".
For an production environment I would recommend to use certificates to authorize the connection between RTC and server. Guides to setup certificates can be found under subject "Procedural Overview" on http://msdn.microsoft.com/en-us/library/gg502476.aspx
What will be the minimum Role permission(Windows Level/SQL Server Level) for Remote user to access the Server DB thru RTC ?