Is there any way to determine why is a
Login is losing a
I've created them with the following SQL ...
CREATE LOGIN [qauser] WITH PASSWORD = 'xxxx', DEFAULT_DATABASE = [app_tst], CHECK_EXPIRATION=OFF, CHECK_POLICY = OFF CREATE USER [qauser] FOR LOGIN [qauser] WITH DEFAULT_SCHEMA = [devdba]
and then successfully used the matching login on a linked server with synonyms to tables in the original.
Some time later, the synonyms fail and checking the
LOGIN properties, the
User Mapping have gone for the database / user. I have to re-run the
CREATE LOGIN / USER script to get them to work ... but using the main devdba login, the synonyms continues to work
What could be causing this loss ?