After using the SQL 2008 Copy Database wizard I now have a Copy of the Live database for testing/training etc which will be refreshed every night. I can gain access to the database no problem but when non db owners try to access it using Nav 2009 R2 they get an error
Cannot set application role '$ndo$shadow' because it does not exist or the password is incorrect
The application role does exist and has a password according to SSMS.
Security is Standard in the Live and Copy databases, I've synchronised the logons and users have permissions to both databases.
I've read about changing the security model to Enhanced and back to Standard as this will be a scheduled job I don't want to be running extra commands that could lock the job as can happen when changing the security model.
Any ideas why an exact copy of the database shouldn't act in the same way as the source database?
Life is for enjoying ... if you find yourself frowning you're doing something wrong