SQL 2005 SPN (SSAS/SSRS/SQL)

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…

2

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:…

1

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…

1