Office Web Parts / Office Web Components connecting to SQL Server from extranet

Microsoft OFFICE


  • 1. OWC 2003
    Hi, where can I find information about Office 2003 Web Components? I couldn't find anything about those components in MS web Site I'm interested in features, but specifically in new features. Thanks a lot LucasC
  • 2. OWC10 Formula and performance
    I am using owc10 and have formulas (SUMIF) in one region. The performance is very poor when I try to populate some other region in the sheet (in a loop). (I am setting the calculation as manual) If the formulas are not there then the performance is quick. Also it is much better in owc9 with calculation set to manual. any one knows any work around or fix?
  • 3. Color of serie
    Hi.. i have (OWC10) this code: CSpace.Charts(0).Type = C.chChartTypeSmoothLine For Each x In CSpace.Charts(0).SeriesCollection x.Interior.Color = "blue" x.Border.Color = "blue" Next x But i see no change.... I can, however, change the color of columnbars with: CSpace.Charts(0).SeriesCollection(0).Interior.SetOneColorGradient c.chGradientVertical, c.chGradientVariantCenter, 0.9, "blue" so, if the 2nd one is working, why the first one no? Thanks!
  • 4. Suppress / Delete zero data label value
    My chart type is chChartTypeColumnStacked and I have multiple series. I can turn on the Data Labels just fine for each series. However, when the series value is zero, I get a bunch of overlapping data labels that all say zero which I want to either suppress or delete. The chart itself looks great. Thanks in advance.
  • 5. Calculated Members Not Shown
    Hi all, I created some calculated members in a cube and tried to display them in a PivotTable List. I set the DisplayCalculatedMembers property of PivotTable ActiveView to TRUE. But only one calculated member which does simple division of two measures was shown in the PivotTable. For other calculated members which use Iif function were not shown. I am using OWC10. But I found out a strange solution. If I multiply the SOLVE_ORDER of all the calculated members by 10 in Cube Editor, and then tried to display them in the PivotTable. Now I can see all of the calculated members. But the multiplication does not change the order in which the calculated members get solved. Can anyone tell me what the problem might be? Thanks a lot. Confused

Office Web Parts / Office Web Components connecting to SQL Server from extranet

Postby DarrylR » Sat, 29 Jan 2005 14:18:46 GMT

I am using Office Web Parts (specifically the PivotView) on several Web Part
pages. The IIS virtual directory serving the pages uses basic security over
SSL. The pages with Office Web Parts on them work correctly when accessed
via our intranet; users are logged on seamlessly using their domain
credentials, and the PivotView parts retrieve data from our SQL Server
database and display it in the page. However, when we access these pages via
our extranet, even if the user logs in using their domain credentials, the
Office Web Parts fail to retrieve data because of a SQL login failure
("Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection."). All other pages on the portal are displayed correctly
from the extranet.
The IIS box (running WSS) is outside our firewall, and the SQL Server box is
behind our firewall. The machines are on different domains with a one-way
trust relationship (the extranet domain trust accounts from our intranet
domain). We've opened the generally accepted ports on the firewall to
support SQL Server (at least we know that WSS is able to access the SQL
Server box to deliver all other portal content). Using connection strings
similar to the following, the Office Web Parts fail to login (when the pages
are accessed from the extranet):

Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security
Info=False;Initial Catalog=ourDB;Data Source=ourSQLserver;
Provider=SQLOLEDB.1;Trusted_Connection=Yes;Persist Security
Info=False;Initial Catalog=ourDB;Data Source=ourSQLserver;

So far, the only way that we've been able to get this to work from the
extranet has been to use SQL Authentication and a connection string similar
to the following:

Provider=SQLOLEDB.1;Persist Security Info=True;User
Id=ourUserId;Password=ourPwd;Initial Catalog=ourDB;Data Source=ourSQLserver;

Obviously, we'd rather not use SQL Authentication, since the connection
string is written to the page, where it is readable in the browser using the
View/Source command. I researched the problem and discovered the following
article (among others) which looked promising:


However, the steps outlined in the article didn't correct the problem. I
also read the following article which suggested that we may need to open
more outbound ports on the firewall to make this work:


I've also seen references to Kerberos authentication that suggest that it
could solve the problem. However, rather than plow blindly ahead, I thought
I'd seek input.

Any suggestions?

Similar Threads:

1.Office Web Parts connecting to SQL Server from extranet

2.Deploying local cub to the web for visitor interaction using Office XP web components

I have created Tests.htm using FrontPage 2003, MS Excel 2002 & Office XP Web
Components.  Tests.htm consists of an excel pivot table with a data source
OlabLab.cub using Office XP Excel Pivot web component.  My objective is to
place Test.htm & the Data Source OlabLab.cub on a secure sub-web for a
visitor to interact with. My problem is that the Data Source is pointed to
my development environment in the deployed Test.htm resulting in a
connection error for the visitor (See Test.htm code snippet below).
"ConnectionString>Provider=MSOLAP.2;Persist Security Info=True;Data
Source=C:\Documents and Settings\Richard A

Is it possible to deploy a local cub to the web for visitor interaction
using Office XP web components?  If yes can you advise on how to set the
data source to the web location?

Thanks in advance.

3.Office Web Components / OLAP Web Client

We are currently running cubes on SQL server 2000 sp3a.  
Everything runs fine with Office XP and the owc10 
installed.  On our test box with Office 2003 with owc11, 
the cubes fail.  No errors, just nothing displayed.  Have 
tried reinstalling PTSfull / lite / owc11 to no success.  
Any advice?

4.Office web components

I am trying to install the client tools, but the installation fails because 
of an older verion of office web components on my machine.
I removed the old version, downloaded version 3 from the MS site and 
installed it. i then tried the install agian, but i still get the same 
Any suggestions?


5.Why do you need the Microsoft Office Web Components for 2005

Our security will not allow up to have the Microsoft Office Web Components.  
I thought it was needed for the books on line but I uninstalled the web 
components and was still able to use BOL.  Does anyone have any idea if we 
could install the client tools on our desktops without the Web Components?  
Or what uses these web components.


Edie Richardson

6. Alternatives replacing Office Web components?

7. Office Web Components & Analysis Services

8. Office Web Component via Internet

Return to Microsoft OFFICE


Who is online

Users browsing this forum: No registered users and 76 guest