Skip to Content
0
Former Member
Oct 22, 2010 at 06:39 PM

Service Level Accounts - SQL 2005 SSAS - Error connecting to OLAP

136 Views

Hi,

Can anyone please explain what to do with the service level accounts... i am facing this problem but i cant fix it.

1. For BPC 3 accounts are created in Windows... but the BPC installation sets "System admin id" as Administrator by default during the install... therefore just 2 accounts (admin id and user id) are supposed to be created.

2. Can you please explain for Analysis Services which "log on as user" is the installation guide referring to? - After installing SQL Server 2005, pag 26.

3. On BPC, while im sending data in excel, an error shows:

==================================================

Book Name:Reporte Inicial de Prueba.xls

Application : PLANNING

Status : Success

Submitted Count : 1

Accepted Count : 1

Rejected Count : 0

- Error Message -

ExecuteBaseLogic::Error connecting to OLAP: Cannot connect to the server 'servername'. The server is either not started or too busy.

-


4. The log for OLAP shows:

Message: The flight recorder was started. (Source:
?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Log\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x41210005)

Message: Service started. (Source:
?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Log\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x41210000)

Message: Service stopped. (Source:
?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Log\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x41210001)

5.After some research, it found this "The only thing that allowed Analysis Services to start was to use a local user account instead of my network logon"

6. Apparently BPC "works" since i am able to send, retrieve, create dimensions and applications, but the error shows different.

Also, i am unable to modify applications. The "cubes" for applications are available in Analysis services, but im still looking how to access to the cube to see whats inside.

7. i restarted sendgovernor already and all SQL services.

Thanx in advance.