I'm currently setting up SAP Business Objects Data Services 4.0 SP1 on windows 2008, SQL Server 2008 Express. I have been following the sap guide DM_ERP_Quick_Guide_EN_US_40. Now at the point where i have to install the migration services tool, after filling out all the parameters required to Add a staging area, and testing the connection, the test failed and gave the following details.
Invalid object name 'MGMT_PROFILE_HDR'.
I tried to trick the system by going into the database to create the missing MGMT_* tables using dummy columns. I tested the connection to the database and got the following message details:
Connection successful: But cannot find the MGMT_* tables.
I need an advice on how to go about solving the error.
Any suggestions will be appreciated.
These are the parameters i used:
Staging Area Name: ERP_SQL_Server_Authentication_sa
Database type: Microsoft_SQL_Server
Machine/DSN Name: TRNSAP\SAPBPDM
Database/Service name: DM_REPO_ERP
User : sa