Office Web Parts / Office Web Components connecting to SQL Server from extranet
by 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:
http://www.**--****.com/
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:
http://www.**--****.com/
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
Hello
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
Ouellette.RICKMDS\Desktop\OlabLab.cub"
Question
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.
Rick
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
error.
Any suggestions?
Thanks
Saira
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.
Thanks,
Edie Richardson
6. Alternatives replacing Office Web components?
7. Office Web Components & Analysis Services
8. Office Web Component via Internet