title: How to create login on azure ms sql server with access to all databases?
body: <p>I need to create a login on a server that will have access to all databases on this server.</p>
  
  <p>I have two azure servers: production and stage. I make a copy of a database from prod server on stage server. Then I need to do insert some test data in this new copied database.</p>
  
  <p>The copying process is made on runbooks in azure automation account so every time I want to execute SQL script on a database I need to provide a login&amp;password to a server.</p>
  
  <p>If I create a login TestLogin on stage server and then copy database from prod server to stage, then this login does not have access to a new db. Thus, I need to login as administrator and create a TestUser in this new database for TestLogin.
  This does not work for Azure:</p>
  
  <pre><code>GRANT CONTROL SERVER TO TestLogin;  
  </code></pre>
  
  <p>Is there any way I can grant a TestLogin all rights so that it can have access to all the databases on server?</p>