I've verified the services are all up and running currently on that specific server.

I think it maybe something corrupted in the BAS or SQL with that specific connector. Is there a way to remove it and re-add it back in SQL since I can't do anything with it in the BAS Console? or maybe just reinstall that connector?