I am an instructor for a data warehouse design and implementation course at a local college, and I have run into a problem that I have not been able to fix. Hopefully someone out there can help. It is the first time this course is being taught
in a new lab where we are running SQLExpress 2008 Developer Edition, with a local server instance installed on each workstation, using Windows authentication; this configuration was done by our local LAN/network manager. We have created a Management
Studio source database and a Management Studio warehouse database, using a star schema design. We have successfully created SSIS packages to extract from the source tables and populate the warehouse tables. We have been able to create a DSV in
SSAS. When we attempt to process and browse the cube, it fails with a connection refused error from the server. Configuration Manager tells me the SSAS server process is running. The data connection works when checked. We get the same
error regardless of which impersonation option is selected. What have I missed? Can the configuration be adjusted to get around this? I have spent several hours trying everything I could think of, with no success - it is getting frustrating.
Please advise. Thanks in advance.
View Complete Post