When processing it is the security credentials of the msmdsrv process which
is actually used for processing. So depending on how you have Oracle
configurated, it must be allowed access. Do a Start\ Services\
MSSQLServerOLAPService and look to see what its logon credentials are.
When you are creating objects you are using your own interactive
credentials. When processing (cubes, partitions, dims, etc.) -- it is the
service on the server which is doing the data access for you.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Graeme" <anonymous (AT) discussions (DOT) microsoft.com> wrote
Quote:
Hi there,
newbie to Analysis Services.
My warehouse is on Oracle, and I've created MyOracleDB as
the data source of my Analysis Server. I can connect to
the data source, browse the tables, create cubes and
dimensions.
However, when I try and process a cube, I receive the ORA-
12154 error: TNS cannot resolve service name.
Can someone suggest why this might be, when I can see the
Oracle database when I'm creating the objects?
Thanks
Graeme
|
Newbie: TNS error processing Cubes against Oracle DB -
03-02-2005
, 10:18 AM
Linear Mode
