I have a few specific issues with out process of migrating ArcSDE dbs from one server to another, but generally speaking, Are there resources for a medium level explanation of best practices for secuirty models. I understand the general concepts, OS Authenticate vs DB\SQL AUthentication, and grouping as readers, editors and administrators, but I am getting over my head with how a user (who is in a group), comes in through a group, is assigned role, and requires a schema.
I am a local admin on my server machine, and have two dbs that I manage. I have alway used WIndows AUthentication as my own username, and all my data sets that i have imported, created, etc. are in the "dbo" schema.
I have recently backed, up, and restored to a new server, set compatability, and resynched the "sde" account. I am not unable to create data. I tried to export a feature to a new featureclass within, and error message indiacates I am trying to write to master.dbo.testfc instead of sde.dbo.testfc. Not sure what I did or failed to do.
Also have a second user who has been editing successfully on old server (Above), who has always mapped to his username, and on the new server after setup, he is not appearing as (when he creates a version, the version owner is) "guest". He still has edit rights as he should but the versions started on the old server are unavailable to him now.
Thanks for any help.