Commerce Server 2002 Datawarehousing

Hello folks,
1) I keep on receiving this error "The database 'MSCS_Admin' may not be 
accessible or Analysis and Data Warehouse componests may not be installed"
whenever I try to access the analysis from the bizdesk. I have built a
site 
on top the retail2002 and I started to get this error whenever I try to go
to 
the analysis. However, I configured the DTS to Im****t from campaign, 
transaction,web server log, profile and configuration sync all in the site

level and all of them point to re****t preparation. Please advise me to how
I 
can solve this error.
2) My webserver box sitting in a different box than the sql server and 
whenever I try to drag and drop the webserver log im****t in the DTS
package 
it gives me an error that says " invalid Connection Information for site 
retail2002" 
Please help and I highly appreciate any assistance