Microsoft SSAS not working properly 2008 r2

I cannot get SSAS to work properly.  It won't let me process a cube or explore data.  My software is a new install, I have never successfully processed a cube with this install.

I am using Windows authentication.  When I "Test Connection" it succeeds. I am able to create a data source view and even run the cube wizard and create a cube.  But I cannot process, and I cannot explore the data from the data source view.  

When I try to explore the data I get this error message:

Class not registered (Exception from HRESULT: 0X80040154 (REGDB_E_CLASSNOTREG))

 When I try to process, I get this error:

Error      2      The project could not be deployed to the '.' server because of the following connectivity problems :  A connection cannot be made. Ensure that the server is running.  To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server.


OPERATING SYSTEM: Windows 7 Ultimate  64 bit operating system

About Visual Studio Info:

Microsoft Visual Studio 2008
Version 9.0.30729.4462 QFE
Microsoft .NET Framework
Version 3.5 SP1

Installed Edition: IDE Standard

Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU (KB945282)   KB945282
This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/945282.

Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU (KB946040)   KB946040
This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/946040.

Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU (KB946308)   KB946308
This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/946308.

Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU (KB946344)   KB946344
This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/946344.

Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU (KB946581)   KB946581
This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/946581.

Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU (KB947173)   KB947173
This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/947173.

Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU (KB947540)   KB947540
This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/947540.

Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU (KB947789)   KB947789
This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/947789.

Security Update for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU (KB2251487)   KB2251487
This security update is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU.
If you later install a more recent service pack, this security update will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/2251487.

Security Update for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU (KB972222)   KB972222
This security update is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU.
If you later install a more recent service pack, this security update will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/972222.

SQL Server Analysis Services  
Microsoft SQL Server Analysis Services Designer
Version 10.50.1600.1

SQL Server Integration Services  
Microsoft SQL Server Integration Services Designer
Version 10.50.1600.1

SQL Server Reporting Services  
Microsoft SQL Server Reporting Services Designers
Version 10.50.1600.1

INFORMATION ABOUT SSMS

Microsoft SQL Server Management Studio                                    10.50.1617.0
Microsoft Analysis Services Client Tools                                    10.50.1617.0
Microsoft Data Access Components (MDAC)                                    6.1.7600.16385
Microsoft MSXML                                    3.0 6.0
Microsoft Internet Explorer                                    8.0.7600.16385
Microsoft .NET Framework                                    2.0.50727.4961
Operating System                                    6.1.7600
cipriano555Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jason Yousef, MSSr. BI  DeveloperCommented:
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
cipriano555Author Commented:
ok, thanks, still need this problem resolved.
0
Jason Yousef, MSSr. BI  DeveloperCommented:
Did you install the Office Web Components and it didn't' fix it?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

cipriano555Author Commented:
I'm not using the web and don't know what the web components are, so I was hoping there would be another solution in terms of something familiar. If this is the most promising route, I can see if I can figure out how to install them, whatever they are.
0
cipriano555Author Commented:
I have Windows 7 and Office 2010.  The above link is for Web Components 2003.  I'm afraid of messing something up since it is an earlier version of Office.  Any input on that?

The Office Web Components have been discontinued in Office 2007,

The Pivot Table web component does not function on Windows 7.[8]

0
Jason Yousef, MSSr. BI  DeveloperCommented:
If you at least have looked at the blog post I sent you, I also had the same scenario, office 2010 and window 7!!

http://asqlb.blogspot.com/2010/12/ssas-class-not-registered-exception.html
0
cipriano555Author Commented:
@Huslayer,

I did look at the post, and that's when I noticed the web components were for  Office 2003.  OK, I'll try it, just wanted to make sure I didn't mess anything up.  I'll let you know what happens.

Cipriano
0
Jason Yousef, MSSr. BI  DeveloperCommented:
That's the exact setup that I had, windows 7 enterprise, office 2010, and sql 2008R2
0
cipriano555Author Commented:
Dear Huslayer,

It worked!  You were exactly right. Thanks!

Cipriano
0
cipriano555Author Commented:
Thanks!
0
Jason Yousef, MSSr. BI  DeveloperCommented:
Great....had been in your shoes!! follow my blog then, lol  :)
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.