The local user is null, so this linked server login applies to all non-mapped users. remove the SQL2008VPC\Pn login that's mapped to SQL2008VPC\ London: .