Excel Service uses one of the external data-embedded data connection based on SQL Authentication

Demonstrate SQL Authentication-based embedded data connection to access data in the SQL database

Reference

Configuring an Excel Services data access http://technet.microsoft.com/zh-cn/library/hh223283.aspx with an embedded data connection

 

The prerequisite is to complete the configuration of the Excel Services unattended service account

1. Create an SQL account: ExcelReader with the read-only permission of PSMIS2 Database

Configure the SQL Server to record successful and failed logins so that we can verify that excel Service is logged on with ExcelReader.

2.create a new excel coal.xlsx, insert a PivotTable, and use an external data source

3. We want to create a new data source.

4. Configure the Excel Service for identity authentication. Because we need to embed the account and password directly into the Excel file, we do not need the Excel Service to provide identity authentication for the database. Therefore, we choose none,

You must configure an Excel Service account for which no one participates. Otherwise, the Excel Service reports an error.

5. Select the columns to be displayed and the display format. How to Create a beautiful chart is not described here

 

5. Configure embedded data connection information

If you do not select a connection file, select Save Password.

Security Prompt, select "yes"

Confirm that verification is set to none

 

 

6. Publish to Sharepoint

The publishing option can be set to publish the entire workbook or a project in it. This function is very good and you have the opportunity to introduce it again.

Select content type

7. The release is complete. Check the SQL log to verify whether the database is accessed by ExcelReader.

You can see the log of the ExcelReader logon.