<p>I am having problems when connecting to my SQL server 2008 and think it might be a problem related to MDAC. Is there a download to re-install these?</p>

MDAC 2.8 SP1
Remember, MDAC is client software that should not be installed on the server.
Your problem is more likely a protocol or firewall error.
Can you give more info please?