I was able to solve the issue by creating a relationship between county and state, and county and region. I was able to go through trial and error until...
The issue was I had to log in using OLE DB SQL Server with "auto" credentials, then I needed to log into the AS server via my company's window's login....