Showing posts with label SSAS. Show all posts
Showing posts with label SSAS. Show all posts

Friday, August 21, 2009

IIS on Windows 64 Bit

 

Installing XMLA on IIS 64bit you may face problem with IIS like

“Service Unavailable”

Checking into event log gave the following information

<!--[if gte mso 9]> Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 <![endif]--><!--[if gte mso 9]> <![endif]--> <!--[endif]-->Could not load all ISAPI filters for site/service. Therefore startup aborted.

and

<!--[if gte mso 9]> Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 <![endif]--><!--[if gte mso 9]> <![endif]--> <!--[endif]-->

ISAPI Filter ‘C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_filter.dll’ could not be loaded due to a configuration problem. The current configuration only supports loading images built for a AMD64 processor architecture. The data field contains the error number. To learn more about this issue, including how to troubleshooting this kind of processor architecture mismatch error, see http://go.microsoft.com/fwlink/?LinkId=29349.

Searching for it the solution that I found was the following

// Disabling the 32bit mode for your web site.

cscript C:\inetpub\adminscripts\adsutil.vbs SET W3SVC/AppPools/Enable32bitAppOnWin64 0

and then the following

// Registering ASP.NET 2.0 as the default framework for that web site

C:\Windows\Microsoft.NET\Framework64\v2.0.50727>
aspnet_regiis.exe -i

This will help you resolve this error.

 

Saulat

Monday, June 29, 2009

SSAS 2008 Cube Process OLE DB error: OLE DB or ODBC error: Operation canceled; HY008.

Don’t be confused when ever you face this clueless error while processing your cubes in SASS 2008. Read the rest of the article here ssas 2008 cube process ole db error ole db or odbc error operation-canceled