Error - Xml Analysis Services - database does not exist

Error - Xml Analysis Services - database does not exist

Post by Luis Aleja » Sat, 12 Feb 2005 00:22:24


HI,

I'm trying to test Analysis Services from a Web Application. I've installed
Visual Studio .NET Web Control for BI and Microsoft XML For Analysis SDK. At
"C:\Program Files\Microsoft XML For Analysis SDK\Config" there is a file
named "datasources.xml" with this datasource configuration:

<DataSource>
<DataSourceName>Local</DataSourceName>
<DataSourceDescription>Microsoft Analysis Server 2000 on local
machine</DataSourceDescription>
<URL>http://localhost/xmla/msxisapi.dll</URL>
<DataSourceInfo>Provider=MSOLAP.2;Data Source=local</DataSourceInfo>
<ProviderName>Microsoft XML for Analysis</ProviderName>
<ProviderType>
<TDP/>
<MDP/>
<DMP/>
</ProviderType>
<AuthenticationMode>Unauthenticated</AuthenticationMode>
</DataSource>

These statements are implemented:

** Extract datasources procedure ***
MSSQLBI.XmlAnalysis.Data.DataSource[] dataSources =
MSSQLBI.Web.Olap.OlapControl.GetDataSourceList(txtUrl.Text, null);
ddlDataSource.Items.Clear();
for(int i=0; i<dataSources.Length;i++)
ddlDataSource.Items.Add(dataSources[i].DataSourceInfo); }


** Extract catalogs procedure ***
MSSQLBI.XmlAnalysis.Data.DataSource[] dataSources =
MSSQLBI.Web.Olap.OlapControl.GetDataSourceList(txtUrl.Text, null);
int nIndex =
ddlDataSource.Items.IndexOf(ddlDataSource.Items.FindByValue(ddlDataSource.SelectedItem.Value)); ddlCatalogs.Items.Clear(); MSSQLBI.XmlAnalysis.Data.Catalog[] catalogs = MSSQLBI.Web.Olap.OlapControl.GetCatalogList(dataSources[nIndex], null); for(int i=0; i<catalogs.Length;i++) ddlCatalogs.Items.Add(catalogs[i].Name);When I test it with<DataSourceInfo>Provider=MSOLAP.2;Data Source=local</DataSourceInfo>I always get the same error message "An error occurred while processing therequest", and if I change it and assign a database registered in AnalysisServer named WebStore like this:<DataSourceInfo>Provider=MSOLAP.2;Data Source=local;InitialCatalog=WebStore</DataSourceInfo>I get "WebStore database does not exist".What should I do in order to recognize databases registered in AnalysisServices?Are catalogs like databases? Or, Are they generated connections in otherlocation?SO: XPSQL Server 2000 SP3Analysis Services SP3Microsoft Visual Basic .NetThanks in advanceLuis L.
 
 
 

Error - Xml Analysis Services - database does not exist

Post by Akshai Mir » Sat, 12 Feb 2005 05:30:03

Catalogs are identical to databases. Firstly, which version of the XMLA SDK
are you using? Secondly, are you able to connect using the samples that come
with the XMLA SDK?

As far as I know, the Web Control does not work against version 1.1 of the
XMLA SDK... So I'd suggest to try out the samples first before moving to the
control.

Thanks,
Akshai


installed
At
ddlDataSource.Items.IndexOf(ddlDataSource.Items.FindByValue(ddlDataSource.Se
lectedItem.Value)); ddlCatalogs.Items.Clear();
MSSQLBI.XmlAnalysis.Data.Catalog[] catalogs =
MSSQLBI.Web.Olap.OlapControl.GetCatalogList(dataSources[nIndex], null);
for(int i=0; i<catalogs.Length;i++)
ddlCatalogs.Items.Add(catalogs[i].Name);When I test it
with<DataSourceInfo>Provider=MSOLAP.2;Data Source=local</DataSourceInfo>I
always get the same error message "An error occurred while processing
therequest", and if I change it and assign a database registered in
AnalysisServer named WebStore like
this:<DataSourceInfo>Provider=MSOLAP.2;Data
Source=local;InitialCatalog=WebStore</DataSourceInfo>I get "WebStore
database does not exist".What should I do in order to recognize databases
registered in AnalysisServices?Are catalogs like databases? Or, Are they
generated connections in otherlocation?SO: XPSQL Server 2000 SP3Analysis
Services SP3Microsoft Visual Basic .NetThanks in advanceLuis L.

 
 
 

Error - Xml Analysis Services - database does not exist

Post by Luis Aleja » Sat, 12 Feb 2005 06:22:13

i,

XMLA SDK 1.0
i cant be able to connect using the samples.

What do you think I can do to solve that problem,

Thanks in advance,


"Akshai Mirchandani [MS]" < XXXX@XXXXX.COM > escribien el
mensaje news: XXXX@XXXXX.COM ... >> Catalogs are identical to databases. Firstly, which version of the XMLA >> SDK >> are you using? Secondly, are you able to connect using the samples that >> come >> with the XMLA SDK? >> >> As far as I know, the Web Control does not work against version 1.1 of the >> XMLA SDK... So I'd suggest to try out the samples first before moving to >> the >> control. >> >> Thanks, >> Akshai >> -- >> This posting is provided "AS IS" with no warranties, and confers no rights >> Please do not send email directly to this alias. This alias is for >> newsgroup >> purposes only. >> >> "Luis Alejandro Leal"<< XXXX@XXXXX.COM >> wrote in message >> news: XXXX@XXXXX.COM ... >>> HI, >>> >>> I'm trying to test Analysis Services from a Web Application. I've >> installed >>> Visual Studio .NET Web Control for BI and Microsoft XML For Analysis SDK. >> At >>> "C:\Program Files\Microsoft XML For Analysis SDK\Config" there is a file >>> named "datasources.xml" with this datasource configuration: >>> >>> < >>> <Loca< >>> <Microsoft Analysis Server 2000 on local >>> machin< >>> <http://localhost/xmla/msxisapi.dl< >>> <Provider=MSOLAP.2;Data Source=loca< >>> <Microsoft XML for Analysi< >>> < >>> < >>> < >>> < >>> < >>> <Unauthenticate< >>> < >>> >>> These statements are implemented: >>> >>> ** Extract datasources procedure *** >>> MSSQLBI.XmlAnalysis.Data.DataSource[] dataSources = >>> MSSQLBI.Web.Olap.OlapControl.GetDataSourceList(txtUrl.Text, null); >>> ddlDataSource.Items.Clear(); >>> for(int i=0; < ddlDataSource.Items.Add(dataSources[i].DataSourceInfo); } >>> >>> >>> ** Extract catalogs procedure *** >>> MSSQLBI.XmlAnalysis.Data.DataSource[] dataSources = >>> MSSQLBI.Web.Olap.OlapControl.GetDataSourceList(txtUrl.Text, null); >>> int nIndex = >>> >> ddlDataSource.Items.IndexOf(ddlDataSource.Items.FindByValue(ddlDataSource.Se >> lectedItem.Value)); ddlCatalogs.Items.Clear(); >> MSSQLBI.XmlAnalysis.Data.Catalog[] catalogs = >> MSSQLBI.Web.Olap.OlapControl.GetCatalogList(dataSources[nIndex], null); >> for(int i=0; < ddlCatalogs.Items.Add(catalogs[i].Name);When I test it >> wit<Provider=MSOLAP.2;Data Source=loca<I >> always get the same error message "An error occurred while processing >> therequest", and if I change it and assign a database registered in >> AnalysisServer named WebStore like >> this<Provider=MSOLAP.2;Data >> Source=local;InitialCatalog=W
 
 
 

Error - Xml Analysis Services - database does not exist

Post by Akshai Mir » Sat, 12 Feb 2005 07:14:53

'm guessing that the problem has to do with authentication -- perhaps your
virtual directory is configured to use Anonymous authentication and the
IUSR_xxx or IWAM_xxx user doesn't have permission to access the database.
There is a way to trace user logons to Analysis Services (see for example
this thread
http://groups-beta.google.com/group/microsoft.public.sqlserver.olap/messages/b5168de8e22d4905,20327bfe51062c88,6e10bfc2e05c50c3,babd6a432c87d70d,1415f0b3c7cb08e6) -
- you can verify this theory and change the security on the virtual
directory if it is correct.

Also, you should be able to debug the sample apps to see exactly what is in
the XML response and it may give more information.

Thanks,
Akshai
"Luis Alejandro Leal" < XXXX@XXXXX.COM > wrote in message
news: XXXX@XXXXX.COM ...
the >>>> XMLA SDK... So I'd suggest to try out the samples first before moving to >>>> the >>>> control. >>>> >>>> Thanks, >>>> Akshai >>>> -- >>>> This posting is provided "AS IS" with no warranties, and confers no
rights >>>> Please do not send email directly to this alias. This alias is for >>>> newsgroup >>>> purposes only. >>>> >>>> "Luis Alejandro Leal"<< XXXX@XXXXX.COM >> wrote in message >>>> news: XXXX@XXXXX.COM ... >>>>> HI, >>>>> >>>>> I'm trying to test Analysis Services from a Web Application. I've >>>> installed >>>>> Visual Studio .NET Web Control for BI and Microsoft XML For Analysis
SDK. >>>> At >>>>> "C:\Program Files\Microsoft XML For Analysis SDK\Config" there is a
file >>>>> named "datasources.xml" with this datasource configuration: >>>>> >>>>> < >>>>> <Loca< >>>>> <Microsoft Analysis Server 2000 on local >>>>> machin< >>>>> <http://localhost/xmla/msxisapi.dl< >>>>> <Provider=MSOLAP.2;Data Source=loca< >>>>> <Microsoft XML for Analysi< >>>>> < >>>>> < >>>>> < >>>>> < >>>>> < >>>>> <Unauthenticate< >>>>> < >>>>> >>>>> These statements are implemented: >>>>> >>>>> ** Extract datasources procedure *** >>>>> MSSQLBI.XmlAnalysis.Data.DataSource[] dataSources = >>>>> MSSQLBI.Web.Olap.OlapControl.GetDataSourceList(txtUrl.Text, null); >>>>> ddlDataSource.Items.Clear(); >>>>> for(int i=0; <>>> ddlDataSource.Items.Add(dataSources[i].DataSourceInfo); } >>>>> >>>>> >>>>> ** Extract catalogs procedure *** >>>>> MSSQLBI.XmlAnalysis.Data.DataSource[] dataSources = >>>>> MSSQLBI.Web.Olap.OlapControl.GetDataSourceList(txtUrl.Text, null); >>>>> int nIndex = >>>>> >>>>
ddlDataSource.Items.IndexOf(ddlDataSource.Items.FindByValue(ddlDataSource.Se >>>> lectedItem.Value)); ddlCatalogs.Items.Clear(); >>>> MSSQLBI.XmlAnalysis.Data.Catalog[] c