Tuesday, August 12, 2008

SAS Integration Technologies and Vista

Ok, I am sure that I will get some grief about this but I needed to submit my SAS code from a .NET application. this was on my new PC which is running Vista 32. Anyway, no matter what I did, I kept getting the following error:

"Retrieving the COM class factory for component with CLSID {440196D4-90F0-11D0-9F41-00A024BB830C} failed due to the following error: 80040154."

Well, normally that is addressed by simply installing the IntTech client and setting permissions to None in dcomcnfg. It didn't work this time.

Here is what i did to fix it (people can try these in isolation to see which one is the root):

1. Right-click on the the inttech.exe file and run it in compatibility mode for Win XP SP2

2. Go into dcomcnfg and set every single SAS DCOM object with permissions of None.

I could play with this some more but I am now behind.

Update 3/31/2010

This worked for me on Windows 7 64 and when the dcom stuff failed:

To register the IOM server,

1) Copy SASVRSRV.DLL from !SASROOT\CORE\SASEXE which can be found on
the SAS System CD or a Network copy of SAS to your Client
!SASROOT\CORE\SASEXE directory.

2) From a command prompt run !SASROOT\SAS.EXE /REGSERVER

Cisco Information Server (CIS) and MS OLAP

Ok, so my recent issue was integrating CIS with Microsoft OLAP cubes. The normal way to do this is to set up MS OLAP (SSAS) with a website a...