SharePoint Designer to connect using a mock custom identity when creating BCS

When you create BCS using SharePoint Designer, we typically use a user identity for a database connection.

This way, in most cases, the database uses Windows Authentication mode so that when we use Windows users, we can view external data.

However, this operation needs to be in the data to NT authority\authenticated users this user plus read and write permissions, site users can operate external data.

So if we can't add such a user to the data and have only one database operating account, how do we handle it?

This time we need to "connect using a mock custom identity"

This method has two steps,

The first step is to set up an account and password to access the database in the SSS (Secure Store Service).

1. Open "Management Center"-"Management Service Application"-"Secure Store Service"

2. Click to enter, click on the Ribbon operation area "new"

3. Enter the relevant information in the new screen

4. Click Next, the field name, you can enter your own can remember, and at a Glance name, field type, select "username" and "password"

5. Click Next, this position is a must fill in, enter a management account can be. Click OK.

6. At this time, there will be a message called "Sa" in the SSS. In the Drop-down menu, select Set Credentials

7. In this screen, enter the user name and password for the login database, such as sa password 123456

8. Click OK. This time the credentials of the connection data are set,

The second step is to configure connection properties in the BCS connection

1. Open the Web site by opening SharePoint Designer

2. Select "External Content type"

3. Create a new "external content type", this step omits

4. In the location of the external system, click the link for the data source definition action

5. Click "Add Connection"

6. In the connection type, select SQL Server