Steps to Recreate NEW OLE DB Connection.
Step 1 : Go To BOXI Server.
Step 2 : Login to Designer
Step 3 : File -> Import-> CA IT Asset Manager.
Step 4 : Tools-> Connection-> Select "ITAM"
Step 5 : Edit " ITAM Connection"
User Name: BOXI User Which is used for connect to Database.
Password : Password of BOXI User to connect to Database.
Server : tcp:<Database Server which host MDB>,1433
Note: You may Click Test Connection button to check connectivity. Message should be " The Server is Responding".
Step 6 : Set the connection Pool Mode: " Disconnect After Each transaction".
Click Next and Finish the Wizard.
Step 7 : File -> Parameter.
Note: Make Sure ITAM is Selected under Connection Field.
Step 8 : File -> Export . (This would Save the changes made to Universe, Gets Successfully Uploaded to CMS Database).
Click OK to complete the steps.
Now you may run Reports.