DB Connect from BW on Oracle to MS SQL Server 2005
I am having issues replicating Meta-Data from SQL server databases via DBCONNECT to SAP BW.
For instance we have the CCM DB and the Siebel DB. We can transfer meta-data from CCM with no problem (SQL Server 2000) but we cannot transfer meta-data from Siebel (SQL Server2005).
Our SAP BW is system is on an Oracle database.
CCM is on OS Win 2003. SQL 2000 SP4.
Siebel is on Win 2003 Server Enterprise 5.2 and SQL Server 2005 SP2.
I already have the dbsl for SQL server installed in the BW system. When I do a Connection Check of the source systems in RSA1, it says "Source system connection OK".
Any help will be highly appreciated.