|
INTRODUCTION
This article describes how to configure the Excel Services Unattended Service
account to connect to external data sources that require both a user name
string and a password string. These strings are required for authentication in
Excel Services. The Excel Services component is included in Microsoft Office
SharePoint Server 2007.
MORE INFORMATION
We recommend that you use an account that has limited permissions for the
Unattended Service account. Some external data provider connection strings may
contain attributes that try to create temporary files on the computer that is
hosting the external database. For example, the attributes may try to create
temporary cube (.cub) files. Additionally, any workbook that is uploaded to a
computer that is running Excel Services may be able to connect to a data source
for which the unattended account has Read permissions.
Some examples of external data providers are as follows:
• Microsoft SQL Server OLE DB driver (OLE DB)
• Microsoft SQL Server ODBC driver (ODBC)
• Microsoft OLE DB Provider for OLAP Services (MSOLAP)
To configure the Excel Services Unattended Service account, follow these steps:
1- Click Start, point to Administrative Tools, and then click
SharePoint 3.0 Central Administration.
2- On the Central Administration page, click Shared Services
Administration.
3- On the Manage this Farm's Shared Services page, click the
default shared services provider that you want to change.
4- On the Shared Services Administration page, click Edit
Excel Services Settings under Excel Services Settings.
5- Next to External Data, enter the Unattended Service account
information. Make sure that you use an account that has limited Write
permissions.
Note
This step lets the account access the required data. Additionally, this step
helps prevent the account from accessing critical data or sensitive data. This
step also prevents temporary files from being created on the computer that is
hosting the external database.
|