You may need to check your ODBC driver on the SQL reporting Server and make sure the SQL Native Client is available since SQL Server 2005 is using SQL Native...