OLAP / Analysis services version checking by client

The problem is that i would like to integrate a code to the file in net where MS Office Web Components and OLAP services are beeing used.
Code should automatically detect a version of olap client and office web service components (OWC) and if newer version is needed, then it should download it.
Good instructions were @. http://support.microsoft.com/default.aspx?scid=kb;en-us;312876
where ptssetup.exe included all necessary information, but it was applied to Microsoft SQL Server 2000 Analysis Services. Now what i need to know is how to write a code which is working on Microsoft SQL Server 2005. Or how the old code can be changed to get it work on sql server 2005?

Hello,

I'm going to move your question to one of the SQL Server forums were they should be able to help you.

Daniel Roth

|||

Erkki wrote:

The problem is that i would like to integrate a code to the file in net where MS Office Web Components and OLAP services are beeing used.
Code should automatically detect a version of olap client and office web service components (OWC) and if newer version is needed, then it should download it.
Good instructions were @. http://support.microsoft.com/default.aspx?scid=kb;en-us;312876
where ptssetup.exe included all necessary information, but it was applied to Microsoft SQL Server 2000 Analysis Services. Now what i need to know is how to write a code which is working on Microsoft SQL Server 2005. Or how the old code can be changed to get it work on sql server 2005?

I would like to know that too. Anyway, how is it possible to verify the version of OLAP ? How can it be done? Maybe to somehow connect to server where the olap is being used?

Office Web Components Security Settings...?

I have a number of reports for which it would be useful to allow users to make use of the office web Components to allow them to maniplulate the data and then export it to excel..

But as soon as i click the Excel symbol to dump out the pivot table to excel i get the error message;

"Safety settings on this computer prohibit accessing a data source on another domian."

Now i have been into Internet Explorers Tools >> Options >> security and enabled the 'Access Data sources across domains' on my computer (in both the internet and intranet zones) but it still pops up.. and wont let me export to excel

Any ideas.. anyone..?

worked it out.. as well as allowing the "Access data across domains" option in IE you also have to add the website to the 'Trusted Sites'.

Office web components basic authentication impersonation

Hi,

I have a question regarding office web components 10.0/11.0.

I've searched various forums without finding an answer.

My question is whether it's possible to use office web components with basic authentication so that the OWC uses the specified identity (basic authentication) to authenticate against AS 2000 instead of using the identity of the user that is currently logged on to the machine?

My problem is that we external users that aren't members of our AD that shall have access to AS2000. And when OWC uses the machine login instead of the basic authentication login the authentication fails.

And also, is it any difference when using OWC with AS 2000 compared to AS 2005?

I know that one solution that I've gotten to work with AS 2005 is to use HTTP connection, but then I must specify user name and password which isn't an ideal solution for us. It would be better if integrated security could be used.

Looking forward toward you answer

Regards,

Johan.

Moved as this seems to be AS related.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Not sure I get your question.

If you are trying to access Analysis Services using OWC through HTTP connection you got choice to ether use Basic Auth or Integrated. (Of cource there is anonymous)
If your user is coming from outside of AD, you got to use Basic Auth.
With Basic Auth your users needs to provide username and password, only integrated Auth works knows how to re-use existing user credentials.

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

|||

Hello Edward,

My users are coming from outside of the AD. But I've created AD accounts for them to use when they login using basic authentication.

If I use HTTP connection will I have to add a username and a password in the connectionstring?

Is it possible for the user to connect to the AS database without using HTTP connection?

My experience of using OWC is that OWC will not use the identity of the web page but instead use the user's machine account.

/Johan

|||

You will need to provide usernames and passwords for Basic Auth to work.

As for protocols options to connect to Analysis Services: You have a choice of HTTP or TCP/IP.

Using TCP/IP you can establish connection to Analysis Server only using integrated windows authentication.

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

|||

> If I use HTTP connection will I have to add a username and a password in the connectionstring?

No, I think you can set up the virtual folder that holds the HTTP connectivity stuff using Basic Auth and it will then prompt and in this case you should not put the username/password in the connection string.

> My experience of using OWC is that OWC will not use the identity of the web page but instead use the user's machine account.

This is correct. OWC is an ActiveX component and it executes on the client machine (not on the server). It creates it's own connection back to the AS server. Therefore if you have Basic Auth setup on the website and on the HTTP connection, the users will get prompted twice. The only way around this would be to either:

allow anonymous access to the web page, and let the AS HTTP connection do the prompting setup an explicit username/password in the connection string, but this means you cannot apply role based security as AS only "sees" one user connecting.

Office Web Components & Analysis Services

Hi,
We've been asked to enable an external client to access a cube via OWC.
The idea is that if they play about with the cube through the PivotTable
control, this will enable them to define their requirements for a reporting
system to sit on top of the cube.
I've read and implemented the contents of the following document:-
- http://www.microsoft.com/technet/pr...5/httpasws.mspx
I've installed OWC and the SQL data access components on a test machine, and
have been trying to access the cube through a web-page hosting the pivot
table control.
Data access across domains is enabled in IE
The error returned is "The query could not be processed: The HTTP server
returned the following error: Forbidden."
Obviosuly some security setting somewhere needs to be tweaked ... but which
one :/
Access to the web-page hosting the OWC control will be locked down by IP
address.
Bearing all the above, what is the most straightforward means of enabling
access via the OWC PivotTble control?
Thank you for help.does the XMLA virtual directory is hosted on the SSAS server himself or on
another HTTP server?
what is the security mode of the virtual directory? Anonymous, Basic, or
integrated security?
"craig_amtdatatechnologies@.discussions.mi"
< craigamtdatatechnologiesdiscussionsmi@.di
scussions.microsoft.com> wrote in
message news:075C02A4-F2FC-485C-BBFB-63B55EF261C8@.microsoft.com...
> Hi,
> We've been asked to enable an external client to access a cube via OWC.
> The idea is that if they play about with the cube through the PivotTable
> control, this will enable them to define their requirements for a
> reporting
> system to sit on top of the cube.
> I've read and implemented the contents of the following document:-
> - http://www.microsoft.com/technet/pr...5/httpasws.mspx
>
> I've installed OWC and the SQL data access components on a test machine,
> and
> have been trying to access the cube through a web-page hosting the pivot
> table control.
> Data access across domains is enabled in IE
> The error returned is "The query could not be processed: The HTTP server
> returned the following error: Forbidden."
> Obviosuly some security setting somewhere needs to be tweaked ... but
> which
> one :/
> Access to the web-page hosting the OWC control will be locked down by IP
> address.
> Bearing all the above, what is the most straightforward means of enabling
> access via the OWC PivotTble control?
>
> Thank you for help.
>
>

Office Web Components

Do the interactivity features of OWC client side exist with reporting
services?
Can we replace the work that we do now with OWC and lots of javascript with
RS?I've looked at trying to replicate the pivottable owc in reporting services
but rs just isn't for that, well not without a mega amount of programming.
What part of OWC are you using?
--
Tony Rogerson
SQL Server MVP
http://www.sqlserverfaq.com?mbr=21
(Create your own groups, Forum, FAQ's and a ton more)|||No, RS matrix and chart regions are not meant to replace OWC. As you would
understand it is difficult to implement the same functionality in HTML than
using ActiveX controls. However, you can integrate your OWC components to
run RS reports, e.g. when the lowest level in a dimension hierarchy is
reached.
One more thing. In RS OWC are used only when exporting the report to HTML
OWC format. When this happen, RS exports matrix regions as pivot tables,
charts as chart space objects. However, OWC is not linked to the data
source. Instead, the data is always restricted to the data that the report
query returns.
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"Mike B" <MikeB@.discussions.microsoft.com> wrote in message
news:D7C0A07C-527C-45AD-9ECE-614BBF123027@.microsoft.com...
> Do the interactivity features of OWC client side exist with reporting
> services?
> Can we replace the work that we do now with OWC and lots of javascript
with
> RS?

Odd syntax error with shape queries SQL2000/Win2003

Hi,

I am running SQL Server 2000 SP3 on Windows Server 2003 and since recently
have a strange problem executing shape queries from COM+ components using
ADO.

Until 4 days ago, they worked, then from one moment to the next (I must have
changed something, but I have no clue what other than restoring a 1.2 GB
database) they started failing with this error:

Microsoft OLE DB Provider for SQL Server error '80040e14'
Syntax error or access violation

I have no problem executing non-shape queries, it is just the shape queries
that fail.

Any clues what may have gone wrong? Or how I can fix it?

Cheers,
Rsa Myh> Microsoft OLE DB Provider for SQL Server error '80040e14'
> Syntax error or access violation

And apparently this had nothing to do with Win2003 or SQL Server or any
software at all... Just with a mistake in a setting of my own software...
The datasource string for the shape data source was invalid....

I'm hanging my head in shame..