We are finding a couple of problems with NAV SQL 2005 security.
#1 After restoring our database for the first time ( and syncronizing all users) we realized that the passwords did not sync. Anyone have this problem?
#2 When using Windows Authentication we have found that we do not have permission to certain tables (possibly only tables with autoincrement as primary, not sure yet). The way around this for now is to give the user (in sql) “database owner” permissions.