Annoying issue with unpacking the Data Warehouse package
I've spent the last 15 minutes trying to lock down what I feel is a rather annoying bug in the product. I'm attempting to set up a simulated production environment, where I have seperate machines running SQL, Commerce Server, Active Directory, et al. While attempting to unpackage the data warehouse on one of my web servers, I got the following error:
"Invalid Connection Information for OLAP Server"
According to an earlier newsgroup posting, I need to install SQL Server Analysis Services on my web server to fix this issue, and then remove SQL Server from my web server once I roll out the data warehouse. While I agree that this isn't the most serious issue (and a quick google search has solved my problem), this seems like something that should be addressed at some point, and at the very least, documented in the install guide.
Hey Joseph,
You need to have both the Client components for Sql Server and Sql Analysis services on the machine that you are unpackaging the DW resource from. You do not need the full blown version of Sql Server on that machine.
As an alternative, you can unpackage the DW resource from the machine that you plan to execute the DTS task on. You will need Commerce Server installed on this machine to execute the DTS task, so it will be easier if you didn't want the Sql client components on your web server.
Hope this helps and let me know if you have additional questions or concerns.
Alan
Alan,
Thanks for the heads-up; I'll make a note of this the next time I set up an environment.
I'm slowly moving from a single-server deployment to a simulated production environment, and I'm trying to take note of anything out of the ordinary that's occuring during set-up. Most everything else has been really straightforward and well documented, and this is really the first issue I've come across so I thought I'd bring it to the attention of the community.
Why is the product not designed with a separate DTS installation including CS2007 CSDWDTScomponents needed to run the DTS package?
Normally all DTS packages scheduled in a timly manner , is run from a separate DW server where we not want a separat CS2007 installation, and we do not want to run them on the web server and we do not want an extra server(or license) to just create our DW and data for reports!
