title: Azure SQL Server Admin v/s Regular User
body: <p>Currently, I am a server admin on an Azure SQL server.  When I create an azure function app and connect to a database (on the server) I have to specify a sql connection string from the app. The connection string will use my username and password.  </p>
  
  <p>I want to change this so that the server admin is an active directory group (development group or something).  Microsoft support told me I can not set a password to an active directory group.  How do I create the connection string without a password? Or do I have to create an office 365 account with a development identity so I can set a development user and development password?</p>
  
  <p>In Sql server management (ssms), the server admin is listed under the security directory.  I have been using the server admin username and password to connect to the database from azure function apps.</p>
  
  <p>Now I created a user called Development on ssms like this:</p>
  
  <blockquote>
    <p>USE CompanyDatabase
    CREATE LOGIN Development 
      WITH PASSWORD = 'password';
    GO</p>
  </blockquote>
  
  <p>I tried using the development login as parameters in my connection string and got this error:</p>
  
  <p>Exception has been thrown by the target of an invocation. .Net SqlClient Data Provider: The server principal "Development" is not able to access the database </p>