Help is greatly appreciated. Using Asp.net 2.0, sql server 2005 and sdk 1.1. Using sample program to connect, getting "An error occured unable to process the request". I have xmla directory in IIS and when executed "http://localhost/xmla/msxisapi.dll" i am getting the response as intended "Post not allowed". I allow reponses over HTTP (allowinsecure.. flag set to 1). Datasources point to local host. On SQL server AS I created a general role with made IWAM_ and IUser_ users as members along with local admin. I am running Sql server 2005 and IIS on the same machine. I enable TCP/IP protocols as well on SQL server. I am able to look at my cubes and the corresponding data in the VS 2005 BI project. Thanks. Thanks.
I am running all this on Windows xp2 if this info matters. Thanks. "Raj25" wrote: > Help is greatly appreciated. > > Using Asp.net 2.0, sql server 2005 and sdk 1.1. Using sample program to > connect, getting "An error occured unable to process the request". > > I have xmla directory in IIS and when executed > "http://localhost/xmla/msxisapi.dll" i am getting the response as intended > "Post not allowed". > > I allow reponses over HTTP (allowinsecure.. flag set to 1). Datasources > point to local host. > > On SQL server AS I created a general role with made IWAM_ and IUser_ users > as members along with local admin. I am running Sql server 2005 and IIS on > the same machine. I enable TCP/IP protocols as well on SQL server. > > I am able to look at my cubes and the corresponding data in the VS 2005 BI > project. > > Thanks. > Thanks.
The XMLA SDK is not designed to work against AS 2005. You should be following instructions here http://www.sqlserveranalysisservices.com/OLAPPapers/ConfiguringHTTPAccessToYukon.htm if you want to use HTTP and XMLA against AS 2005. 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. "Raj25" wrote in message news:BED71DD3-9242-493B-90B7-BAB4B5B471D5@microsoft.com... > I am running all this on Windows xp2 if this info matters. > > Thanks. > > > "Raj25" wrote: > > > Help is greatly appreciated. > > > > Using Asp.net 2.0, sql server 2005 and sdk 1.1. Using sample program to > > connect, getting "An error occured unable to process the request". > > > > I have xmla directory in IIS and when executed > > "http://localhost/xmla/msxisapi.dll" i am getting the response as intended > > "Post not allowed". > > > > I allow reponses over HTTP (allowinsecure.. flag set to 1). Datasources > > point to local host. > > > > On SQL server AS I created a general role with made IWAM_ and IUser_ users > > as members along with local admin. I am running Sql server 2005 and IIS on > > the same machine. I enable TCP/IP protocols as well on SQL server. > > > > I am able to look at my cubes and the corresponding data in the VS 2005 BI > > project. > > > > Thanks. > > Thanks.
Thanks for your help. My next question is coding example. I used Discover and execute of the XMLAClient. What name space should I be using against msmdpump.dll. Even before posting this, I followed those instructions, but could not connect/program (I am new to ws and soap) "Akshai Mirchandani [MS]" wrote: > The XMLA SDK is not designed to work against AS 2005. You should be > following instructions here > http://www.sqlserveranalysisservices.com/OLAPPapers/ConfiguringHTTPAccessToYukon.htm > if you want to use HTTP and XMLA against AS 2005. > > 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. > > "Raj25" wrote in message > news:BED71DD3-9242-493B-90B7-BAB4B5B471D5@microsoft.com... > > I am running all this on Windows xp2 if this info matters. > > > > Thanks. > > > > > > "Raj25" wrote: > > > > > Help is greatly appreciated. > > > > > > Using Asp.net 2.0, sql server 2005 and sdk 1.1. Using sample program to > > > connect, getting "An error occured unable to process the request". > > > > > > I have xmla directory in IIS and when executed > > > "http://localhost/xmla/msxisapi.dll" i am getting the response as > intended > > > "Post not allowed". > > > > > > I allow reponses over HTTP (allowinsecure.. flag set to 1). Datasources > > > point to local host. > > > > > > On SQL server AS I created a general role with made IWAM_ and IUser_ > users > > > as members along with local admin. I am running Sql server 2005 and IIS > on > > > the same machine. I enable TCP/IP protocols as well on SQL server. > > > > > > I am able to look at my cubes and the corresponding data in the VS 2005 > BI > > > project. > > > > > > Thanks. > > > Thanks. > > >
What errors do you get? Can you paste a snippet of the code that you are using? 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. "Raj25" wrote in message news:10C84FE6-B0A2-4063-97FB-B13F587900DF@microsoft.com... > Thanks for your help. My next question is coding example. I used Discover > and execute of the XMLAClient. What name space should I be using against > msmdpump.dll. Even before posting this, I followed those instructions, but > could not connect/program (I am new to ws and soap) > > > "Akshai Mirchandani [MS]" wrote: > > > The XMLA SDK is not designed to work against AS 2005. You should be > > following instructions here > > http://www.sqlserveranalysisservices.com/OLAPPapers/ConfiguringHTTPAccessToYukon.htm > > if you want to use HTTP and XMLA against AS 2005. > > > > 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. > > > > "Raj25" wrote in message > > news:BED71DD3-9242-493B-90B7-BAB4B5B471D5@microsoft.com... > > > I am running all this on Windows xp2 if this info matters. > > > > > > Thanks. > > > > > > > > > "Raj25" wrote: > > > > > > > Help is greatly appreciated. > > > > > > > > Using Asp.net 2.0, sql server 2005 and sdk 1.1. Using sample program to > > > > connect, getting "An error occured unable to process the request". > > > > > > > > I have xmla directory in IIS and when executed > > > > "http://localhost/xmla/msxisapi.dll" i am getting the response as > > intended > > > > "Post not allowed". > > > > > > > > I allow reponses over HTTP (allowinsecure.. flag set to 1). Datasources > > > > point to local host. > > > > > > > > On SQL server AS I created a general role with made IWAM_ and IUser_ > > users > > > > as members along with local admin. I am running Sql server 2005 and IIS > > on > > > > the same machine. I enable TCP/IP protocols as well on SQL server. > > > > > > > > I am able to look at my cubes and the corresponding data in the VS 2005 > > BI > > > > project. > > > > > > > > Thanks. > > > > Thanks. > > > > > >
