Prev: document libary
Next: MOSS 2007: how to disable the dialog "You are about to open.." when clicking a pdf file in a document libary
From: faisalakhtar12 on 30 Jul 2007 12:36
I am trying to connect to an external data source using excel
services. I have done the following

1) Added the data connection library to the trusted list.
2) Added the document library to the trusted file locations
3) Made sure the data provider for SQL server is installed on all
server in my farm and included it in the trusted data provider list
4) Made sure the ODC file resides in the trusted data connection
library.
5) Made sure the credentails are inside the ODC (less secure I know
but I am just trying to test some capabilities of Excel services) and
specified authentication as "None".I do not have Kerberos enabled and
I don;t believe I need it if the data connection is embedded in the
ODC file.
6) Made sure to allow data connection to be embedded in Excel files as
well as from trusted data connection libraries.


I still cannot connect to the external data

here is the log file

Timestamp Process TID
Area Category EventID
Level Message Correlation
07/30/2007 10:49:57.66 w3wp.exe (0x12D4)
0x0CC8 Excel Services Excel Calculation Services
2m5e Information Session opened with workbook
http://powerteamweb.exeloncorp.com/bizsys/projects/fusionmanagement/Ravis
Speadsheet test/Connection File.xlsx. [Session: 23.1942skGUHD/7u/
QOiDoybxY90.5.en-US5.en-US73.+0300#0000-11-00-01T02:00:00:0000#
+0000#0000-03-00-02T02:00:00:0000#-0060 User: POWERTEAM\u999fa9]
00000264-79bc-536e-0000-000050f7b00b
07/30/2007 10:52:34.59 w3wp.exe (0x12D4)
0x0CC8 Excel Services Excel Calculation Services
8trr Information Session closed workbook . [Session: 23.1955ZzIZ1+BMYc/
b8myvKmL90.5.en-US5.en-US73.+0300#0000-11-00-01T02:00:00:0000#
+0000#0000-03-00-02T02:00:00:0000#-0060 User: POWERTEAM\u999fa9]
00000266-79bc-536e-0000-000050f7b00b
07/30/2007 10:52:34.59 w3wp.exe (0x12D4)
0x0CC8 Excel Services Excel Calculation Services
5cb1 Warning Failed to load 'http://powerteamweb.exeloncorp.com/
bizsys/projects/fusionmanagement/Ravis Speadsheet test/Connection
File.xlsx' with error: 'The workbook contains features that are not
supported by Excel Services. External data ranges (also called query
tables)'. [Session: 23.1955ZzIZ1+BMYc/b8myvKmL90.5.en-US5.en-
US73.+0300#0000-11-00-01T02:00:00:0000#
+0000#0000-03-00-02T02:00:00:0000#-0060 User: POWERTEAM\u999fa9]
00000266-79bc-536e-0000-000050f7b00b
07/30/2007 11:07:52.97 svchost.exe (0x07C0)
0x0590 ULS Logging Unified Logging Service
41hj High Unable to open config regkey, using defaults
07/30/2007 11:09:36.16 w3wp.exe (0x12D4)
0x133C Excel Services Excel Calculation Services
2m5e Information Session opened with workbook
http://powerteamweb.exeloncorp.com/bizsys/projects/fusionmanagement/Ravis
Speadsheet test/Demond test Database Adventure Works.xlsx. [Session:
23.196s71rP9b6mOsFjcoWqL/d90.5.en-US5.en-
US73.+0300#0000-11-00-01T02:00:00:0000#
+0000#0000-03-00-02T02:00:00:0000#-0060 User: POWERTEAM\u999fa9]
00000267-79bc-536e-0000-000050f7b00b
07/30/2007 11:09:44.53 w3wp.exe (0x12D4)
0x12A4 Excel Services Excel Services External Data
6k5r Verbose CredentialsProvider.GetCredentials: Getting credentials
for external source: CCCMSDSQLCLSTR1.ENERGY.POWER.CORP AdventureWorks
vSalesPersonSalesByFiscalYears, with CredentialsMethod Integrated
00000269-79bc-536e-0000-000050f7b00b
07/30/2007 11:09:44.53 w3wp.exe (0x12D4)
0x12A4 Excel Services Excel Services External Data
483a Warning Excel Services can not use credential delegation when it
is configured to use a trusted subsystem with Windows SharePoint
Server. [Session: 23.196s71rP9b6mOsFjcoWqL/d90.5.en-US5.en-
US73.+0300#0000-11-00-01T02:00:00:0000#
+0000#0000-03-00-02T02:00:00:0000#-0060 User: POWERTEAM\u999fa9]
00000269-79bc-536e-0000-000050f7b00b
07/30/2007 11:09:44.53 w3wp.exe (0x12D4)
0x12A4 Excel Services Excel Services External Data
6k5u Verbose CredentialsProvider.ProcessCancel: Processing cancel of
the credentials for external source with data connection name:
CCCMSDSQLCLSTR1.ENERGY.POWER.CORP AdventureWorks
vSalesPersonSalesByFiscalYears 00000269-79bc-536e-0000-000050f7b00b
07/30/2007 11:16:13.35 w3wp.exe (0x12D4)
0x1290 Excel Services Excel Services External Data
6wv3 Information The ODC file C:/Documents%20and%20Settings/u999fa9/My
%20Documents/My%20Data%20Sources/KSQMSDSQL01%20Northwind
%20Invoices.odc is not in a DCL that is trusted by Excel Services. To
fix this problem, add the DCL to the trusted DCL list in the
administrator console. 0000026c-79bc-536e-0000-000050f7b00b
07/30/2007 11:16:13.38 w3wp.exe (0x12D4)
0x1290 Excel Services Excel Services External Data
8xk9 Medium ExternalSource.ExecuteOperation: We exhausted all
available connection information. Exception:
Microsoft.Office.Excel.Server.CalculationServer.Interop.ConnectionInfoException:
Exception of type
'Microsoft.Office.Excel.Server.CalculationServer.Interop.ConnectionInfoException'
was thrown. at
Microsoft.Office.Excel.Server.CalculationServer.ConnectionInfoManager.GetConnectionInfo(Request
request, String externalSourceName, Int32 externalSourceIndex,
Boolean& shouldReportFailure) at
Microsoft.Office.Excel.Server.CalculationServer.ExternalSource.ExecuteOperation(Request
request, ExternalSourceStateInfo externalSourceStateInfo,
ExternalSourceStateInfo prevExternalSourceStateInfo, Int32 index,
ConnectionInfoManager connectionInfoManager, ExternalDataScenario
scenario, DataOperation dataOpe...
0000026c-79bc-536e-0000-000050f7b00b
07/30/2007 11:16:13.38* w3wp.exe (0x12D4)
0x1290 Excel Services Excel Services External Data
8xk9 Medium ...ration), Data Connection Name: KSQMSDSQL01 Northwind
Invoices3, SessionId: 23.197WzFFbvQWB9W7FD1Na2gL90.5.en-US5.en-
US73.+0300#0000-11-00-01T02:00:00:0000#
+0000#0000-03-00-02T02:00:00:0000#-0060, UserId: POWERTEAM\u999fa9
0000026c-79bc-536e-0000-000050f7b00b
07/30/2007 11:16:13.38 w3wp.exe (0x12D4)
0x1290 Excel Services Excel Calculation Services
2m5e Information Session opened with workbook
http://powerteamweb.exeloncorp.com/bizsys/projects/fusionmanagement/Ravis
Speadsheet test/KSQMSDSQL01 Northwind Invoices.xlsx. [Session:
23.197WzFFbvQWB9W7FD1Na2gL90.5.en-US5.en-
US73.+0300#0000-11-00-01T02:00:00:0000#
+0000#0000-03-00-02T02:00:00:0000#-0060 User: POWERTEAM\u999fa9]
0000026c-79bc-536e-0000-000050f7b00b
07/30/2007 11:17:10.43 w3wp.exe (0x12D4)
0x1294 Excel Services Excel Services External Data
8xk9 Medium ExternalSource.ExecuteOperation: We exhausted all
available connection information. Exception:
Microsoft.Office.Excel.Server.CalculationServer.Interop.ConnectionInfoException:
Exception of type
'Microsoft.Office.Excel.Server.CalculationServer.Interop.ConnectionInfoException'
was thrown. at
Microsoft.Office.Excel.Server.CalculationServer.ConnectionInfoManager.GetConnectionInfo(Request
request, String externalSourceName, Int32 externalSourceIndex,
Boolean& shouldReportFailure) at
Microsoft.Office.Excel.Server.CalculationServer.ExternalSource.ExecuteOperation(Request
request, ExternalSourceStateInfo externalSourceStateInfo,
ExternalSourceStateInfo prevExternalSourceStateInfo, Int32 index,
ConnectionInfoManager connectionInfoManager, ExternalDataScenario
scenario, DataOperation dataOpe...
0000026e-79bc-536e-0000-000050f7b00b
07/30/2007 11:17:10.43* w3wp.exe (0x12D4)
0x1294 Excel Services Excel Services External Data
8xk9 Medium ...ration), Data Connection Name: KSQMSDSQL01 Northwind
Invoices3, SessionId: 23.197WzFFbvQWB9W7FD1Na2gL90.5.en-US5.en-
US73.+0300#0000-11-00-01T02:00:00:0000#
+0000#0000-03-00-02T02:00:00:0000#-0060, UserId: POWERTEAM\u999fa9
0000026e-79bc-536e-0000-000050f7b00b
07/30/2007 11:18:23.85 w3wp.exe (0x12D4)
0x1298 Excel Services Excel Services External Data
8xk9 Medium ExternalSource.ExecuteOperation: We exhausted all
available connection information. Exception:
Microsoft.Office.Excel.Server.CalculationServer.Interop.ConnectionInfoException:
Exception of type
'Microsoft.Office.Excel.Server.CalculationServer.Interop.ConnectionInfoException'
was thrown. at
Microsoft.Office.Excel.Server.CalculationServer.ConnectionInfoManager.GetConnectionInfo(Request
request, String externalSourceName, Int32 externalSourceIndex,
Boolean& shouldReportFailure) at
Microsoft.Office.Excel.Server.CalculationServer.ExternalSource.ExecuteOperation(Request
request, ExternalSourceStateInfo externalSourceStateInfo,
ExternalSourceStateInfo prevExternalSourceStateInfo, Int32 index,
ConnectionInfoManager connectionInfoManager, ExternalDataScenario
scenario, DataOperation dataOpe...
00000271-79bc-536e-0000-000050f7b00b
07/30/2007 11:18:23.85* w3wp.exe (0x12D4)
0x1298 Excel Services Excel Services External Data
8xk9 Medium ...ration), Data Connection Name: KSQMSDSQL01 Northwind
Invoices3, SessionId: 23.197WzFFbvQWB9W7FD1Na2gL90.5.en-US5.en-
US73.+0300#0000-11-00-01T02:00:00:0000#
+0000#0000-03-00-02T02:00:00:0000#-0060, UserId: POWERTEAM\u999fa9
00000271-79bc-536e-0000-000050f7b00b


What gives? What does it mean that all available connection
information was exhausted.

 | 
Pages: 1
Prev: document libary
Next: MOSS 2007: how to disable the dialog "You are about to open.." when clicking a pdf file in a document libary