Configure Central administration to support membership and role:
a) Open the Central Administration sites web.config (mine at C:\inetpub\wwwroot\wss\VirtualDirectories\11112)
b) Add connection string
<connectionStrings>
<clear/>
<add
name="LocalSqlServer"
connectionString="server=.;database=aspnetdb;Integrated
Security=SSPI;"
providerName="System.Data.SqlClient"/>
</connectionStrings>
c) Add Membership provider
<membership
defaultProvider="SqlMembershipProvider">
<providers>
<add
connectionStringName="LocalSqlServer"
passwordAttemptWindow="10"
enablePasswordRetrieval="false"
enablePasswordReset="true"
requiresQuestionAndAnswer="false"
applicationName="/"
minRequiredPasswordLength="5"
maxInvalidPasswordAttempts="5"
minRequiredNonalphanumericCharacters="0"
requiresUniqueEmail="false"
passwordFormat="Hashed"
description="Stores
and retrieves membership data from the Microsoft SQL Server database"
name="SqlMembershipProvider"
type="System.Web.Security.SqlMembershipProvider,
System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
/>
</providers>
</membership>
d) Add Role provider
<roleManager
enabled="true"
defaultProvider="AspNetWindowsTokenRoleProvider"
>
<providers>
<add
name="SqlRoleProvider"
type="System.Web.Security.SqlRoleProvider,
System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
connectionStringName="LocalSqlServer"
applicationName="/"
description="Stores
and retrieves role data from the Microsoft SQL Server database"/>
</providers>
</roleManager>
e) Add
People Picker Wildcard
<PeoplePickerWildcards>
<clear
/>
<add
key="SqlMembershipProvider"
value="%"
/>
</PeoplePickerWildcards>