I finally getting around to seeing how security works. It appears that I don't have it configured correctly to see the security tables, which are in a the StrataFrame db, which is on an instance of SQL Server 2005, while the app data is on the default instance, which is SQL Server 2000.



I setup a required datasource item with a key of 'security' for the security database and set the SecurityDataSourceKey='security'. However, I've obviously done something wrong, because it isn't finding my users. There is another required data source for my app data, with a blank key. This one is working, because when I login as admin, the app data is there.



What am I not getting?

Yes...set this in the role-based security editor, then set the password for the user...then make sure it matches in the InitApplication and I think you will be good.  I just created a test app doing what you are attempting to do and it worked fine....so we just need to work through this little step and you should be on your way.