September 1, 2011
Note that when entering the connection string there is no validation or feedback to the administrator. If there is a problem you usually won’t see it until you setup a claims rule that uses it and you get an error. So make certain to carefully build and test your connection string. Remember that if you use integrated authentication to connect to the SQL Server that it will run under the context of your ADFS Service account so you will need to grant your ADFS service account permissions to the SQL Server and Database.
For example you might get event 149
During processing of the Federation Service configuration, the attribute store ‘SQLClaims’ could not be loaded.
Attribute store type: Microsoft.IdentityServer.ClaimsPolicy.Engine.AttributeStore.Sql.SqlAttributeStore, Microsoft.IdentityServer.ClaimsPolicy
If you are using a custom attribute store, verify that the custom attribute store is configured using AD FS 2.0 Management snap-in.
POLICY3906: Could not parse the parameter as a valid connection string.