What is SPN? An SPN is a unique identifier for a service on a network that uses Kerberos authentication. It consists of a service class, a host name, and a port. On a network that uses Kerberos authentication, an SPN for the server must be registered under either a built-in computer account (such as NetworkService…


SSAS(64 Bit) and Oracle Client Issues

While trying to create an Analysis Service Data Source that connects to Oracle using ORAOLEDB Provider, you get an error – TITLE: Connection ManagerTest connection failed because of an error in initializing provider. ORA-12154: TNS:could not resolve the connect identifier specifiedBUTTONS: EnvironmentWindows 2003 x64 Sp2SQL Server 2005 x64 SP2 CU10 There can be 2 Scenerios:…


SSAS Performance Counter Error while collecting BLG file Reference error message: Access is denied.

While Creating BLG file for SSAS counters getting below mentioned error message: System Log:Event Type:        ErrorEvent Source:    SideBySideEvent Category:                NoneEvent ID:              59Date:                     12/1/2008Time:                     1:52:35 AMUser:                     N/AComputer:          DBANALYSIS01Description:Generate Activation Context failed for d:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\bin\msmdctr90.DLL. Reference error message: Access is denied.For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp Application Log:The description for Event…


Configuring Datapump in IIS 7

Configuring HTTP Access to SQL Server 2005 or SQL 2008 Analysis Services on Microsoft Windows Server 2008 Getting BinariesCopy the contents of the %Installation folder%\OLAP\bin\isapi directory into the folder you would like to become the base for the virtual directory in IIS. In this example, we are going to copy all the files from the…


SSAS 2005:Performance

  Which Engine (Storage / Forumal) causing MDX Performance Issue? Improve MDX Performance               


Which Engine (Storage / Formula) causing MDX Performance Issue?

  Follow below mentioned steps: -Set Profiler with Query Begin and Query End Event, Run Profiler Trace and Execute MDX which you need to tune. -Stop Profiler trace and save trace to table in RDBM -What you need to do is run the following SQL query against the table in which you had saved Profiler Trace Select…

SSAS:Informative Links

  Links Related to Analysis Services:   SQL Server 2005 Analysis Services Tutorial http://msdn.microsoft.com/en-us/library/ms170208(SQL.90).aspx   Analysis Services 2005 Migration http://www.microsoft.com/technet/prodtechnol/sql/2005/asmigrtn.mspx   Analysis Services 2005 Performance White Paper http://download.microsoft.com/download/8/5/e/85eea4fa-b3bb-4426-97d0-7f7151b2011c/SSAS2005PerfGuide.doc   SQL Server Best Practices Article: Identifying and Resolving MDX Query Performance Bottlenecks in SQL Server 2005 Analysis Services http://www.microsoft.com/downloads/details.aspx?FamilyID=975C5BB2-8207-4B4E-BE7C-06AC86E24C13&displaylang=en