Hi Akshai, I set the virtual directory's application protection to LOW.

Now the sample.net program comes with XML/A 1.1 is working Fine.

Thanks Akshai for your help.


Now I am using Visual studio dotnet Business Intelligence Control to
access the OLAP data. When i run the sample project, i click on
connection sample -> get datasources --> it gives me "access denied".
The sample virtual directory is already set to Low Application
protection.


I created a new project and properly configured the iis settings. When
i run the project, it gives error "Access Denied".I added network
credentials as mentioned in the help file of BI control, now i do not
get the access denied error.
(olapControl1.XmlaSoapClient.Credentials = New
System.Net.NetworkCredential("userid", "mypassword", "mydomain")


But now it throws me different error


"Unable to process the request, because the DataSourceInfo property was



missing or not correctly specified. "


The connection string is here


OlapControl1.Connection = New
MSSQLBI.XmlAnalysis.Data.MdxConnection("http://localhost/bitest/xmla/msxisapi.dll",

"Provider=MSOLAP.2;data source=local", "FoodMart 2000", "Sales")


Akshai Please assist to go further.

Have to tried to run the Sample Application shipped with the XML for
Analysis SDK. Another place to look for further details is the
XMLA_SDK_INSTALLED_PATH\Config\datasources.xml file.

In the above file there is a tag DataSourceInf tag, please make sure
that the syntax of this connection string is ok.

Mansoor, Thanks for your reply.

Sample application(in XML SDK) works fine. I am able to see the data
source n the cube data.

Now the issue is with the (OLAP WEB) BI Control. I am programmatically
setting the connection and the connection string is

OlapControl1.Connection = New
MSSQLBI.XmlAnalysis.Data.MdxConnection("http://localhost/bitest/xmla/msxisapi.dll",

"Provider=MSOLAP.2;data source=local", "FoodMart 2000", "Sales")

Even if try to set the connection details at design time from the
control properties, I get access denied.

i have a problem in connection string, whenever i tries to connect it to the Analysis server, it says invalid connection string

I have successfully downloaded the Visual Studio .NET Web Control for Business Intelligence. I am using SQL Server 2005 Analysis services with Visual Studio 2005.

1. My SQL server ServerName Nazim-PC

2. Database name AdventureDW
3. Analysis Project Name using VS2005 ASProject (I have deployed this to my localhost with the username and password of my domain name)
4. Analysis service Cube Name Adventure Works DW.cube

What should be the possible connection string to connect through the OLAP server
OlapControl1.Connection = new MSSQLBI.XmlAnalysis.Data.MdxConnection("http://localhost/xmla/msxisapi.dll","Provider=MSOLAP.2;Data Source=Nazim-pc","AdventureDW"," Adventure Works DW ");

I am using this connection string but it gives me error, invalid connection string. Please help. any help can be sent directly to my email address
nazim_zia (AT) yahoo (DOT) com



From http://www.developmentnow.com/g/112_...roperty-was.ht

Posted via DevelopmentNow.com Group
http://www.developmentnow.com

i have a problem in connection string, whenever i tries to connect it to the Analysis server, it says invalid connection string

I have successfully downloaded the Visual Studio .NET Web Control for Business Intelligence. I am using SQL Server 2005 Analysis services with Visual Studio 2005.

1. My SQL server ServerName Nazim-PC

2. Database name AdventureDW
3. Analysis Project Name using VS2005 ASProject (I have deployed this to my localhost with the username and password of my domain name)
4. Analysis service Cube Name Adventure Works DW.cube

What should be the possible connection string to connect through the OLAP server
OlapControl1.Connection = new MSSQLBI.XmlAnalysis.Data.MdxConnection("http://localhost/xmla/msxisapi.dll","Provider=MSOLAP.2;Data Source=Nazim-pc","AdventureDW"," Adventure Works DW ");

I am using this connection string but it gives me error, invalid connection string. Please help. any help can be sent directly to my email address
nazim_zia (AT) yahoo (DOT) com



From http://www.developmentnow.com/g/112_...roperty-was.ht

Posted via DevelopmentNow.com Group
http://www.developmentnow.com

i have a problem in connection string, whenever i tries to connect it to the Analysis server, it says invalid connection string

I have successfully downloaded the Visual Studio .NET Web Control for Business Intelligence. I am using SQL Server 2005 Analysis services with Visual Studio 2005.

1. My SQL server ServerName Nazim-PC

2. Database name AdventureDW
3. Analysis Project Name using VS2005 ASProject (I have deployed this to my localhost with the username and password of my domain name)
4. Analysis service Cube Name Adventure Works DW.cube

What should be the possible connection string to connect through the OLAP server
OlapControl1.Connection = new MSSQLBI.XmlAnalysis.Data.MdxConnection("http://localhost/xmla/msxisapi.dll","Provider=MSOLAP.2;Data Source=Nazim-pc","AdventureDW"," Adventure Works DW ");

I am using this connection string but it gives me error, invalid connection string. Please help. any help can be sent directly to my email address
nazim_zia (AT) yahoo (DOT) com



From http://www.developmentnow.com/g/112_...roperty-was.ht

Posted via DevelopmentNow.com Group
http://www.developmentnow.com

i have a problem in connection string, whenever i tries to connect it to the Analysis server, it says invalid connection string

I have successfully downloaded the Visual Studio .NET Web Control for Business Intelligence. I am using SQL Server 2005 Analysis services with Visual Studio 2005.

1. My SQL server ServerName Nazim-PC

2. Database name AdventureDW
3. Analysis Project Name using VS2005 ASProject (I have deployed this to my localhost with the username and password of my domain name)
4. Analysis service Cube Name Adventure Works DW.cube

What should be the possible connection string to connect through the OLAP server
OlapControl1.Connection = new MSSQLBI.XmlAnalysis.Data.MdxConnection("http://localhost/xmla/msxisapi.dll","Provider=MSOLAP.2;Data Source=Nazim-pc","AdventureDW"," Adventure Works DW ");

I am using this connection string but it gives me error, invalid connection string. Please help. any help can be sent directly to my email address
nazim_zia (AT) yahoo (DOT) com



From http://www.developmentnow.com/g/112_...roperty-was.ht

Posted via DevelopmentNow.com Group
http://www.developmentnow.com

i have a problem in connection string, whenever i tries to connect it to the Analysis server, it says invalid connection string

I have successfully downloaded the Visual Studio .NET Web Control for Business Intelligence. I am using SQL Server 2005 Analysis services with Visual Studio 2005.

1. My SQL server ServerName Nazim-PC

2. Database name AdventureDW
3. Analysis Project Name using VS2005 ASProject (I have deployed this to my localhost with the username and password of my domain name)
4. Analysis service Cube Name Adventure Works DW.cube

What should be the possible connection string to connect through the OLAP server
OlapControl1.Connection = new MSSQLBI.XmlAnalysis.Data.MdxConnection("http://localhost/xmla/msxisapi.dll","Provider=MSOLAP.2;Data Source=Nazim-pc","AdventureDW"," Adventure Works DW ");

I am using this connection string but it gives me error, invalid connection string. Please help. any help can be sent directly to my email address
nazim_zia (AT) yahoo (DOT) com



From http://www.developmentnow.com/g/112_...roperty-was.ht

Posted via DevelopmentNow.com Group
http://www.developmentnow.com

i have a problem in connection string, whenever i tries to connect it to the Analysis server, it says invalid connection string

I have successfully downloaded the Visual Studio .NET Web Control for Business Intelligence. I am using SQL Server 2005 Analysis services with Visual Studio 2005.

1. My SQL server ServerName Nazim-PC

2. Database name AdventureDW
3. Analysis Project Name using VS2005 ASProject (I have deployed this to my localhost with the username and password of my domain name)
4. Analysis service Cube Name Adventure Works DW.cube

What should be the possible connection string to connect through the OLAP server
OlapControl1.Connection = new MSSQLBI.XmlAnalysis.Data.MdxConnection("http://localhost/xmla/msxisapi.dll","Provider=MSOLAP.2;Data Source=Nazim-pc","AdventureDW"," Adventure Works DW ");

I am using this connection string but it gives me error, invalid connection string. Please help. any help can be sent directly to my email address
nazim_zia (AT) yahoo (DOT) com



From http://www.developmentnow.com/g/112_...roperty-was.ht

Posted via DevelopmentNow.com Group
http://www.developmentnow.com

i have a problem in connection string, whenever i tries to connect it to the Analysis server, it says invalid connection string

I have successfully downloaded the Visual Studio .NET Web Control for Business Intelligence. I am using SQL Server 2005 Analysis services with Visual Studio 2005.

1. My SQL server ServerName Nazim-PC

2. Database name AdventureDW
3. Analysis Project Name using VS2005 ASProject (I have deployed this to my localhost with the username and password of my domain name)
4. Analysis service Cube Name Adventure Works DW.cube

What should be the possible connection string to connect through the OLAP server
OlapControl1.Connection = new MSSQLBI.XmlAnalysis.Data.MdxConnection("http://localhost/xmla/msxisapi.dll","Provider=MSOLAP.2;Data Source=Nazim-pc","AdventureDW"," Adventure Works DW ");

I am using this connection string but it gives me error, invalid connection string. Please help. any help can be sent directly to my email address
nazim_zia (AT) yahoo (DOT) com



From http://www.developmentnow.com/g/112_...roperty-was.ht

Posted via DevelopmentNow.com Group
http://www.developmentnow.com