Re: Pivot table over HTTPS

From: Dave Wickert [MSFT] (dwickert_at_online.microsoft.com)
Date: 03/15/04


Date: Mon, 15 Mar 2004 11:25:11 -0500

The latest and greatest is on the SQL Server 2000 Analysis Services SP3
distribution which can
be found at: http://www.microsoft.com/sql/downloads/2000/sp3.asp
>From the Analysis Services componets (sqlasp3.exe), look in the
\msolap\install\pts folder.

As I pointed out in the AS Operations Guide
(http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.msp
x) , it is *EXTREMELY IMPORTANT* that you update your client-side PTS OLEDB
provider when you upgrade your server to SP3. Many of the performance and
throughput improvements with SP3 are only realized if you have upgraded you
client-side PTS component. This is true with any MSFT and 3rd party
client-side (or mid-tier) tool -- wherever they are interfacing to PTS, then
PTS needs to be upgraded along with the Analysis server.

-- 
Dave Wickert [MS]
dwickert@online.microsoft.com
Program Manager
BI Practices Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"OT Solutions, sales" <OTSolutions@shaw.ca> wrote in message
news:df21d456.0403150815.4c93d3a6@posting.google.com...
> Dave, is there any other way to get the pts installed, or is it only
> off of the SQL Server CD? ie. Office CD as well?
>
> Also if the user has Office 2003 is that ok as well?
>
> Regards,
> Tom Olthoff
>
>
> "Dave Wickert [MSFT]" <dwickert@online.microsoft.com> wrote in message
news:<OVA2M7HCEHA.2628@TK2MSFTNGP11.phx.gbl>...
> > The client machines must have both OWC (from their Office
distribution -- XP
> > preferred) *AND* PTS (from the files ptslite.exe or ptsfull.exe on your
SQL
> > distribution CD).
> >
> > -- 
> > Dave Wickert [MS]
> > dwickert@online.microsoft.com
> > Program Manager
> > BI Practices Team
> > SQL BI Product Unit (Analysis Services)
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "Tom Olthoff" <tolthoff@home.com> wrote in message
> > news:bnq4c.789403$ts4.294261@pd7tw3no...
> > > I have a pivot table on our Internet server that other clients are
trying
> >  to
> > > reach via https:.
> > >
> > > The pivot table is displayed via the OWC on the server (through ASP
code).
> > >
> > > What do the users need loaded on their machine to access this cube.
> > >
> > > I was under the impression (Excel, Pivot Table service, and MS Query).
Is
> > > this correct?
> > >
> > > Does OWC need to be installed on the client machine as well?
> > >
> > > Some users can connect others cannot.  They get an error like:
> > >
> > > Pivottable.Connectionstring object doesn't support property.
> > >
> > > Any information on this would be greatly appreciated.
> > >
> > >
> > > Regards,
> > >
> > > Tom Olthoff
> > >
> > >


Relevant Pages

  • Re: OLAP Analysis Services Components Installation Help
    ... > My server installed SQL Server 2000 with SP3a, ... > analysis services components, the setup file is runing on Windows ... I am not sure that I can't install olap ...
    (microsoft.public.win2000.security)
  • Re: AS 2005: ....a string was found that was larger than the page
    ... Analysis Services blog at http://www.sqljunkies.com/WebL­og/mosha ... confers no rights. ... >> Since SQL Server 2005 has not been publicly released yet, ...
    (microsoft.public.sqlserver.olap)
  • Re: Analysis Server 2000 memory vs. SQL Server 2000 memory
    ... Analysis Services 32-bit edition uses up to 2GB memory. ... AS and SQL are competing for the same memory. ... you could limit SQL Server on 4GB, so you have 2GB for AS. ... Dejan Sarka, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Enterprise or Standard Edition ??
    ... There is a DSO property called Edition on the server which returns whether ... > How can I tell whether the Analysis Services installed on a SQL Server ... > 2000 computer is the Enterprise or Standard edition? ...
    (microsoft.public.sqlserver.olap)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)