Re: Can you update/process AS2005 cube with AMO and SQL authentication

so, why you don't use the NT authentication method but based on the service
account (not the user account or a SQL login)?


<aabdel1@xxxxxxxxx> wrote in message
news:1157980775.731991.9660@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
As an example, an attribute can be added to a dimension:
Dimension dim;
DimensionAttribute attr;
dim = db.Dimensions.GetByName("Product");
attr = dim.Attributes.Add("Weight");
attr.KeyColumns.Add(CreateDataItem(db.DataSourceViews[0], "DimProduct",
"Weight"));
attr.AttributeHierarchyEnabled = false;
db.Update(UpdateOption.ExpandFull);
db.Process(ProcessType.ProcessFull);

if you have Connection to the datasource as the following using SQL
Server Audentication:
db.DataSources(0).ConnectionString "Provider=SQLNCLI.1;Data
Source=MyServerNamedInstance;Persist Security Info=True;User
ID=sa;Initial Catalog=AdventureWorksDW" String

The following exception will be returned trying to process the
database:
+ ex {"OLE DB error: OLE DB or ODBC error: Login failed for user
'sa'.; 28000.
' Errors in the high-level relational engine. A connection
could not be made to the data source with the DataSourceID of
'AdventureWorksDW', Name of 'AdventureWorksDW'.
' Errors in the OLAP storage engine: An error occurred while
the dimension, with the ID of 'Product', Name of 'Product' was being
processed.
' Errors in the OLAP storage engine: An error occurred while
the 'Category' attribute of the 'Product' dimension from the
'AmoAdventureWorks' database was being processed.
' OLE DB error: OLE DB or ODBC error: Login failed for user
'sa'.; 28000.
' Errors in the high-level relational engine. A connection
could not be made to the data source with the DataSourceID of
'AdventureWorksDW', Name of 'AdventureWorksDW'.
' Errors in the OLAP storage engine: An error occurred while
the dimension, with the ID of 'Product', Name of 'Product' was being
processed.
' Errors in the OLAP storage engine: An error occurred while
the 'Product Line' attribute of the 'Product' dimension from the
'AmoAdventureWorks' database was being processed.
' OLE DB error: OLE DB or ODBC error: Login failed for user
'sa'.; 28000.
' Errors in the high-level relational engine. A connection
could not be made to the data source with the DataSourceID of
'AdventureWorksDW', Name of 'AdventureWorksDW'.
' Errors in the OLAP storage engine: An error occurred while
the dimension, with the ID of 'Product', Name of 'Product' was being
processed.
' Errors in the OLAP storage engine: An error occurred while
the 'List Price' attribute of the 'Product' dimension from the
'AmoAdventureWorks' database was being processed.
' "} System.Exception




Jeje wrote:
cube metadata vs access to source data are 2 differents things
when you say "We have an application that updates cube metadata
programmatically"
do you talk about an application that add dimension, cubes, measures
etc...
in an OLAP Database?
This type of access only use Windows authentication, there is no SQL
Server
login because its SSAS not SQL Server.

Can you describe what is your issue, where and when you suffer a
limitation?


"Stan Kondrat" <StanKondrat@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8CEA8915-22EC-4610-9275-ADE61934F419@xxxxxxxxxxxxxxxx
I have seen a few post on this before. If you use SQL Server user and
password in Data Source connection string, the password is never
returned
to
the AMO client. If you're doing any updates to the cube (and call AMO
Update
method) the subsequent Process method will fail because the cube was
updated
with an incomplete connection string.

Is there any way out of this mess? Are we forced to use Windows
authentication to perform this kind of operations? Did Microsoft overdo
something with security here?

We have an application that updates cube metadata programmatically and
cannot prompt the user for the password.

Stan



.

Relevant Pages

  • Re: Can you update/process AS2005 cube with AMO and SQL authentication
    ... if you have Connection to the datasource as the following using SQL ... ' Errors in the OLAP storage engine: ... the dimension, with the ID of 'Product', Name of 'Product' was being ... ' OLE DB error: OLE DB or ODBC error: Login failed for user ...
    (microsoft.public.sqlserver.olap)
  • Re: Performance problems incrementally processing a dimension
    ... > can see the SQL statement that is issued for dimension processing. ... Deleting members from a dimension requires a full ... We currently use the incremental update processing option on the ...
    (microsoft.public.sqlserver.olap)
  • Re: Strange processing error.
    ... I've a sneaking suspicion that this may be down to memory, ... Analysis Services previously (especially when trying to share a box w/ a SQL ... There are around 7-10 dimension connected / measure group. ... cube Analysis Services Execute DDL Task ...
    (microsoft.public.sqlserver.olap)
  • RE: Cant deploy AdventureWorksDW cube
    ... not found in the corresponding column in the dimension table. ... Subject: Can't deploy AdventureWorksDW cube ... installation disk. ... Warning 1 Errors in the OLAP storage engine: ...
    (microsoft.public.sqlserver.olap)
  • Re: SSAS: Processing Cube hangs
    ... Your LEFT JOIN query should not be that much faster than the query that ... syntax that is effectively be equivalent to using inner joins. ... The query optimizer in SQL Server knows how to work with both syntaxes ... Dimension User: about 200 records ...
    (microsoft.public.sqlserver.olap)
Loading