SQL Server 2008 Named Instance

[SMitchell]

Hello,

We are in the process of moving our data warehouse from SQL 2005 to SQL 2008. Once the data warehouse was moved I change the server name on the warehouse connection in Data Manager 8.4 and now we keep getting errors stating that the object doesn't exists. The errors are:

DM-DBM-0400 UDA driver reported the following on connection connectioNAe:
UDA-SQL-0327 An invalid object name was detected in the SQL request.
UDA-SQL-0322 Unable to find the colum "column_name".

I have confirmed that the column does exist on the table. I have run a profiler to watch the connection and it all likes fine, no SQL server errors are generated. The last line that is sent to the DB is: exec [dw].[sys].sp_columns_100_rowset N'TABLE_NAME',N'SCHEMA',NULL.

I've tried using the SQL 2008 native client and for the OLE-DB provider and the SQL 2005 native client. Nothing seems to work. I'm thinking it's a 2008 version issue with Data Manager.

[SMitchell]

Please ignore this. I found the problem as soon as sent this in. It was a permission issue on the user that data manager was using to connect to the data warehouse.