Forum

Welcome Guest! To enable all features please try to register or login.
HD_prijavio
#1 Posted: : 02 March 2011 16:31:00(UTC)
HD_prijavio

Rank: Datalab

You have been a member since:: 14/08/2009(UTC)
Objave: 1

Was thanked: 2 time(s) in 2 post(s)
Punjenje koci ne prolazi i to s 2 različite greške u zavisnosti da li punjenje pokrenem na serveru ili na klijentu.

Na klijentu mi javlja:
-----------------------------------
Error full processing analysis database:
Server: The operation has been cancelled.
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Dingo', Name of 'Item 8' was being processed.
Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Dingo', Name of 'Dingo'.
OLE DB error: OLE DB or ODBC error: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.; 28000.
-----------------------------------

NETWORK SERVICE je stavljen u administratore na AS-u i u rolu korinsika na bazi.


Na serveru mi javlja:

Priprema procesiranja.
-----------------------------------
This machine did not respond in 60 seconds. Check your system settings!
-----------------------------------

Na AS se normalno spajam preko menagementa ili kroz AK.

OS je Windows Server Standard 2008 R2, a SQL je 2008 R2.
HD_odgovorio
#2 Posted: : 02 March 2011 16:31:00(UTC)
HD_odgovorio

Rank: Datalab

You have been a member since:: 14/08/2009(UTC)
Objave: 0

Was thanked: 1 time(s) in 1 post(s)
Pozdrav,
Prijedlog je da promijenite nalog pod kojim pokrećete AS server
sa NETWORK SERVICE na LOCAL SYSTEM ACCOUNT i restartate server.
Korisnike AS-a dodajte u administratorsku grupu.



Pozdrav,

Za ovu prvu grešku pomoglo je mijenjanje log on accounta za AS servis.

Problemi su mi sada na klijentima, imam dvije opcije:

1. Ista mašina, 2 različita domenska korisnika, oba imaju domain admin prava i prava na AS-u i na bazi AS-a. Na jednom korisniku (na istoj mašini) radi bez problema, na drugom dobijam grešku:

Test OLAP connection: Provider cannot be found. It may not be properly installed.
(ponovljen install OWC-a)

2. Isti domenski korisnik, različita domesnka mašina, ugašen firewall, PING radi. Jedna mašina se OK spaja, a s druge kaže:

Test OLAP connection: Cannot connect to the server ... Server is busy or not started




Pozdrav,

Napravite ovako :)

-- 2. Isti domenski korisnik, različita domesnka mašina

MSSAS server mora biti u istoj domeni kao i korisnik jer se na osnovu toga provjerava Widnows security
Znači, MSSAS ne dozvoljava mijesanje korisnika i domena ili racunala i domena.

1. Ista mašina, 2 različita domenska korisnika, oba imaju domain admin prava i prava na AS-u i na bazi

ista priča, MSSAS ne nalazi korisnika u istoj domeni,

-- Test OLAP connection: Provider cannot be found. It may not be properly installed.
-- (ponovljen install OWC-a)

OWC nije provider, owc su samo komponente za prikaz podataka
Provider u ovom slucaju je:
Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider , ili Microsoft SQL Server 2008 Analysis Services 10.0 OLE DB Provider

Ovde ima sve opisano, pratite korak po korak.

https://usersite.datalab...+bhipA8xoq3EaDqil3ACoOk=

Lp,
Rss Feed  Atom Feed
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Orange-Grey Theme Created by Ingo Herbote (WatchersNET.de)
Powered by YAF 1.9.6.1 Under DNN | YAF © 2003-2025, Yet Another Forum.NET
This page was generated in 0.437 seconds.