has the user been added as an explicit server login on the sql server.

What are the resultsd of the following query

select name, SID

from sys.server_principals

where type = 'U'

and name = 'domain\username'