MOSS 2007 'no match found' when trying to add users from sqlmembership database as Administrators

'no match found' problem in MOSS 2007:

After enabling your Form Authentication using SQL Membership Provider, when you try to add users using Site collection administrators under the SharePoint Site Management inside Application Management of your Central administrator you will get 'no match found'. To resolve this problem.

Root through the path C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\CONFIG and open your machine.config and get the membership and role provider details under your system.web tag.

<system.web>
<processModel autoConfig="true" />
<httpHandlers />
<membership>
<providers>
<add name="AspNetSqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" connectionStringName="LocalSqlServer" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="true" applicationName="/" requiresUniqueEmail="false" passwordFormat="Hashed" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="7" minRequiredNonalphanumericCharacters="1" passwordAttemptWindow="10" passwordStrengthRegularExpression="" />
</providers>
</membership>
<profile>
<providers>
<add name="AspNetSqlProfileProvider" connectionStringName="LocalSqlServer" applicationName="/" type="System.Web.Profile.SqlProfileProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
</providers>
</profile>
<roleManager>
<providers>
<add name="AspNetSqlRoleProvider" connectionStringName="LocalSqlServer" applicationName="/" type="System.Web.Security.SqlRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
<add name="AspNetWindowsTokenRoleProvider" applicationName="/" type="System.Web.Security.WindowsTokenRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
</providers>
</roleManager>
</system.web>

Use your machine.config membership, roleManager and other details in your central administrator and your web site's web.config.

Then your 'no match found' problem will be solved and you will get the perfect result like this...




Comments

mrYuz said…
i aggree with the solution given, but it will not solve the role issue. In the site that you created if you wanted to add user in a group based on their role. Example i already created a group called "Designer" in my site and i wanted to give rights to all user that has the role "RoleDesigner". i already have 10 user in aspnetdb with that role. So i need to select the role "RoleDesigner" as the member of the "Designer" group automatically all my 10 member falls under this group. but unfortunately MOSS 2007 could not find the role "RoleDesigner". So as a workaround, i had to put all the 10 user name. any idea / solution on this..??

Popular posts from this blog

ASP.NET website "Cannot read configuration file due to insufficient permissions" in IIS 7 and Windows Server 2008

Error occurred in deployment step 'Install app for SharePoint': The System Account cannot perform this action.

Embrassing screen sharing interview : SharePoint