用于ODBC访问的MS SQL服务器用户帐户

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??I am trying to create a user account in SQL Ser