The following procedure describes how to configure the required access permissions of the ADFS plug-in to a Microsoft SQL Server database. If you have selected Windows authentication on step 3 of Configuring the ADFS Plug-in, perform the following steps:
Open Microsoft SQL Server Management Studio on an SQL server.
Browse the database and go to the Security - Users section.
Add a new user with the following details:
User type: SQL user with login
User name: LocalSystem
Login name: NT AUTHORITY\SYSTEM
Default schema: dbo
Go to the Membership section and select db_owner.
Click OK.