Microsoft Office Tutorials and References
In Depth Information
In the “Specify credential fields” window, leave the defaults and click Next.
In the Members settings, add administrators to the Target Application Administrators list
who should have full control on the target applications and click OK.
On returning to the Secure Store Services management window, select the Target
Application ID created in the previous steps and click the Set button on the Credentials
section of the ribbon.
In the “Set Credentials for Secure Store Target Application (Individual)” window, enter a
value for the Credential Owner as well as values for Windows User Name and Windows
Password, and confirm the Windows Password value. Notice that in this case you are setting
a domain account, not a SQL Server account. It is important that the user credentials you
enter have permissions on SQL Server database tables. Click OK to close the window.
Launch SharePoint Designer, and open your SharePoint site. On the Site Objects menu,
choose External Content Types and select the ECT you created (EmployeesList_From_HR).
Click on either the Edit Connection Properties button on the ribbon in the Connection
Properties section or the External System link in the External Content Type Information
In the Connection Properties windows, on the Default tab, choose Impersonate
Windows Identity for the Authentication Mode. Enter the previously created Secure Store
Application ID in the appropriate box as shown in Figure 4-20 , and click OK.
Figure 4-20. Set Secure Store Service Application ID for ECT database connection properties
Search JabSto ::