我向我的开发团队介绍了 Git，除了我之外，每个人都讨厌它。他们想用 Team Foundation Server
替换它。我觉得这是一个巨大的倒退，虽然我对 TFS 不是很熟悉。有经验的人可以将 TFS 上的分支支持与 Git 分支进行比较吗？另外，总的来说，TFS
的优缺点是什么？使用 Git 几年后我会讨厌它吗？

解决方法

解决方法

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