dbTalk Databases Forums  

HTTP Analysis Server Access / wrong version?

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss HTTP Analysis Server Access / wrong version? in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
jb1677@gmail.com
 
Posts: n/a

Default HTTP Analysis Server Access / wrong version? - 09-29-2005 , 12:01 PM






When attempting a simple connection using an http:// data source:

Dim conn As New ADODB.Connection
conn.Open("Provider=MSOLAP.2;Data Source= SqlServer01....etc

We receive the following:

The HTTP or HTTPS connection feature is available only with Analysis
Services for SQL Server 2000 Enterprise Edition. The server you are
attempting to connect to is not an Enterprise Edition server.

The issue is SQL is in fact Enterprise edition and Analysis server was
installed from Enterprise Edition media. We also checked with a script
from msdn
(http://www.microsoft.com/technet/pro...rvog.mspx#EFAA)
which also confirmed that Analysis Services believed it was enterprise
edition.

Has anyone ever seen this before?


Reply With Quote
  #2  
Old   
sefe dery
 
Posts: n/a

Default Re: HTTP Analysis Server Access / wrong version? - 09-30-2005 , 02:33 PM






jb1677 (AT) gmail (DOT) com schrieb:
Quote:
When attempting a simple connection using an http:// data source:

Dim conn As New ADODB.Connection
conn.Open("Provider=MSOLAP.2;Data Source= SqlServer01....etc

We receive the following:

The HTTP or HTTPS connection feature is available only with Analysis
Services for SQL Server 2000 Enterprise Edition. The server you are
attempting to connect to is not an Enterprise Edition server.

The issue is SQL is in fact Enterprise edition and Analysis server was
installed from Enterprise Edition media. We also checked with a script
from msdn
(http://www.microsoft.com/technet/pro...rvog.mspx#EFAA)
which also confirmed that Analysis Services believed it was enterprise
edition.

Has anyone ever seen this before?

thats strange,

but are you sure that you have copied the msolap.asp to the
inetpub/wwwroot folder and you have to use in your connection string
Data Source=http://Servername
thats all.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.