dbTalk Databases Forums  

How to connect from web application to remote AS

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss How to connect from web application to remote AS in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
yevgeniy.tarashchanskiy@eclipsys.com
 
Posts: n/a

Default How to connect from web application to remote AS - 10-25-2004 , 04:09 PM






I created a C# dll that uses DSO interface for Analysis Services.
This dll works fine from Windows application: it connects to the Analysis Server on the remote computers and updates cubes’ and roles’ data. When I tried to use the same assembly from the web application, I can’t connect to the remote server.
I used “INFO: Implementing Impersonation in an ASP.NET Application” instructions
to replace identity to my account and changed the account that the Aspnet_wp.exe process runs under to the System account in the <processModel> configuration section of the Machine.config file.
I still getting error:
“Cannot connect to the Analysis server on computer “compName” \r\n Connection to the server is lost."
I don’t see any other possibility to configure connection. DSO interface uses two lines of code:

DSO.Server myServer = new DSO.Server();
myServer.Connect(“myServerName”);

and runs all other stuff under the hood.
Any suggestion how to debug? May be document that describes what is going on?
May be parameters in the
LogonUser(userName, domain, password, LOGON32_LOGON_INTERACTIVE,
LOGON32_PROVIDER_DEFAULT, token)
are wrong?



************************************************** ********************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.