SQL 2005 Security

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.

We have had a similar problem. Look at article 246133 in Microsoft.com Knowledge base - it will generate sql script to copy the logins with passwords to the new server.

Has this resolved your issue?

You might also want to review KB 919407 for update 1 to 4.0 SP2.