SharePoint creates a secure store in the Management Center

SharePoint creates a secure storesss (secure Store service) in the management center as a core service, because many other services require this service to work. One of its functions is to provide a secure database and store creden。 associated with the Application ID. These IDS are used to access the content of the external data source. This is achieved by creating an account in the secure store database. Secure store is used to store IDs and access the data source displayed on the dashboard. These are external data sources such as SQL Server or sap. Moss 2007 also provides this function by using the application proxy ID. The problem here is that it does not follow the minimum permission account rules. SharePoint 2010 uses the new secure store and IDs completely separated from the proxy. This means that an account can be created only when the account has the permission to access data. This article teaches you how to create a secure store. Preparation: You must be the service administrator of the secure Store service, or the field administrator. Create an ad account, which will be configured as the application pool ID for creating this service application. Start: 1. Open the management center. 2. Application Management-manage service applications. 3. Create the -- secure Store service. 4. If a form appears, enter the following fields. Name: Enter the Service Application name. Database Server: the name of the SQL server machine. Database Name: the name of the secure store to be created. You can modify the guid following the name. Database verification: Select windows verification. Failover server: if there is a server configuration, enter it. This will not create a Failover database. Application pool: Create an application pool and name it. Select security account: select the configurable and existing domain name account. Enable logs: 30 days by default. Click OK to return to the Service Application List page.
5. Click the newly created SSA (secure Store application ).
6. Generate a key-encrypted database. The password must be at least 8 characters long and contain at least three elements: uppercase, lowercase, number, and special characters.

7. Click OK. Also, powershell can be used to create SSSa (secure Store service application) instead of the interface ). Make sure that SSS is running before creation. You can confirm as follows: 1. Open the management center. 2. Click system settings. 3. Click Manage services on the server under the server. 4. Make sure that the SSS is enabled. Run the following command to create an SSSa:
Run the following command to generate or refresh the key:
Run the following command to obtain the list of running services:
More information: the password should be backed up, because it may be needed if you have to restore a backup secure store database or add a new application server to this field.