Cannot login to SQL Server from Visual Studio, same credentials work on SSRS page
I solved my own problem.  I needed to grant data reader rights to that database for the user.  I do that by right clicking the user name under Security\Logins and choosing properties.  In there I go to User Mapping.  Make sure the user is mapped to the database being queried and under the Database Role Membership make sure db_datareader is checked.