I've tried this and yes it will work. You just need to use the matching ODBC/OLEDB connection string for SQL Server 2005.
http://www.connectionstrings.com has some examples for SQL Server 2005
Cheers.
http://themapguyde.blogspot.com
http://au.linkedin.com/in/jackieng