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

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: cannot find dimension member in a name-binding function
    ... I had the same problem once - after openning the connection I got "cannot ... find dimension member" error, but from the 2nd run on evrything went fine. ... After this the same query started to work normally, ...
    (microsoft.public.sqlserver.olap)
  • Re: Corners in metric spaces
    ... I have a kind request of help for you Mr. Sheskey ... there is a connection to the connectivity of Mandelbrot-set. ... S has finite corner rank Hausdorff dimension of S is integer ...
    (sci.math)
  • Affine and projective manifolds
    ... It happens that one is given a differential manifold M of dimension n ... Is it not weird that this is usually called an affine connection? ... interested in the tangent spaces TM but rather in the projectivized ...
    (sci.math)
  • Re: Infinite Crisis # 2
    ... >> science that Myxyzptlk uses. ... >> the 5th dimension because fifth dimesionians ... >Ted Knight was right! ... I don't see the connection. ...
    (rec.arts.comics.dc.universe)
  • 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)