Wednesday, April 04, 2007

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...




1 comment:

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..??

ASP.NET MVC - Sport Facility Booking system

  The project relies on some external service providers. Thus accessing them via their API requires authentication. An API Key need to be su...