title: List of all users in Azure SQL
body: <p>How can I list all users which can connect to my sql server database? Now able to find any sql command. I tried few links available on the internet but none of them worked.</p>
  
  <p>Some commands that I tried </p>
  
  <pre><code>SELECT * FROM sys.sql_logins;
  
  SELECT * FROM sys.sysusers;
  
  select * from sys.sysusers
  SELECT [name], [sid]
  FROM [sys].[database_principals]
  WHERE [type_desc] = 'SQL_USER'
  </code></pre>
  
  <p>I also looked in azure portal but did not find any users information.</p>
  
  <p>I am able to connect to sql database which connection string where I am providing userid and password. Now I am not able to find that userid in sql server.</p>
  
  <p>connection string looks like</p>
  
  <pre><code>value="Server=server,1433;Initial Catalog=DB1;Persist Security Info=False;User ID=user1;Password=pass1;Encrypt=True;Connection Timeout=30;" 
  </code></pre>