admin管理员组

文章数量:1558091

  1.  create a user in sqlserver
    1. server -> security - > right click logins ->  new login
    2. in General page,
      1. fill login name
      2. sql server authentication (radio button)
      3. uncheck Enforce pass policy
      4. drop down list
        1. default DB -> select your DB  (could leave it)
        2. default language -> English  
  2. Add the new user to be your DB user  (create a user to a certain DB, this user is not real DB owner, but could set permission as owner. Set the real DB owner see bottom, if set a real owner, could skip this step )
    1. your DB -> security -> right click user -> new user
      1. in General page
        1. fill the User name
        2. put your new created user to Login name
        3. don't select schema
        4. in DB Role membership ->  check the DB owner
  3. set the server authentication type
    1. right click server -> property -> security in left Panel
    2. select the SQL server and Windows Authentication mode (radio button)

set up your program configuration file

  1. connection string
  2. user, role provider
  3. create the membership user role table (createUserWizard in web app)
  4. use ASP adminstrator configuration tool (add,edit,delete user and role)


    Set the DB Owner (normally leave as the default)

    select the certain DB, right click property, in left page, click Files, browse for a owner. then OK.  (this could replace step 2)


本文标签： LoginsqlservercreateUserauthentication

版权声明：本文标题：create sqlserver login user and add it to certain db user (sqlserver authentication) 内容由热心网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：https://m.elefans.com/dianzi/1727341513a1109470.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。