Microsoft Ole db provider for Olap services 8.0

Hello Folks,

I am desperately trying to connect to AS using this provider. But when i attempt to connect to it using the UDL file i get the error message - "Provider is no longer available. Ensure that the provider is installed properly."

I have tried re-registering the files msolap80.dll and msmddo80.dll, but to no success.

thanks and have a great day!

Try installing "Microsoft SQL Server 2000 PivotTable Services " from http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Microsoft Data Analyzer

I have downloaded Microsoft Data Analyzer and it is
asking for a CUBE on online OLAP server. Is there anyway
to connect it to Data in a plain 2000 SQL server.
if I do need OLAP what do I need to install on my SQL
server
Thanks
Steven Hill wrote:
> I have downloaded Microsoft Data Analyzer and it is
> asking for a CUBE on online OLAP server. Is there anyway
> to connect it to Data in a plain 2000 SQL server.
> if I do need OLAP what do I need to install on my SQL
> server
You need to have OLAP services installed on your SQL Server. From MDA FAQ -
OLAP refers to an online analytical processing database capable of handling
queries more complex than those handled by standard relational databases. It
does this through multidimensional access to data, intensive calculation
capability, and specialized indexing techniques. To learn more about this
technology, visit the OLAP and Data Mining page
(http://msdn.microsoft.com/library/de...-us/createdw/c
reatedw_1vqf.asp) on the MSDN site.
sincerely,
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.
sql

Microsoft Analysis Services on the web problem

Hi All!

We are trying to implement a web solution which include some OLAP cubes. We are using the followings applications and components:

Server: Windows 2000 - Microsoft Internet Information Server - SQL Server 2000 - Microsoft Analysis Services

Client: Active X Cube Browser included with Office 2000 - Pivot Table Services

For access the cubes, we developed an ASP which includes the Active X, and connect to the Analysis Services server. If i access this web page from the server, i can view the cube, and use it without any problem, but if i try to access the cube accross internet, i am having the following problem:

"The operation requested failed due to security problems - the user could not be authenticated"

If you have any idea or suggestion about this problem, let me know.
Thanks!

IgnacioIt depends on the secuity mode you are using with SQL server most sane people wont let NT authentication through their firewall which leaves SQL logins only.

Try setting up the accounts to use SQL only authentication & see how you go.

Post back if probs

J.|||Thanks for your advice, but we already solve the problem.

We need to install SQL Server 2000 Enterprise Edition, because it has http connection and it works.

Thanks again,

Ignacio|||HII
Can u tell me what was the permissions in the cube.

1) if the cube gave has access to everyone . How did u restrict people on the network to access the cube.
2) if it was specific domain users. How did u manage to propagate security of a user accessing from the page.

Regds
Ram

Originally posted by isbampato
Thanks for your advice, but we already solve the problem.

We need to install SQL Server 2000 Enterprise Edition, because it has http connection and it works.

Thanks again,

Ignacio|||Ram,

we didn't configure a secure environment yet, because the cubes were prepared only for a demo in our intranet. We have created a test database, and a test set of cubes, and added a new user only for use in this test environment, and with full control over it.

Besides, we added basic web authentication to the web page with the online cubes.

We didn't analyze yet how to secure this because it's still at a test phase.

Best regards,

Ignacio