![]() | |
![]() |
| | Thread Tools | Display Modes |
#1
| |||
| |||
|
|
I am trying to set up an OLAP Reporting Application via HTTP with ASP .NET using SQL Server Analysis Services. I found one article describing how to do this; however, it seems that you need SQL Server Enterprise edition to set up HTTP access in Analysis Services. Does anyone know how I can do this using regular SQL Server? Or if I can set up HTTP access with regular Anlaysis Services? |
#2
| |||
| |||
|
|
Since you are using middle-tier application with ASP.NET - you don't need Enterprise Edition of Analysis Services. The Enterprise Edition is only required if you are connecting directly to Analysis Services using HTTP (and not through ASP or ASP.NET). -- ================================================== Mosha Pasumansky - http://www.mosha.com/msolap Yukon information at http://www.mosha.com/msolap/yukon.htm Development Lead in the Analysis Server team All you need is love (John Lennon) Disclaimer : This posting is provided "AS IS" with no warranties, and confers no rights. ================================================== "Adeem Fenster" <AdeemFenster (AT) discussions (DOT) microsoft.com> wrote in message news:2A1F845E-0874-4A82-AB7B-88CF1DBF5505 (AT) microsoft (DOT) com... I am trying to set up an OLAP Reporting Application via HTTP with ASP .NET using SQL Server Analysis Services. I found one article describing how to do this; however, it seems that you need SQL Server Enterprise edition to set up HTTP access in Analysis Services. Does anyone know how I can do this using regular SQL Server? Or if I can set up HTTP access with regular Anlaysis Services? |
#3
| |||
| |||
|
|
I am trying to set up an OLAP Reporting system which can be accessed via HTTP. Doesn't this require the HTTP web-site to connect into Analysis Services in order to retreive info. from the OLAP cubes on the server? Is there a way to bypass this and set up an OLAP Reporting system otherwise via web? Thanks for the response. "Mosha Pasumansky [MS]" wrote: Since you are using middle-tier application with ASP.NET - you don't need Enterprise Edition of Analysis Services. The Enterprise Edition is only required if you are connecting directly to Analysis Services using HTTP (and not through ASP or ASP.NET). -- ================================================== Mosha Pasumansky - http://www.mosha.com/msolap Yukon information at http://www.mosha.com/msolap/yukon.htm Development Lead in the Analysis Server team All you need is love (John Lennon) Disclaimer : This posting is provided "AS IS" with no warranties, and confers no rights. ================================================== "Adeem Fenster" <AdeemFenster (AT) discussions (DOT) microsoft.com> wrote in message news:2A1F845E-0874-4A82-AB7B-88CF1DBF5505 (AT) microsoft (DOT) com... I am trying to set up an OLAP Reporting Application via HTTP with ASP ..NET using SQL Server Analysis Services. I found one article describing how to do this; however, it seems that you need SQL Server Enterprise edition to set up HTTP access in Analysis Services. Does anyone know how I can do this using regular SQL Server? Or if I can set up HTTP access with regular Anlaysis Services? |
#4
| |||
| |||
|
|
As long as you don't have "Data Source=http://server" in your connection string - you don't have to use Enterprise Edition. (assuming your Web site connects to Analysis Services using TCP directly). -- ================================================== Mosha Pasumansky - http://www.mosha.com/msolap Yukon information at http://www.mosha.com/msolap/yukon.htm Development Lead in the Analysis Server team All you need is love (John Lennon) Disclaimer : This posting is provided "AS IS" with no warranties, and confers no rights. ================================================== "Adeem Fenster" <AdeemFenster (AT) discussions (DOT) microsoft.com> wrote in message news:ED435213-977C-492B-9A9C-4000E0C78DAB (AT) microsoft (DOT) com... I am trying to set up an OLAP Reporting system which can be accessed via HTTP. Doesn't this require the HTTP web-site to connect into Analysis Services in order to retreive info. from the OLAP cubes on the server? Is there a way to bypass this and set up an OLAP Reporting system otherwise via web? Thanks for the response. "Mosha Pasumansky [MS]" wrote: Since you are using middle-tier application with ASP.NET - you don't need Enterprise Edition of Analysis Services. The Enterprise Edition is only required if you are connecting directly to Analysis Services using HTTP (and not through ASP or ASP.NET). -- ================================================== Mosha Pasumansky - http://www.mosha.com/msolap Yukon information at http://www.mosha.com/msolap/yukon.htm Development Lead in the Analysis Server team All you need is love (John Lennon) Disclaimer : This posting is provided "AS IS" with no warranties, and confers no rights. ================================================== "Adeem Fenster" <AdeemFenster (AT) discussions (DOT) microsoft.com> wrote in message news:2A1F845E-0874-4A82-AB7B-88CF1DBF5505 (AT) microsoft (DOT) com... I am trying to set up an OLAP Reporting Application via HTTP with ASP ..NET using SQL Server Analysis Services. I found one article describing how to do this; however, it seems that you need SQL Server Enterprise edition to set up HTTP access in Analysis Services. Does anyone know how I can do this using regular SQL Server? Or if I can set up HTTP access with regular Anlaysis Services? |
![]() |
| Thread Tools | |
| Display Modes | |
| |