I'm using Xmla Provider to connect to OLAP Server. I want to take catalogs and cubes list for every dataSource(I used Discover_DataSources for dataSource list). When I use DBSCHEMA_CATALOGS or DBSCHEMA_CUBES I get exception that there's no catalogs. !-- Part of my dataSources.xml: <DataSourceInfo> Provider=MSOLAP;Data Source=Localhost; </DataSourceInfo> MDX Sample Application works fine for those parameters. If I change provider on SQLOLEDB (my local SQL SERVER) also everything works correct (I get list of databases). Problem is with OLAP. For Xmla Provider(IIS) I'm using anonimous auth. Could somebody help me with this? -- Pawel
Probably the anonymous user has no access to any of the catalogs. Either: - make sure the anonymous user has access to at least one catalog in each data source - or switch to non-anonymous authentication such that the impersonated user has access to a catalog 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. "Pawel" wrote in message news:O2fVrN9tFHA.3864@TK2MSFTNGP12.phx.gbl... > I'm using Xmla Provider to connect to OLAP Server. I want to take > catalogs and cubes list for every dataSource(I used Discover_DataSources > for dataSource list). When I use DBSCHEMA_CATALOGS or DBSCHEMA_CUBES I > get exception that there's no catalogs. > !-- > Part of my dataSources.xml: > <DataSourceInfo> > Provider=MSOLAP;Data Source=Localhost; > </DataSourceInfo> > > MDX Sample Application works fine for those parameters. > If I change provider on SQLOLEDB (my local SQL SERVER) also everything > works correct (I get list of databases). Problem is with OLAP. > > For Xmla Provider(IIS) I'm using anonimous auth. > > Could somebody help me with this? > > -- > Pawel >
