I figured out what was going wrong. The connect option for published data sources does not need to be selected in order to view workbooks on tableau server. Only the view option needs to be selected. However, you must embed credentials when publishing a workbook in order for them to be viewable by all users on tableau server.
Here is the link to the article that helped resolve my problem: