I need to connect with ADOMD to an OLAP DB.

I want to specifide the user name and password in the connection string in
the let_ActiveConnection property as follows:

Provider=MSOLAP;Password=pippo;Persist Security Info=True;User ID=pluto;Data
Source=MyServer;Initial Catalog=MDX30;Client Cache Size=25;Auto Synch
Period=10000

I receive a generic error massage.

If I try to connect without User ID and Password it work correctly.

Any ideas??

Thanks you

Analysis Services only supports NT integrated security. It does not have the
similar concept as what SQL Server RDBMS calls "standard secruity". The
nearest thing that we have is that if you use http access, you can specify
the uid/pwd in the connection to specify what login to use against IIS with
basic or digest authentication. In that case, the uid/pwd is for the NT
account to use against IIS.

There are several resources which talk about this. Besides BOL, see the
following two white papers,

SSAS Operations Guide:
http://www.microsoft.com/technet/pro.../anservog.mspx
(in the section titled "Security Administration"

Improved Web Connectivity in Microsoft SQL Server 2000 Analysis Services
http://msdn.microsoft.com/library/de...l_datapump.asp

Hope that helps.
--
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.

"Ale Dori" <AleDori (AT) discussions (DOT) microsoft.com> wrote

Unfortunately, the http access requires the Enterprise Edition of Analysis
Services (AS).

I'm not certain what transport mechanism AS uses by default (named pipes?),
but the current logon credentials of the client app are used for
authentication. Unfortunately, if AS is accessed from a middle-tier, such as
IIS, then the it may be impersonating the real client user, and these
impersonated credentials are not used for authentication across a network
link (it works if IIS and AS are on the same box).

....apologies if the rest of this response assumes middle-tier deployment.
This is based on your desire to set an explicit username rather than use the
current logon credentials.

One other alternative that works is to delegate your ADOMD object creation
to a DCOM server process. In other words, have a DCOM server that simply
returns you connection, catalog, and cellset objects on request. The
middle-tier can then access the proxies of those objects and perform normal
operations on them, just as though it'd created them itself. The extra COM
messages between the 2 processes (e.g. DLLHOST and DCOM server) is more than
balanced by 2 big advantages:

1) You can use dcomcnfg to configure your DCOM server. For instance, it can
be made to run under a specific non-impersonated account, and this would
then be used for authentication to AS. It can also be made to accept
requests from one or more specific groups of client accounts. In other
words, it allows secure authentication in a situation that would otherwise
require opening up cube access to anonymous accounts

2) The DCOM server can be given a configurable thread pool, and this allows
a ceiling to be placed on the total "client cache" associated with PTS
(which ADOMD goes through). Without this, each ASP thread will have its own
PTS client cache. With the default ASP thread count being 25 per processor,
this can easily use up all the available virtual memory for the DLLHOST
process. Simply restricting the ASP thread count is too severe, and will
limit the total number of concurrent client requests, not just those with
OLAP activity.

Tony Proctor

"Ale Dori" <AleDori (AT) discussions (DOT) microsoft.com> wrote

Not sure whether it's relevant, but I looked back through my system event
log to the last incident that I remember the date/time for. There was the
following entry at almost exactly the same time:

Source: DCOM
Event ID: 10010
User: NT AUTHORITY\SYSTEM
The server {DFDE2592-40A4-42BC-A35E-FD0BF76CA4D5} did not register with DCOM
within the required timeout.

Tony Proctor

"Dave Wickert [MSFT]" <dwickert (AT) online (DOT) microsoft.com> wrote

Sorry guys, ignore that. Replied to a different thread, but in the wrong
group...duh!

Tony Proctor

"Tony Proctor" <tony_proctor (AT) aimtechnology_NoMoreSPAM_ (DOT) com> wrote

Hi Dave,

I need to convert cellset into XML formated data, so that I can view the
result in ChartSpace. Can u guide me what is the similar method for cellset
as dataset.writexml()?

Thanking you.
Shailesh.

"Dave Wickert [MSFT]" wrote: