Authentication problem in Connectting to Remote AS 2000 in XMLA
- From: mewmewchen@xxxxxxxxx
- Date: 8 Dec 2006 19:47:44 -0800
Hi:
I have some problems in Authentication with remote AS 2000
There are my system environment:
Remote AS 2000 server
OS:windows 2000 server
MS SQL 2000 +SP4
MS AS 2000 +SP4
MSXML 4.0+SP2
XMLA 1.1 SDK
(with virtual directory http://AS2000/XMLA and test with IE response
correct XML message.
directory access privilege is Integration Windows Authentication )
Web Server :
OS windows 2000
IIS 5.0
ASP.net 1.1 C#
connect to AS 2000 with ADOMD.net 8.0+patch
ADOMD.Net-KB893091-v8.00.0991-x86.EXE
with Connection String :
Provider=MSOLAP;Data
Source=http://RemoteAS/xmla/msxisapi.dll;Catalog=BI;User ID=admin;
Password=XXXX;
and there is a "admin" account in remote AS
(I do not change the datasource.xml)
Here comes the question:
1.when I use basic authentication in XMLA virtual directory,
connection is ok,but
when two different users logged in the web. They will conflictwith each
other.
For example
AdminA with all data access privilege in BI cueb.
UserA with half data access privilege in the BI Cube
When AdminA logged in the web , all data will show~~
Then UserA logged in the web, all data show too~~
I had tried use the Auto Synch Period =10000 attribute, but it doesn't
work.
2.when I use the Integration Windows Authentication, problem 1 is
solved.
But when I deploy all the code in my laptop.(XP+ASP.NET C# 1.1 + AS
2000) and use connection string
Provider=MSOLAP;Data
Source=http://localhost/xmla/msxisapi.dll;Catalog=BI;User ID=admin;
Password=XXXX;
there is a exception
"Connection timeout or lost,(401)non Authenticated" (sorry, i only know
the exception in chinese)
If I set the virtual directory in Basic Authentication, connection is
ok. But problem 1 appear.
I had google all the related web and posts, but still not find a
solution.
Please help me to solve it~~
Thanks a lot~
Steven
.
Relevant Pages
|
