SQL Server 2008 web edition x64 I'm opening: (connection)/Security/Logins/John. Select "User Mapping'. On right pane is marked checkbox at DB1 line. I turn on checkbox at DB2 line, correct username and schema appear. Press 'ok'. Opening (connection)/Security/Logins/John once more and there is mo mark at DB2 checkbox, it's clear. No username/schema at that line, of course. Mark checkbox again, and so on until become mad.
No error messages, no errors in log.
I can't turn off DB1 checkbox because of 'Canno drop the user dbo'
DB1 really doesen't importanf for me, but I need DB2 mapping. How can I fix this?