select 
	r.name [Server Role],
	u.name [Login],
	u.type_desc [User Type]
from (select name,principal_id from sys.server_principals where type = 'R') r
	join sys.server_role_members rm 
		on (r.principal_id = rm.role_principal_id)
	join (select name,type_desc,principal_id from sys.server_principals where type != 'R') u 
		on (rm.member_principal_id = u.principal_id)