dbTalk Databases Forums  

How to connect from ASP.NET

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


Discuss How to connect from ASP.NET in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
steveg@payerpath.com
 
Posts: n/a

Default How to connect from ASP.NET - 04-26-2005 , 02:44 PM






Hi all,

I'm fairly new to both Analysis Server and ASP.NET programming and am
having problems getting an ASP.NET application connected to an Analysis
Server data source. I've been reading up about ADOMD.NET and XMLA and
impersonation and honestly am in over my head. Can someone explain to
me, in the simplest terms possible, how to get connected.


The environment that my solution needs to work in is...

The Analysis Server is my Production SQL Server running SQL 2k
Enterprise Edition. It does not, and will not, have IIS running.

I'm trying to add functionality to an existing ASP.NET web application
which is set up to "Allow Anonymous Access" and the account used for
anonymous access is IUSR_<machine> which I'm told that, for security
reasons, I'm not allowed to change.

Both the AS box and web server are running Windows 2000 and have the
most recent service packs and such.

Given the above how can I get connected? TIA.

Gutz


Reply With Quote
  #2  
Old   
Richard Tkachuk [MSFT]
 
Posts: n/a

Default Re: How to connect from ASP.NET - 04-26-2005 , 04:27 PM






Hi Steve,

That's pretty restrictive. If these are hard and fast rules, you'll have to
give access to the Anonymous group to your cubes.

You not on Windows XP or Server 2003. For benefit of those that are, those
people need to explicitly designate that the Everyone group contains
Anonymous. See
http://support.microsoft.com/default...b;en-us;278259


Hope this helps,
Richard

--
_______________
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.

<steveg (AT) payerpath (DOT) com> wrote

Quote:
Hi all,

I'm fairly new to both Analysis Server and ASP.NET programming and am
having problems getting an ASP.NET application connected to an Analysis
Server data source. I've been reading up about ADOMD.NET and XMLA and
impersonation and honestly am in over my head. Can someone explain to
me, in the simplest terms possible, how to get connected.


The environment that my solution needs to work in is...

The Analysis Server is my Production SQL Server running SQL 2k
Enterprise Edition. It does not, and will not, have IIS running.

I'm trying to add functionality to an existing ASP.NET web application
which is set up to "Allow Anonymous Access" and the account used for
anonymous access is IUSR_<machine> which I'm told that, for security
reasons, I'm not allowed to change.

Both the AS box and web server are running Windows 2000 and have the
most recent service packs and such.

Given the above how can I get connected? TIA.

Gutz




Reply With Quote
  #3  
Old   
Joel Leong
 
Posts: n/a

Default RE: How to connect from ASP.NET - 06-08-2005 , 01:57 AM



I'm also facing the similar problem. Have you sorted out how to solve this
problem?

"steveg (AT) payerpath (DOT) com" wrote:

Quote:
Hi all,

I'm fairly new to both Analysis Server and ASP.NET programming and am
having problems getting an ASP.NET application connected to an Analysis
Server data source. I've been reading up about ADOMD.NET and XMLA and
impersonation and honestly am in over my head. Can someone explain to
me, in the simplest terms possible, how to get connected.


The environment that my solution needs to work in is...

The Analysis Server is my Production SQL Server running SQL 2k
Enterprise Edition. It does not, and will not, have IIS running.

I'm trying to add functionality to an existing ASP.NET web application
which is set up to "Allow Anonymous Access" and the account used for
anonymous access is IUSR_<machine> which I'm told that, for security
reasons, I'm not allowed to change.

Both the AS box and web server are running Windows 2000 and have the
most recent service packs and such.

Given the above how can I get connected? TIA.

Gutz



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.