Hi!
We have successfully developed and setup a CS2007 solution for one of our customers. We have waited with the report part since we will use std cs2007 reports out of the box.
But... The customer wants to split the installation for DW database and Analysis services. Is this possible The DW.Pup has no configuration part to address DB DW Servere and Analysis server on separate servers. The installation of DW.Pup creates the database but not tables and procedures. The DW.Pup fails with
Microsoft OLE DB Provider for Analysis Services
0x80004005: Cannot connect to the server 'PLAZA02'. The server is either not started or too busy.
Database created on PLAZA02 but no User Tables.
The configuration:
DB Server PLAZA02 on SQL 2000 - Hotel without analysis services.
CS Server and Analysis Server - CS2007 and only Analysis services installed (no SQL 2000 server parts) (by DB department)
I have earlier never installed the datawarehose separate from the CS server. Is there any explanation of how the import is executed. I find no answer in the docs.
My qustion is:
Its required to install DW.Pup from CS2007 server. Will the CS2007 related DTS components be installed(copied) and executed on the SQL DW Server or started from the SQL Server and executed on the CS2007 server.
My guess is that the specific CS2007 DTS components need the installed CS2007 server components to execute. I have been doing some DTS packages etc earlier but only as scripts and not used components.
regards Johan Sorlin
DataWarehose setup configuration's
Jan Friberg
1. What do You exaclty mean with "unpupping on"
In my scenario:
CS2007 Server with AS installed
SQL 2000 DB Server with no AS installed having CS2007 databases
Do You mean that temporarily I need to Install AS on the SQL 2000 DB Server to:
On CS2007 unpup DW.Pup to create DW database on SQL 2000 DB Server and implicitly creating AS DB as well.
After unpup deinstall AS on SQL 2000 DB Server and copy AS DB to my CS2007 server and reconfigure DTS package to use CS2007 Server AS installation.
2. Could You also please give me some insides of what happens when the DTS job is run step by step and on wich machine (part two of my previous post)
Regards Johan Sorlin
Andrew Beery
The DW pup does allow you to choose different SQL and AS servers, but the unpupping process uses the AS archiving feature to unpack the AS db.
This means that you must install AS on the machine that you're unpupping on, unpup the DW (when the screens come up that allow you to choose the servers, select the eventual destination servers), then uninstall AS from the machine you're unpupping on.
SteveLK
Hey Johan
"1. What do You exaclty mean with "unpupping on""
On the server that is executing the DW.pup, the AS bits need to be installed on that machine as well as the target machine.
Hope this helps!
Alan