ActiveX Component Can't Create Object when using DSO InterOp

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I have a didfficulties to run DSO.Server.Connect code from my web server when
it attempts to connect to analysis services in my database server. It throws
ComException with ActiveX component can't create object as error message. It
works perfectly on my development machine but not in production servers.

I copied my Repository and DSO redistributable files and placed in program
files\common files\Microsoft Shared\DSO and program files\common
files\Microsoft Shared\Repostry. All Dlls are registered successfully.

I use a Domain Account and impersonate my ASP.NET to that Domain Account.
This Domain Account works perfectly to accesing all ASP.NET pages but not the
page that using DSO.Server.Connect. I also added aspcompat directives on my
aspx page. I grant that Domain Account OLAP Administrators right on database
server.

So what is the problem that causing DSO Interop to throw this exception?
Anyone experience this before. Where can I find a step by step information
how I can get DSO work on Web Server/Database Server environment?

Any help is appreciated. Please leave ur IM or email if you wish me to
contact you. Thanks in advance.
.

Relevant Pages

  • RE: problem connecting to dbase from webservice with impersonation
    ... will acess a remote SQL Server instance, so you want to let your ASP.NET ... application run under a domain account so as to access the remote SQL ... Microsoft MSDN Online Support Lead ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Accessing files on file server from Web server
    ... > We have a web application on our web server that tries to ... > access an MS Access database that is sitting on our file ... > manager using an already established domain account. ...
    (microsoft.public.inetserver.iis.security)
  • Re: "Timeout expired" in ADO.NET
    ... Does the problem go away if you use a different web server? ... Does the problem go away if you use a different database server? ... > I usually get the exception after not using the system for a while, ...
    (microsoft.public.dotnet.framework.adonet)
  • rights issues with linked server
    ... I have a web server and database server which are not on a domain. ... web server has an app that is running on under the IUSR account and ...
    (comp.databases.ms-sqlserver)
  • Re: IIS 6 CreateObject premissions issue
    ... >> tier system so I am confident that running on Windows 2000 what I am ... >> What I am attempting is to add a Windows 2003 server box to function as ... However if it is set for anonymous access using the ... >> end boxes to specifically allow the Domain account I attempted to use as ...
    (microsoft.public.inetserver.iis.security)