• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1199
  • Last Modified:

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
0
cipriano555
Asked:
cipriano555
  • 6
  • 5
1 Solution
 
Jason Yousef, MSSr. BI DeveloperCommented:
0
 
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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 6
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now