MSSQL User Permissions

When using SQL Server Authentication, what permissions does the user name being used need to have?

I've been able to get everything migrated and up and running on MSSQL, however, it doesn't appear to be collecting any data.