Ok but how does one create a login and associated user (destined for the secondary database/domain) in the primary database/domain? The Windows NT user or group will not necessarily be available in the primary...
Msg 15401, Level 16, State 1, Line 1
Windows NT user or group 'TEST\test' not found. Check the name again.