Try this query given below.

use

master

go

select

* from sys.server_principals where type in ('U','G','S')