SqlMembershipProvider的：使用自己的数据库作为用户存储数据库 [英] SqlMembershipProvider: use my own database as user store database

问题描述

我开发一个 ASP.NET 是的Visual Studio 2008 SP1应用和 C＃。我还使用 SQL服务器2008 SP1

我想补充的命令创建的表 aspnet_regsql -S（本地）-E -A米来我自己的数据库。

如果我运行该命令它会创建一个数据库（ ASPNETDB 数据库）与四个表。我想知道，如果有是创建在我自己的数据库这些表的命令（名为 MYDATABASE ，例如）。

和，在创建表时。我如何验证连接到 MYDATABASE

感谢您

解决方案

  aspnet_regsql-C数据源= \\ SQLEX $ P $干燥综合征;集成安全=真;用户实例=真...
 

将通过连接字符串指定数据库生成

此外，你应该配置的MembershipProvider与您的数据库工作。只需添加到您的web.config

 ＆LT;结构＆gt;
  ＆LT;＆是connectionStrings GT;
    ＆LT;添加名称=SqlServices的connectionString =数据源= \\ SQLEX $ P $干燥综合征;集成安全=真;用户实例=真/＆GT;
  ＆LT; /＆是connectionStrings GT;
  ＆LT;＆的System.Web GT;
    ＆LT;身份验证模式=表格＆GT;
      ＆LT;形式loginUrl =login.aspx的
        NAME =。ASPXFORMSAUTH/＆GT;
    ＆LT; /认证＆GT;    ＆LT;会员defaultProvider =sqlProvider的
      userIsOnlineTimeWindow =15＆GT;
      ＆LT;供应商＆GT;
        ＆LT;添加
          NAME =sqlProvider的
          类型=System.Web.Security.SqlMembershipProvider
          的connectionStringName =SqlServices
          的applicationName =所有MyApplication
          enablePasswordRetrieval =假
          enablePasswordReset设置=真
          requiresQuestionAndAnswer =真
          requiresUniqueEmail =假
          了passwordFormat =散列
          maxInvalidPasswordAttempts =5
          passwordAttemptWindow =10/＆GT;
      ＆LT; /供应商＆GT;
    ＆LT; /会员＆GT;
  ＆LT; /system.web>
＆LT; /结构＆gt;
 

I'm developing an ASP.NET application with Visual Studio 2008 SP1 and C#. I'm also using Sql Server 2008 SP1.

I'm trying to add the tables created with the command aspnet_regsql -S (local) -E -A m to my own database.

If I run that command it will create a database (Aspnetdb database) with four tables. I want to know if there is a command that creates those tables in my own database (called myDatabase, for example).

And, when the tables are created. How can I connect authentication to myDatabase?

Thank you

解决方案

aspnet_regsql-C "Data Source=.\SQLEXPRESS;Integrated Security=True;User Instance=True" ...

will generate in database given by connection string

Also you should configure MembershipProvider to work with your database. Just add this to your web.config

<configuration>
  <connectionStrings>
    <add name="SqlServices" connectionString="Data Source=.\SQLEXPRESS;Integrated Security=True;User Instance=True" />
  </connectionStrings>
  <system.web>
    <authentication mode="Forms" >
      <forms loginUrl="login.aspx"
        name=".ASPXFORMSAUTH" />
    </authentication>

    <membership defaultProvider="SqlProvider"
      userIsOnlineTimeWindow="15">
      <providers>
        <add 
          name="SqlProvider" 
          type="System.Web.Security.SqlMembershipProvider" 
          connectionStringName="SqlServices"
          applicationName="MyApplication"
          enablePasswordRetrieval="false"
          enablePasswordReset="true"
          requiresQuestionAndAnswer="true"
          requiresUniqueEmail="false"
          passwordFormat="Hashed"
          maxInvalidPasswordAttempts="5"
          passwordAttemptWindow="10" />
      </providers>
    </membership>
  </system.web>
</configuration>

这篇关于SqlMembershipProvider的：使用自己的数据库作为用户存储数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！