title: Can't add user to db_datareader via script
body: <p>I have the following script: </p>
  
  <pre><code>ALTER ROLE [db_datareader] ADD MEMBER [DomainGroup123]
  </code></pre>
  
  <p>when I run this against SQL Server 2008 R2 I get this error:</p>
  
  <blockquote>
    <p>Msg 156, Level 15, State 1, Line 1<br>
    Incorrect syntax near the keyword 'ADD'.</p>
  </blockquote>
  
  <p>I have looked online, and found <a href="http://sql-articles.com/articles/general/contained-database-sql-server-2012/">examples</a> that use this exact statement (but with a different user.)</p>
  
  <p>I have double checked that the login exists and is a valid user on the database I am using.  Also I have SA permissions on the server.</p>
  
  <p>What am I mssing?</p>