Sharepoint 2010 Form 身份认证的实现（基于SQL）-阿里云开发者社区

Sharepoint 2010 Form 身份认证的实现（基于SQL）

2010-08-06 757

版权

本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。

本文涉及的产品

云数据库 RDS SQL Server，基础系列 2核4GB

RDS SQL Server Serverless，2-4RCU 50GB 3个月

简介： 废话不说了，我们来看看怎么实现的吧：1：创建一个基于身份认证的应用程序（具体参见上篇基于AD）SQL-MembershipProvider 成员SQL-RoleManager 角色 2：修改...

废话不说了，我们来看看怎么实现的吧：

1：创建一个基于身份认证的应用程序（具体参见上篇基于AD）

SQL-MembershipProvider 成员
SQL-RoleManager 角色

2：修改管理中心，我们创建的应用程序，还有Web服务里面的SecurityTokenServiceApplication 这个3个地方的web.config

每个地方都要加连接数据库的字符串（最好自己新建的账户访问数据库，不然可能访问不到数据）

< connectionStrings >
< add name ="SQLConnectionString" connectionString ="Data Source=jiangly;Initial Catalog=SQL-Auth;User ID=jly;password=P@ssw0rd" />
</ connectionStrings >

找到管理中心的<system.web></system.web>,配置如下：

代码

< roleManager defaultProvider ="AspNetWindowsTokenRoleProvider" enabled ="true" cacheRolesInCookie ="false" >

< providers >

< add connectionStringName ="SQLConnectionString" applicationName ="/" description ="Stores and retrieves roles from SQL Server" name ="SQL-RoleManager" type ="System.Web.Security.SqlRoleProvider, System.Web, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />

</ providers >

</ roleManager >

< membership defaultProvider ="SQL-MembershipProvider" >

< providers >

< add connectionStringName ="SQLConnectionString" passwordAttemptWindow ="5" enablePasswordRetrieval ="false" enablePasswordReset ="false" requiresQuestionAndAnswer ="true" applicationName ="/" requiresUniqueEmail ="true" passwordFormat ="Hashed" description ="Stores and Retrieves membership data from SQL Server" name ="SQL-MembershipProvider" type ="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />

</ providers >

</ membership >

找到应用程序的<system.web></system.web>,配置如下

代码

< membership defaultProvider ="i" >

< providers >

< add name ="i" type ="Microsoft.SharePoint.Administration.Claims.SPClaimsAuthMembershipProvider, Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" />

< add connectionStringName ="SQLConnectionString" passwordAttemptWindow ="5" enablePasswordRetrieval ="false" enablePasswordReset ="false" requiresQuestionAndAnswer ="true" applicationName ="/" requiresUniqueEmail ="true" passwordFormat ="Hashed" description ="Stores and Retrieves membership data from SQL Server" name ="SQL-MembershipProvider" type ="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />

</ providers >

</ membership >

< roleManager defaultProvider ="c" enabled ="true" cacheRolesInCookie ="false" >

< providers >

< add name ="c" type ="Microsoft.SharePoint.Administration.Claims.SPClaimsAuthRoleProvider, Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" />

< add connectionStringName ="SQLConnectionString" applicationName ="/" description ="Stores and retrieves roles from SQL Server" name ="SQL-RoleManager" type ="System.Web.Security.SqlRoleProvider, System.Web, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />

</ providers >

</ roleManager >

找到SecurityTokenServiceApplication站台web.config,它里面没有<system.web></system.web>,你需要自己添加

3 改好后，自己创建一个用户（这个太简单了，我就不讲了哈），加入站点集里，完了。用这个账号去测试吧，哈哈

参考资料：

http://www.sharepointchick.com/archive/2010/05/07/configuring-claims-and-forms-based-authentication-for-use-with-a.aspx

http://social.technet.microsoft.com/Forums/en/sharepoint2010setup/thread/41e5fea7-a2e5-4965-aa5c-78d76be3f4f0

http://devmeat.com/show/5739564

http://blogs.technet.com/b/mahesm/archive/2010/04/07/configure-forms-based-authentication-fba-with-sharepoint-2010.aspx

代码

< system.web >

< roleManager defaultProvider ="c" enabled ="true" cacheRolesInCookie ="false" >

< providers >

< add name ="c" type ="Microsoft.SharePoint.Administration.Claims.SPClaimsAuthRoleProvider, Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" />

< add connectionStringName ="SQLConnectionString" applicationName ="/" description ="Stores and retrieves roles from SQL Server" name ="SQL-RoleManager" type ="System.Web.Security.SqlRoleProvider, System.Web, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />

</ providers >

</ roleManager >

< membership defaultProvider ="i" >

< providers >

< add name ="i" type ="Microsoft.SharePoint.Administration.Claims.SPClaimsAuthMembershipProvider, Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" />

< add connectionStringName ="SQLConnectionString" passwordAttemptWindow ="5" enablePasswordRetrieval ="false" enablePasswordReset ="false" requiresQuestionAndAnswer ="true" applicationName ="/" requiresUniqueEmail ="true" passwordFormat ="Hashed" description ="Stores and Retrieves membership data from SQL Server" name ="SQL-MembershipProvider" type ="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />

</ providers >

</ membership >

转自http://www.cnblogs.com/jlydboy/articles/1794224.html