title: MS SQL server user account for ODBC access
body: <p>I am trying to create a user account in SQL Server 2008 R2 to use for ODBC access restricted to one database. I am unable to create an account with a valid password. How can I give public, read-only access to the database using the ODBC driver. The users have no admin privileges on our network so NT authority wont work. Any Ideas??</p>
  
  <p>Thanks,</p>
  
  <p>Jhmpro</p>